ORA-44311, ORA-44305, ORA-06512 during delete old services ....

When : -

Clone instance

What : -

ERROR at line 1:
ORA-44305: service EBS_PATCH is 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 421
ORA-06512: at line 1

Why :-

In my enviornment , two RAC node I got this error when this service is running on any one of the rac instance.

Solution :-

On node1:

=========

[oracle@del1os1 ~]$ srvctl stop service -d ttrn -s EBS_PATCH

PRCR-1001 : Resource ora.ttrn.ttrn_ebs_patch.svc does not exist

On node1 and node2

==================

[oracle@del1os2 ~]$ . ./ttrn.env

[oracle@del1os2 ~]$  sqlplus '/as sysdba'

SYS@TTRN2>exec DBMS_SERVICE.STOP_SERVICE('EBS_PATCH');

PL/SQL procedure successfully completed.

SYS@TTRN2>exec DBMS_SERVICE.DELETE_SERVICE('EBS_PATCH');

PL/SQL procedure successfully completed.

It worked for my enviornment. So if you face this issue we might have one of this solution.

Thanks,

searchinoracle