ORA-44305
Tried to delete a non-default service from the database, but it failed with ORA-44305.
SQL> exec dbms_service.delete_service('ERPAPP2');
BEGIN dbms_service.delete_service('ERPAPP2'); END;
*
ERROR at line 1:
ORA-44305: service ERPAPP2 is running
ORA-06512: at "SYS.DBMS_SERVICE", line 68
ORA-06512: at "SYS.DBMS_SERVICE", line 458
ORA-06512: at line 1
As error message revealed, ORA-44305 means that the service you want to delete is running for the database, you should stop it before deleting it.
SQL> exec dbms_service.stop_service('ERPAPP2', DBMS_SERVICE.ALL_INSTANCES);
PL/SQL procedure successfully completed.
Then drop it.
SQL> exec dbms_service.delete_service('ERPAPP2');
PL/SQL procedure successfully completed.
Please note that, the default service of database cannot be deleted.
It doesn’t work …
>sqlplus ‘/ as sysdba’
SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 29 16:32:22 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
SQL> EXEC DBMS_SERVICE.STOP_SERVICE(‘A12345678’, DBMS_SERVICE.ALL_INSTANCES);
PL/SQL procedure successfully completed.
SQL> EXEC DBMS_SERVICE.DELETE_SERVICE(‘A12345678’);
BEGIN DBMS_SERVICE.DELETE_SERVICE(‘A12345678’); END;
*
ERROR at line 1:
ORA-44305: service D04896AP1 is running
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.DBMS_SERVICE_ERR”, line 26
ORA-06512: at “SYS.DBMS_SERVICE”, line 363
ORA-06512: at line 1
SQL>
If the service is the default one of the database, it cannot be deleted.