Tuesday, January 31, 2017

12.2 Patch Edition Auto config error

12.2 Patch Edition Auto config error.

Oracle 12.2.4 EBS
File system: PATCH


jtfictx.sh              INSTE8_PRF         1
      okladmprf.sh            INSTE8_PRF         1
      txkJavaMailerCfg.sh     INSTE8_PRF         1
      txkWebServicescfg.sh    INSTE8_PRF         1

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /app/dev/appldev/SID/fs1/FMW_Home/webtier/perl/bin/perl -I
 /app/dev/appldev/SID/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I
/app/dev/appldev/SID/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I
/app/dev/appldev/SID/fs1/EBSapps/appl/au/12.0.0/perl -I
/app/dev/appldev/SID/fs1/FMW_Home/webtier/ohs/mod_perl
/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64
 /app/dev/appldev/SID/fs1/inst/apps/SID_CONTEXTNAME/admin/install
      txkGenADOPWrapper.pl    INSTE8_APPLY       1




AutoConfig is exiting with status 28

AutoConfig execution completed on Sat Jan 10 12:16:44 2017

Time taken for AutoConfig execution to complete : 2 mins  51 secs



Solution:
To run Autoconfig from the patch file system

 you must disable trigger ebs_login prior to running autoconfig
Disable the ebs_login trigger for patch file system

 "alter trigger ebs_logon disable" - Ensure you are logged in as the system user
Now run autoconfig with the patch env sourced
Make sure Autoconfig completes ok 

Enable the login trigger
 "alter trigger ebs_logon enable"
. EBSapps.env as Patch option
connect database using system or system/equivalent privileged user 


-------------STEPS--------------------------------------------------
sqlplus system/<password>  

SQL>alter trigger ebs_logon disable;
Trigger altered.

Then Run Auto config with in patch env

ensure that autconfig completed successfully
and

SQL> alter trigger ebs_logon enable;
------------------------------------------------------------------------

1 comment:

Anonymous said...
This comment has been removed by a blog administrator.