Introduction: –
How to run autoconfig on patch file system in r12. | In order to run autoconfig on patch file system successfully. We have to disable trigger ebs_logon on run file system. Facing error ORA-20099: E-Business Suite Patch Edition does not exist.
How to Run autoconfig on patch file system in r12.
Suppose we have a requirement to run autoconfig in patch file system. But if we try to connect Database from patch file system, you will get below error.
$ sqlplus apps/*******
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jan 2 14:17:46 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20099: E-Business Suite Patch Edition does not exist.
ORA-06512: at line 29We are facing the above error because ebs_logon trigger doesn’t allow is it in enable state. So here we will check the status of trigger as below.
SQL> select TRIGGER_NAME from dba_triggers where TRIGGER_NAME='EBS_LOGON';
TRIGGER_NAME
--------------
EBS_LOGONTo run autoconfig on patch fs, need to be disable ebs_logon as below.
[applmgr@svrapps scripts]$ sqlplus system
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jun 28 12:17:06 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "SYSTEM"
SQL> alter trigger ebs_logon disable;
Trigger altered.Source the patch file sytem environment.
. /oracle/EBSFS/fs2/EBSapps/appl/APPSTEST_svrapps.env patch
[applmgr@svrapps scripts]$echo $FILE_EDITION
patch
[applmgr@svrapps scripts]$sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oracle/EBSFS/fs2/inst/apps/TEST_svrapps/admin/log/06281218/adconfig.log
wlsDomainName: EBS_domain
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment…
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /oracle/EBSFS/fs2/inst/apps/TEST_svrapps
Classpath : /oracle/EBSFS/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/oracle/EBSFS/fs2/EBSapps/comn/java/classes
Using Context file : /oracle/EBSFS/fs2/inst/apps/TEST_svrapps/appl/admin/TEST_svrapps.xml
Context Value Management will now update the Context file
Updating Context file…COMPLETED
Attempting upload of Context file and templates to database…COMPLETED
Configuring templates from all of the product tops…
Configuring AD_TOP……..COMPLETED
Configuring FND_TOP…….COMPLETED
Configuring ICX_TOP…….COMPLETED
Configuring MSC_TOP…….COMPLETED
Configuring IEO_TOP…….COMPLETED
Configuring BIS_TOP…….COMPLETED
Configuring CZ_TOP……..COMPLETED
Configuring SHT_TOP…….COMPLETED
Configuring AMS_TOP…….COMPLETED
Configuring CCT_TOP…….COMPLETED
Configuring WSH_TOP…….COMPLETED
Configuring CLN_TOP…….COMPLETED
Configuring OKE_TOP…….COMPLETED
Configuring OKL_TOP…….COMPLETED
Configuring OKS_TOP…….COMPLETED
Configuring CSF_TOP…….COMPLETED
Configuring IBY_TOP…….COMPLETED
Configuring JTF_TOP…….COMPLETED
Configuring MWA_TOP…….COMPLETED
Configuring CN_TOP……..COMPLETED
Configuring CSI_TOP…….COMPLETED
Configuring WIP_TOP…….COMPLETED
Configuring CSE_TOP…….COMPLETED
Configuring EAM_TOP…….COMPLETED
Configuring GMF_TOP…….COMPLETED
Configuring PON_TOP…….COMPLETED
Configuring FTE_TOP…….COMPLETED
Configuring ONT_TOP…….COMPLETED
Configuring AR_TOP……..COMPLETED
Configuring AHL_TOP…….COMPLETED
Configuring IES_TOP…….COMPLETED
Configuring OZF_TOP…….COMPLETED
Configuring CSD_TOP…….COMPLETED
Configuring IGC_TOP…….COMPLETED
AutoConfig completed successfully.
Make sure autoconfig completed successfully.
Now enable the login trigger on run filesystem.
SQL> alter trigger ebs_logon enable;
You may check another post related to autoconfig, click here.
For same topic you may check another article, click here.