12.2 Patch Edition Auto config error.
Oracle 12.2.4 EBS
File system: PATCH
Enable the login trigger
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;
------------------------------------------------------------------------
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
/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
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
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>
. 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;
------------------------------------------------------------------------