How to Resolve ORA-44305: service is running

  • by

ORA-44305

Tried to delete a 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.

Leave a Reply

Your email address will not be published. Required fields are marked *