Sunday, 1 December 2013

Online Patching Enablement patch(13543062:R12.AD.C) is failing with error "ORA-44305: service ebs_patch is running"

Online Patching Enablement patch: 13543062:R12.AD.C.

ORA-44305: service ebs_patch is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 454
ORA-06512: at "SYS.DBMS_SERVICE", line 375
ORA-06512: at "APPS.AD_ZD_PREP", line 308
ORA-06512: at line 4

Checked the error message with oerr utility

oerr ora 44305

44305, 0000, "service %s is running"
// *Document : Yes
// *Cause    : The specified service was running.
// *Action   : This message is informational only.

Actually the line 308 in package APPS.AD_ZD_PREP is where the error is happening.

The  line 308 in the package APPS.AD_ZD_PREP is executing the procedure dbms_service.start_service, as the service is already running the said error was thrown. So dbms_service.stop_service is executed explicitly to stop the service and adctrl is used to restart the failed worker. The adpatch continued to run and completed successfully.

2 comments:

  1. Online Patching Enablement Patch 13543062 Fails With Error ORA-44305: Service Ebs_patch Is Running (Doc ID 1917886.1)
    connect as sysdba
    exec dbms_service.STOP_SERVICE('ebs_patch');

    restart the failed worker

    ReplyDelete
    Replies
    1. Thanks for the comment and note . This note was not available when i had encountered this issue. So i had to find a way my own. The note was created around 9 months after i faced this issue. I had an SR logged but not much helpful information from support guys. As I was curious to see R12.2 in action i took extra mile to find a temporary fix.

      Thanks for the note i could see that this issue is classified as a bug !!

      Delete