Cloning R12.2 environment
See Oracle Support Doc: Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)
Additionally patching to R12.AD.C.Delta.7 and TXK provides some new functionality that eases the clone process – see dualfs at the end of this post.
Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 (Doc ID 2033780.1)
Prerequisites
Use the “adop -status” command to verify that no adop patching cycle is currently active.
Cloning the appl tier
Log on to applmgr and source RUN EDITION file system / the environment (make sure the Apps environment variables are set).
Make sure everything is up and running.
echo $FILE_EDITION
run
cd $INST_TOP/admin/scripts
cd /d01/oracle/VIS/fs1/inst/apps/VIS_oel66-79/admin/scripts
perl adpreclone appsTier dualfs
Note: checking codelevel – login as apps to sqlplus
column codelevel format a30
column name format a40SELECT abbreviation, codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in (‘txk’,’ad’);
Cloning the database tier
Log on to the Source System as the oracle user.
Source the Database tier environment file.
cd $ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>
perl adpreclone.pl dbTier
Running the perl script above creates $ORACLE_HOME/appsutil/clone directory on the source database home
Note: if you get R12.2.x: Error- sh: module: line 1: syntax error: Unexpected End Of File On Oracle Linux 6 64-bit
CAUSE
This issue is reported via internal Bug 14259166 – TECHPLAT: ‘ADADMINSRVCTL.SH START’ GET ERROR AFTER EBS 12.2 MULTI-NODE RI ON OL6.
This error is caused by incorrect environment function module() and a problem with exported shell functions. The issue has been identified on Oracle Linux 6 64-bit.
SOLUTION
To implement the solution, please execute the following steps:
1. Please rename the /etc/profile.d/modules.sh to /etc/profile.d/modules.sh.bkup h.
Connect as root:
# mv /etc/profile.d/modules.sh /etc/profile.d/modules.sh.bkup
2.) log out and back in – re-source your environment variables
3. Retest the issue
Cloning the appl tier
Log on to the primary node of the Source System as the applmgr user.
Source the environment file of the Run Edition File system.
You can use the following command to confirm that the environment variable FILE_EDITION points to the Run Edition File System (the echo’d value should by “run”.
echo $FILE_EDITION
run
The adpreclone.pl process on the appl tier creates a compressed archive of the Oracle Fusion Middleware and its components as follows.
A compressed archive of the Oracle WebLogic Server home, Oracle Web Tier Utilities home, Oracle Common Utilities home and the Oracle E-Business Suite home:
<COMMON_TOP>/clone/FMW/FMW_Home.jar
A compressed archive of the Oracle E-Business Suite WebLogic domain:
<COMMON_TOP>/clone/FMW/WLS/EBSdomain.jar
The Oracle E-Business Suite WebLogic domain’s configuration template:
<COMMON_TOP>/clone/FMW/WLS/plan/moveplan.xml
A compressed archive of the Oracle Web Tier/Oracle HTTP Server configuration instance:
<COMMON_TOP>/clone/FMW/OHS/ohsarchive.jar
The Oracle HTTP Server configuration instance’s configuration template:
<COMMON_TOP>/clone/FMW/OHS/moveplan.xml
The adpreclone log files are created in the $INST_TOP/admin/log/clone directory.
The jar files created in clone directory will be used to clone the FMW home, as a result we do not need to copy the FMW home during the clone process on the target.
Tar the database Oracle home (source) then copy tar to target tier.
tar -czvf name-of-archive.tar.gz /path/to/directory-or-filecd TBCompleted
tar -cvf TBCompleted
Check all the symbolic links in the oracle home on target side and correct them
On the target as oracle Run adcfgclone
$ cd $ORACLE_HOME/appsutil/clone/bin
$ perl adcfgclone.pl dbTechstack
Running adcfgclone.pl with the parameter dbtechstack will manage the database clone manually and will re-link the oracle home, & create all the configuration files.
RMAN backup the source database
Copy the RMAN back to the target, restore & recover.
Execute AutoConfig
$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=<CONTEXT_FILE> run=INSTE8_SETUP
Run the library update script against the database.
cd $ORACLE_HOME/appsutil/install/<CONTEXT NAME>
sqlplus “/ as sysdba” @adupdlib.sql sl
Where <libext> is sl for UNIX platforms, or dll for Windows.
Configure the Target database.
The database must be running and open before performing the next step.
cd $ORACLE_HOME/appsutil/clone/bin
perl adcfgclone.pl dbconfig <Database Target Context File>
Where “Database Target Context File” is: $ORACLE_HOME/appsutil/<Target CONTEXT_NAME>.xml.
The dbconfig option will configure the database with the required settings for the new Target, but it will not recreate the control files.
Copy the application tier file system from the Source “Run Edition File System” to the Target “Run Edition File System”
Only the following directories need to be copied.
Check the symbolic links under <OracleAS Tools 10.1.2 ORACLE_HOME> and <COMMON_TOP> directories when copying files.
<APPL_TOP>
<COMMON_TOP>
<OracleAS Tools 10.1.2 ORACLE_HOME>
Create new dirs on the target that match the source
mkdir -p /d01/oracle/VIS/fs1/
mkdir -p /d01/oracle/VIS/fs2/
mkdir -p /d01/oracle/VIS/fs_ne/
Clone the apps tiers at the target
cd $COMMON_TOP/clone/bin
perl adcfgclone.pl appsTier
At the prompt “Target System Base Directory”, enter the location of the base directory. In my case: /d01/oracle/VIS
Answer “n” when prompted: Do you want to startup the Application Services for mult35? (y/n)
Copy the Oracle E-Business Suite application directories from the Run Edition File System to the Patch Edition File System.
<APPL_TOP>
<COMMON_TOP>
<OracleAS Tools 10.1.2 ORACLE_HOME>
Log on to the Patch Edition File System in the Target System as the applmgr user
cd $COMMON_TOP/clone/bin
perl adcfgclone.pl appsTier
Note: DUALFS – new feature is introduced in the latest AD-TXK Delta 7.
Running adcfgclone.pl on the apps tier along with the parameter “dualfs” create both the filesystems fs1 and fs2 during the cloning process as follows.
perl adcfgclone.pl appsTier dualfs