postclone task (4) fix dba_services

New services are created during the cloning procedure. However, old services are not removed. Using dbms_service.delete_service(‘NAME’) to delete them.

SQL> col NAME format a20
SQL> col NETWORK_NAME format a45
SQL> select NAME,NETWORK_NAME,enabled from dba_services;

NAME NETWORK_NAME ENA
-------------------- --------------------------------------------- ---
SYS$BACKGROUND NO
SYS$USERS NO
PROD.powellind.com PROD.powellind.com
PROD PROD
PROD2 PROD2
PROD1 PROD1
PRODN.POWELLIND.COM PRODN.POWELLIND.COM
PRODN2 PRODN2
PRODN1 PRODN1
PRODN PRODN
APPLSYS.WF_CONTROL SYS$APPLSYS.WF_CONTROL.PRODN.POWELLIND.COM NO
DEV.POWELLIND.COM DEV.POWELLIND.COM NO
DEV2 DEV2 NO
DEV1 DEV1 NO
DEV DEV NO


SQL> exec dbms_service.delete_service('PROD.powellind.com');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('PROD');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('PROD2');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('PROD1');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('PRODN.POWELLIND.COM');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('PRODN2');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('PRODN1');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('PRODN');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.STOP_SERVICE('APPLSYS.WF_CONTROL');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('APPLSYS.WF_CONTROL');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.create_service('APPLSYS.WF_CONTROL','SYS$APPLSYS.WF_CONTROL.DEV.POWELLIND.COM');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.start_SERVICE('APPLSYS.WF_CONTROL');

PL/SQL procedure successfully completed.

It is clean now:

SQL> select NAME,NETWORK_NAME,enabled from dba_services;

NAME NETWORK_NAME ENA
-------------------- --------------------------------------------- ---
SYS$BACKGROUND NO
SYS$USERS NO
APPLSYS.WF_CONTROL SYS$APPLSYS.WF_CONTROL.DEV.POWELLIND.COM NO
DEV.POWELLIND.COM DEV.POWELLIND.COM NO
DEV2 DEV2 NO
DEV1 DEV1 NO
DEV DEV


Reference:

1. Explicitly removing a Queue Service in RAC environment causes ORA-00600 [1 KWQVSS] [ID 602648.1]