R12.2 Apps DBA. Powered by Blogger.

Adop Phase=prepare Fails While Checking Patch Service "Error: Patch service check failed" (Doc ID 1607700.1)

No comments :
SYMPTOMS
When attempting to run adop phase=prepare the following error occurs.
STATEMENT] Error: Patch service check failed
  [STATEMENT] Hint: Try to create the patch service
  [STATEMENT] [START 2013/12/11 15:47:06] Performing steps to fix Sanity Errors
  [STATEMENT] [START 2013/12/11 15:47:07] Creating Patch Service
CHANGES
 Upgrade to 12.2.2
CAUSE
$AU_TOP/perl/ADOP/PreparePhase.pm has a sql statement "select count(service_id) from dba_services where name='ebs_patch' " to check the patch service
Running this sql from the PreparePhase.pm file on sqlplus returns 0 for lower case but returns 1 for uppercase.
Since query from PreparePhase.pm is expecting service in lower case it returns 0 and therefore thinks there is not patch service.
SQL> select count(service_id) from dba_services where name='ebs_patch';
COUNT(SERVICE_ID)
-----------------
  0
SOLUTION
NOTE: These checks are  highly recommended while working on this issue:
a. _system_trig_enabled database parameter is set to FALSE (should be true).
b. ADMINISTER DATABASE TRIGGER grants given to APPS user (should be revoked if granted).
c. Check for existence of EBS_LOGON trigger and if it is valid.
Please perform the below steps to solve this issue:
1. Delete the service_name running:
exec DBMS_SERVICE.DELETE_SERVICE(service_name =>'EBS_PATCH');
2. Then reset the service_name parameter
alter system set service_names = '<SID>','ebs_patch' ;
Now run again:
 select count(service_id) from dba_services where name='ebs_patch';
This time it should return 1.
Another way to confirm the service name has been corrected and now it's in lower case is through show parameter command:
SQL> show parameter service;
      NAME                                       TYPE        VALUE
     ------------------------------------ ----------- ------------------------------
      service_names                           string      UPG, ebs_patch
3. run adop phase=prepare

No comments :

Post a Comment

Note: only a member of this blog may post a comment.