ORA-44305: service is running ORA-44311: service not running when STOP or DELETE a Service

 

I got this error when I tried to delete a service which is not required anymore.

SQL> exec dbms_service.delete_service('orcltemp');
BEGIN dbms_service.delete_service('orcltemp'); END;

*
ERROR at line 1:
ORA-44305: service orcltemp is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 1

 Tried to stop the service but got below error. 

SQL> exec DBMS_SERVICE.STOP_SERVICE('orcltemp');
BEGIN DBMS_SERVICE.STOP_SERVICE('orcltemp'); END;

*
ERROR at line 1:
ORA-44311: service orcltemp not running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 40
ORA-06512: at "SYS.DBMS_SERVICE", line 519
ORA-06512: at line 1

 Tried to stop service in all instances.  

SQL> exec DBMS_SERVICE.STOP_SERVICE('orcltemp',DBMS_SERVICE.ALL_INSTANCES);
PL/SQL procedure successfully completed.

Once service is stopped it's deleted successfully.

  

SQL> exec DBMS_SERVICE.DELETE_SERVICE('orcltemp');
PL/SQL procedure successfully completed.