FAILED: File ADZDPREP.sql In Online Patching with ORA-44303: service name exists

ERROR:

======

sqlplus -s APPS/***** @/mwdb-pl/ebsap/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mwdb-pl/ebsap/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDPREP.sql &un_apps &pw_apps &systempwd'

Connected.

PL/SQL procedure successfully completed.

Connected.

Session altered.

PL/SQL procedure successfully completed.

Commit complete.

begin

*

ERROR at line 1:

ORA-44303: service name exists

ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 21

ORA-06512: at "SYS.DBMS_SERVICE", line 316

ORA-06512: at "APPS.AD_ZD_PREP", line 388

ORA-01403: no data found

ORA-06512: at "APPS.AD_ZD_PREP", line 382

ORA-06512: at line 4

CAUSE:

======

Found to have ebs_patch already in all_services

SQL> select SERVICE_ID,NAME from all_services;

SERVICE_ID NAME

---------- ----------------------------------------------------------------

  1 SYS$BACKGROUND

  2 SYS$USERS

  5 ebs_patch

Online Enable patch will try to create the ebs_patch service in the all_services table. 

If the service is already present in all_services table, then the patch worker will fail while executing ADZDPREP.sql script with below error.

SOLUTIONS:

==========

Check the output of Below query

select SERVICE_ID,NAME from dba_services;

If ebs_patch exists then Please perform below action plan.

begin

  DBMS_SERVICE.STOP_SERVICE(service_name =>'ebs_patch');

  DBMS_SERVICE.DELETE_SERVICE(service_name =>'ebs_patch');

end;

Please check below query and make sure that "ebs_patch" does not exist.

select SERVICE_ID,NAME from dba_services;

If no entry found then commit the session.

Then, restart the patch.