R12.2 Apps DBA. Powered by Blogger.

R12.2 Adop Phase=prepare Failed Error Patch service check failed

No comments :
$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
Sol:
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.
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.
SQL> show parameter service;
      NAME                                       TYPE        VALUE
     ------------------------------------ ----------- ------------------------------
      service_names                           string      UPG, ebs_patch
3. run adop phase=prepare
SQL> select count(service_id) from dba_services where name='ebs_patch';
COUNT(SERVICE_ID)
-----------------
                1

No comments :

Post a Comment

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