Cloning Oracle EBS R12.2 with DualFS and AutoConfig Error Solution

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.

[applmgr@ebstest2 bin]$
[applmgr@ebstest2 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

[applmgr@ebstest2 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.

[applmgr@ebstest2 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.

[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$ . /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 ...

[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@ebstest2 scripts]$
[applmgr@ebstest2 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.
[applmgr@ebstest2 scripts]$

 

 

 

 

To solve this problem, Backup fnd_oam_context_files, fnd_nodes and adop_valid_nodes tables and Truncate these tables like following.

 

 

[oracle@ebstest2 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.

[oracle@ebstest2 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.
[oracle@ebstest2 CLONE_ebstest2]$


 

If AutoConfig is completed properly at EBS Database side, then Run AutoConfig on Application Side.

[applmgr@ebstest2 ~]$ . .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 ...

[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@ebstest2 scripts]$
[applmgr@ebstest2 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.
[applmgr@ebstest2 scripts]$


AutoConfig is completed properly in the Run edition, try to run AutoConfig on Patch edition.

 

[applmgr@ebstest2 ~]$ . /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 ...

[applmgr@ebstest2 ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@ebstest2 scripts]$
[applmgr@ebstest2 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.
[applmgr@ebstest2 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

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

5 comments

  1. Awesome troubleshooting! It helped wrap up my cloning process for 12.2.8. Thankyou very much!!

  2. C72E517EBF764666E0538200A8C0DDB959568141538285989573308529259369 —– fnd nodes

    C71414FC6299409AE0538200A8C0B28236854163053556778985396221928610 —APPL_SERVER_ID in PROD.dbc

    Unique constraint error (00001) is OK if key already exists

    Creating the DBC file…
    Application server ID already exists for this host – loading..
    ADD executed successfully – /u01/app/oracle/R122/fs1/inst/apps/PROD_prodr122/appl/fnd/12.0.0/secure/PROD.dbc

    Updating Server Security Authentication
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPLSYS.FND~NODES~U1) violated
    ORA-06512: at “APPS.FND_CONCURRENT”, line 1688
    ORA-06512: at “APPS.FND_APP_SERVER_PKG”, line 386
    ORA-06512: at “APPS.FND_APP_SERVER_PKG”, line 664
    ORA-01403: no data found
    ORA-06512: at line 1
    – Database error performing AUTHENTICATION

    Updating Server Security Authentication failed with exit code 1
    Restoring DBC file from backed up location /u01/app/oracle/R122/fs1/inst/apps/PROD_prodr122/appltmp/TXK/PROD_Fri_Jul_16_12_38_2021.dbc

    adgendbc.sh ended at Fri Jul 16 12:38:33 BST 2021

    adgendbc.sh exiting with status 1
    ERRORCODE = 1 ERRORCODE_END

  3. i dropped index on APPLSYS.FND~NODES and recreated , created new appsutil on apptier and copied to dbtier and re-rerun adautocfg.sh but this problem still there

    even though i started all services

    and node id does not exist for current application server ……. this messge pop up , forms are opening

    can you diagnose problem and resolve it

Leave a Reply

Your email address will not be published. Required fields are marked *