Skip to content

How to Resolve ORA-44305: service is running

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.

2 thoughts on “How to Resolve ORA-44305: service is running”

  1. 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>

Leave a Reply

Your email address will not be published.