Symptoms:
Online Enablement Patch log and worker log shows below
ATTENTION: All workers either have failed or are waiting:
FAILED: file ADZDPREP.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Thu Apr 06 2023 11:55:08
prodapp(oracle):/dodiapps/prod/prodapps/fs1/EBSapps/appl/admin/PROD/log
$
Worker log says below
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 392
ORA-01403: no data found
ORA-06512: at “APPS.AD_ZD_PREP”, line 386
ORA-06512: at line 4
Time when worker failed: Thu Apr 06 2023 11:55:08
However, there was no ebs_patch observed at PDB level
SQL> select SERVICE_ID,NAME from all_services;
SERVICE_ID NAME
———- —————————————————————-
2 ebs_PROD
3 PROD
1 PROD
SQL>
Solution:
1. Verify if query return ebs_patch:
SQL> select c.name from cdb_services c, service$ s where s.deletion_date is null and s.name = c.name;
2. Execute below commands at CDB level
exec dbms_service.stop_service(‘ebs_patch’);
exec dbms_service.delete_service(‘ebs_patch’);
3. Verify if query return ebs_patch:
SQL> select c.name from cdb_services c, service$ s where s.deletion_date is null and s.name = c.name;
This should not list ebs_patch.
4. If not then proceed for restarting the patch from adctrl option-2
Metalink Reference:
Known Issue: FAILED: File ADZDPREP.sql In Online Patching with ORA-44303: service name exists (Doc ID 2060543.1).
Orama.blog 