Hi,
I will explain how to clone Oracle EBS with DualFS and how to solve Autoconfig error during DualFS in this article.
Cloning Oracle EBS R12.2 with DualFS
You should read following article if you don’t know What is the Cloning Oracle EBS and how to clone Oracle EBS.
Oracle EBS R12.2 ( E-Business Suite ) Step by Step Cloning – Oracle EBS Clone
You can use DualFS during Oracle EBS Cloning to make easy it. Normally When you Clone Oracle EBS, once Run edition is completed after Post clone, you need to create Patch edition manually. If you use DualFS, there is no need to create patch edition manually because DualFS does this task.
DualFS EBS Clone Option
You can run Post Clone step in Oracle EBS with dualFS option like following.
[[email protected] bin]$ [[email protected] bin]$ perl adcfgclone.pl appsTier dualfs Copyright (c) 2002, 2015 Oracle Corporation Redwood Shores, California, USA Oracle E-Business Suite Rapid Clone Version 12.2 adcfgclone Version 120.63.12020000.56 Enter the APPS password : Enter the Weblogic AdminServer password : Do you want to add a node (yes/no) [no] : Running: Context clone... Log file located at /u01/ebs/fs1/EBSapps/comn/clone/bin/CloneContext_1218064848.log Provide the values required for creation of the new APPL_TOP Context file. Target System Hostname (virtual or normal) [ebstest2] : Target System Database SID : CLONE Target System Database Server Node [ebstest2] : Target System Database Domain Name [localdomain.local] : Target System Base Directory : /u01/ebs Target System Base Directory set to /u01/ebs Target System Current File System Base set to /u01/ebs/fs1 Target System Other File System Base set to /u01/ebs/fs2 Target System Fusion Middleware Home set to /u01/ebs/fs1/FMW_Home Target System Other File System Fusion Middleware Home set to /u01/ebs/fs2/FMW_Home Target System Web Oracle Home set to /u01/ebs/fs1/FMW_Home/webtier Target System Other File System Web Oracle Home set to /u01/ebs/fs2/FMW_Home/webtier Target System Appl TOP set to /u01/ebs/fs1/EBSapps/appl Target System Other File System Appl TOP set to /u01/ebs/fs2/EBSapps/appl Target System COMMON TOP set to /u01/ebs/fs1/EBSapps/comn Target System Other File System COMMON TOP set to /u01/ebs/fs2/EBSapps/comn Target System Instance Home Directory [/u01/ebs] : Target System Current File System Instance Top set to /u01/ebs/fs1/inst/apps/CLONE_ebstest2 Do you want to preserve the Display [ebstest:0.0] (y/n) : n Target System Display [ebstest2:0.0] : Target System Root Service [enabled] : Target System Web Entry Point Services [enabled] : Target System Web Application Services [enabled] : Target System Batch Processing Services [enabled] : Target System Other Services [disabled] : Do you want the target system to have the same port values as the source system (y/n) [y] ? : n Target System Port Pool [0-99] : 2 Checking the port pool 2 done: Port Pool 2 is free Report file located at /u01/ebs/fs1/inst/apps/CLONE_ebstest2/admin/out/portpool.lst UTL_FILE_DIR on database tier consists of the following directories. 1. /usr/tmp 2. /usr/tmp Choose a value which will be set as APPLPTMP value on the target node [1] : 1 The new APPL_TOP context file has been created : /u01/ebs/fs1/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml Check Clone Context logfile /u01/ebs/fs1/EBSapps/comn/clone/bin/CloneContext_1218064848.log for details. Creating Patch file system context file..... Log file located at /u01/ebs/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1218064922.log Target System Other File System Instance Top set to /u01/ebs/fs2/inst/apps/CLONE_ebstest2 Target System Port Pool [0-99] : 3 Checking the port pool 3 done: Port Pool 3 is free Report file located at /u01/ebs/fs2/inst/apps/CLONE_ebstest2/admin/out/portpool.lst The new APPL_TOP context file has been created : /u01/ebs/fs2/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml Check Clone Context logfile /u01/ebs/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1218064922.log for details. FMW Pre-requisite check log file location : /u01/ebs/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log Running: FMW pre-req check... Configuring: Run file system.... LogFile located at /u01/ebs/fs1/inst/apps/CLONE_ebstest2/admin/log/clone/run/RCloneApplyAppstier_12180649.log Configuring: Patch file system.... LogFile located at /u01/ebs/fs1/inst/apps/CLONE_ebstest2/admin/log/clone/patch/RCloneApplyAppstier_12180727.log AutoConfig has completed with errors for .patch Do you want to startup the Application Services for CLONE? (y/n) [n] : n Services not started [[email protected] bin]$
As you see in the above log, There is an error during Autoconfig in Post Clone step.
You can solve this problem like following steps.
Run Adop Prepare phase like following.
[[email protected] scripts]$ adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context : /u01/ebs/fs1/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml Patch edition context: /u01/ebs/fs2/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml Patch file system free space: 317.41 GB Validating system setup. Node registry is valid. [ERROR] ETCC not run in the database node ebstest2 The EBS Technology Codelevel Checker needs to be run on the database node. It is available as Patch 17537119. [WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh. Encountered the above errors when performing database validations. Resolve the above errors and restart adop. [STATEMENT] Please run adopscanlog utility, using the command "adopscanlog -latest=yes" to get the list of the log files along with snippet of the error message corresponding to each log file. adop exiting with status = 1 (Fail)
AutoConfig
When you run AutoConfig in the Patch edition, you will also get an error like following.
[[email protected] ~]$ [[email protected] ~]$ . /u01/ebs/EBSapps.env patch E-Business Suite Environment Information ---------------------------------------- RUN File System : /u01/ebs/fs1/EBSapps/appl PATCH File System : /u01/ebs/fs2/EBSapps/appl Non-Editioned File System : /u01/ebs/fs_ne DB Host: ebstest2.localdomain.local Service/SID: CLONE Sourcing the PATCH File System ... [[email protected] ~]$ [[email protected] ~]$ [[email protected] ~]$ [[email protected] ~]$ [[email protected] ~]$ cd $ADMIN_SCRIPTS_HOME [[email protected] scripts]$ [[email protected] scripts]$ sh adautocfg.sh Enter the APPS user password: The log file for this session is located at: /u01/ebs/fs2/inst/apps/CLONE_ebstest2/admin/log/12221337/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using CONFIG_HOME location : /u01/ebs/fs2/inst/apps/CLONE_ebstest2 Classpath : /u01/ebs/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/ebs/fs2/EBSapps/comn/java/classes Using Context file : /u01/ebs/fs2/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.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 with errors. [[email protected] scripts]$
To solve this problem, Backup fnd_oam_context_files, fnd_nodes and adop_valid_nodes tables and Truncate these tables like following.
[[email protected] etcc]$ sqlplus applsys/apps SQL*Plus: Release 12.1.0.2.0 Production on Sat Dec 22 13:45:36 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Last Successful login time: Sun Dec 02 2018 03:28:42 -05:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files; Table created. SQL> create table fnd_nodes_bk as select * from fnd_nodes; Table created. SQL> create table adop_valid_nodes_bk as select * from adop_valid_nodes; Table created. SQL> create table ad_nodes_config_status_bk as select * from ad_nodes_config_status; Table created. SQL> truncate table fnd_oam_context_files; Table truncated. SQL> truncate table fnd_nodes; Table truncated. SQL> truncate table adop_valid_nodes; Table truncated. SQL> truncate table ad_nodes_config_status; Table truncated.
Run AutoConfig at EBS Database side.
[[email protected] CLONE_ebstest2]$ ./adautocfg.sh Enter the APPS user password: The log file for this session is located at: /u01/database/12.1.0/appsutil/log/CLONE_ebstest2/12221347/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. Using ORACLE_HOME location : /u01/database/12.1.0 Classpath : :/u01/database/12.1.0/jdbc/lib/ojdbc6.jar:/u01/database/12.1.0/appsutil/java/xmlparserv2.jar:/u01/database/12.1.0/appsutil/java:/u01/database/12.1.0/jlib/netcfg.jar:/u01/database/12.1.0/jlib/ldapjclnt12.jar Using Context file : /u01/database/12.1.0/appsutil/CLONE_ebstest2.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Updating rdbms version in Context file to db121 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ... AutoConfig completed successfully. [[email protected] CLONE_ebstest2]$
If AutoConfig is completed properly at EBS Database side, then Run AutoConfig on Application Side.
[[email protected] ~]$ . .bash_profile E-Business Suite Environment Information ---------------------------------------- RUN File System : /u01/ebs/fs1/EBSapps/appl PATCH File System : /u01/ebs/fs2/EBSapps/appl Non-Editioned File System : /u01/ebs/fs_ne DB Host: ebstest2.localdomain.local Service/SID: CLONE Sourcing the RUN File System ... [[email protected] ~]$ [[email protected] ~]$ cd $ADMIN_SCRIPTS_HOME [[email protected] scripts]$ [[email protected] scripts]$ ./adautocfg.sh Enter the APPS user password: The log file for this session is located at: /u01/ebs/fs1/inst/apps/CLONE_ebstest2/admin/log/12221348/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using CONFIG_HOME location : /u01/ebs/fs1/inst/apps/CLONE_ebstest2 Classpath : /u01/ebs/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/ebs/fs1/EBSapps/comn/java/classes Using Context file : /u01/ebs/fs1/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.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. [[email protected] scripts]$
AutoConfig is completed properly in the Run edition, try to run AutoConfig on Patch edition.
[[email protected] ~]$ . /u01/ebs/EBSapps.env patch E-Business Suite Environment Information ---------------------------------------- RUN File System : /u01/ebs/fs1/EBSapps/appl PATCH File System : /u01/ebs/fs2/EBSapps/appl Non-Editioned File System : /u01/ebs/fs_ne DB Host: ebstest2.localdomain.local Service/SID: CLONE Sourcing the PATCH File System ... [[email protected] ~]$ cd $ADMIN_SCRIPTS_HOME [[email protected] scripts]$ [[email protected] scripts]$ ./adautocfg.sh Enter the APPS user password: The log file for this session is located at: /u01/ebs/fs2/inst/apps/CLONE_ebstest2/admin/log/12221354/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using CONFIG_HOME location : /u01/ebs/fs2/inst/apps/CLONE_ebstest2 Classpath : /u01/ebs/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/ebs/fs2/EBSapps/comn/java/classes Using Context file : /u01/ebs/fs2/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.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. [[email protected] scripts]$
When AutoConfig is completed successfully both Run Edition and Patch edition, then problem has been solved.
Do you want to learn Oracle E-Business Suite ( EBS ) for Junior Apps DBA, then read the following articles.
Oracle EBS ( E-Business Suite ) Tutorials for Junior Oracle Apps DBA
1,792 views last month, 2 views today
Awesome troubleshooting! It helped wrap up my cloning process for 12.2.8. Thankyou very much!!
you are welcome, keep in follow us.