Cloning Oracle Applications Release 12.1.3 & 12.2.4 with Rapid Clone

Section 1: Prerequisites

1.      Run AutoConfig on the Application Tiers

Run AutoConfig on all application tier nodes. Use the adautocfg.sh command. All scripts listed below are located in <INST_TOP>/admin/scripts.

Platform	Functionality	Command
UNIX	Start Applications services	adstrtal.sh
	Stop Applications services	adstpall.sh
	Run AutoConfig	adautocfg.sh

Attention: The database server and the database listener must remain available during the AutoConfig run. Only the application tier servers should be shut down.

Note: Running AutoConfig may change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities, in order to apply the changed environment variables.

2.      Synchronize appsutil on the Database Tier Nodes

Update the RDBMS ORACLE_HOME file system with the AutoConfig files by performing the following steps:

·    On the application tier (as the APPLMGR user):

o   Log in to the APPL_TOP environment (source the environment file)

o   Create appsutil.zip file

perl <AD_TOP>/bin/admkappsutil.pl

o   This will create appsutil.zip in <INST_TOP>/admin/out

e.g     cd /d01/oracle/PROD/inst/admin/scripts/

             ./autoconfig.sh

       . /d01/oracle/PROD/apps/apps_st/appl/AppsProd.env

         cd $AD_TOP/bin/

         perl admkappsutil.pl

·    On the database tier (as the ORACLE user):

o   Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>

o   cd <RDBMS ORACLE_HOME>

e.g cd /d01/oracle/PROD/db/tech_st/11.1.0/

o   unzip -o appsutil.zip

3.      Run AutoConfig on the Database Tier

Run AutoConfig on the database tier nodes. Use the adautocfg.sh/.cmd command. All the scripts listed below are located in

<RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>.

Platform	Functionality	Command
UNIX	Start database listener process	addlnctl.sh start <SID>
	Start database process	addbctl.sh start
	Stop database listener process	addlnctl.sh stop <SID>
	Stop database process	addbctl.sh stop
	Run AutoConfig	adautocfg.sh

Attention: The database server and the database listener must remain available during the AutoConfig run. All the other database tier services should be shut down.

Note: Running AutoConfig may change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities, in order to apply the changed environment variables.

4.      Maintain Snapshot information

Log in to each Applications Node as the APPLMGR user, and run "Maintain Snapshot information" in AD Administration (adadmin).

Run adadmin à Select option 2 à Select option 5 à Select option 2 à Select option 1

Section 2: Clone Oracle Applications Release 12

There are three phases to the cloning process:

1.      Prepare the Source System
Execute the following commands to prepare the source system for cloning.

a. Prepare the source system database node for cloning
Log on to the source system as the ORACLE user. and run the following commands:
   cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>
   perl adpreclone.pl dbTier

b. Prepare the source system application tier for cloning
Log on to the source system as the APPLMGR user, and run the following commands on each node that contains an APPL_TOP:
   cd <INST_TOP>/admin/scripts
   perl adpreclone.pl appsTier

Configure the target system database server

Log on to the target system as the ORACLE user and enter the following commands to configure and start the database:

1.      cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
2.     cd /d01/oracle/test/db/tech_st/11.1.0/appsutil/clone/bin
3.     perl adcfgclone.pl dbTier

Configure the target system application tier server nodes
Log on to the target system as the APPLMGR user and type the following commands:
                a.     . /opt/oracle/TEST/EBSapps.env run

2.      cd $ADMIN_SCRIPTS_HOME OR <COMMON_TOP>/clone/bin
3.  R12.1.3   cd /d01/oracle/test/apps/apps_st/comn/clone/bin
4.  R12.2.X  cd /opt/oracle/TEST/fs1/EBSapps/comn/clone/bin
5.     perl adcfgclone.pl appsTier 

Db Questions:

Target Instance is RAC (y/n) [n]

ANSWER :enter

Target System Database SID

ANSWER :CLONE

Target System Base Directory

ANSWER :/d01/oracle/PROD

Target System utl_file_dir Directory List

ANSWER :/usr/tmp    or

 /d01/oracle/PROD/db/tech_st/11.1.0/appsutil/

Number of DATA_TOP's on the Target System [1]

ANSWER :enter

Target System DATA_TOP Directory 1 [/d01/oracle/PROD/db/apps_st/data]

ANSWER :  /d01/oracle/PROD/db/apps_st/data

Creating /d01/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.

Target System RDBMS ORACLE_HOME Directory [/d01/oracle/PROD/db/tech_st/11.1.0]

ANSWER :enter

/d01/oracle/PROD/db/tech_st/11.1.0

Creating /d01/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.

Do you want to preserve the Display [null] (y/n) ?

ANSWER : y or n

Target System Display [prodebsc:0.0]

ANSWER :enter

Do you want the the target system to have the same port values as the source system (y/n) [y] ?

ANSWER : n

port :10  

 For Example if you want to use 1531 then press 10 it will add 10 in default port 1521

Apps Questions :

select single nod or dual  [single] : enter

select  Edition file system [run] : enter

Target System Hostname (virtual or normal) [prodebsc]

ANSWER :enter

Target System Database SID

ANSWER :CLONE

Target System Database Server Node [prodebsc]

ANSWER :enter

Target System Base Directory

ANSWER :/d01/oracle/PROD

Target System Tools ORACLE_HOME Directory [/d01/oracle/PROD/apps/tech_st/10.1.2]

ANSWER :enter

Target System Web ORACLE_HOME Directory [/d01/oracle/PROD/apps/tech_st/10.1.3]

ANSWER :enter

Target System APPL_TOP Directory [/d01/oracle/PROD/apps/apps_st/appl]

ANSWER :enter

Target System COMMON_TOP Directory [/d01/oracle/PROD/apps/apps_st/comn]

ANSWER :enter

Target System Instance Home Directory [/d01/oracle/PROD/inst]

ANSWER :enter

Target System Root Service [enabled]

ANSWER :enter

Target System Web Entry Point Services [enabled]

ANSWER :enter

Target System Web Application Services [enabled]

ANSWER :enter

Target System Batch Processing Services [enabled]

ANSWER :enter

Target System Other Services [disabled]

ANSWER :enter

Do you want to preserve the Display [prodebs:0.0] (y/n) ?

ANSWER :n or y

Target System Display [prodebsc:0.0]

ANSWER :enter

prodebsc:0.0

Determining ConfigHome ..

instantiate file:

   source : /tmp/temp.xml

   dest   : /tmp/tmpPreCtxClone.xml

instantiate file:

   source : /tmp/tmpPreCtxClone.xml

   dest   : /tmp/tmpPreCtxClone.xml

instantiate file:

   source : /tmp/tmpPreCtxClone.xml

   dest   : /tmp/tmpPreCtxClone.xml

instantiate file:

   source : /tmp/tmpPreCtxClone.xml

   dest   : /tmp/tmpPreCtxClone.xml

instantiate file:

   source : /tmp/tmpPreCtxClone.xml

   dest   : /tmp/tmpPreCtxClone.xml

Evaluated ConfigHome: /d01/oracle/PROD/inst/apps/CLONE_prodebsc

Validating Config Home: /d01/oracle/PROD/inst/apps/CLONE_prodebsc

Set s_config_home to: /d01/oracle/PROD/inst/apps/CLONE_prodebsc

Do you want the the target system to have the same port values as the source system (y/n) [y] ?

ANSWER :n

port :10

 For Example if you want to use 8010 then press 10 it will add 10 in default port 8000

last question select answer  we write path in db question answer util file directory 

 e.g /usr/tmp

e.g /d01/oracle/clone/db/tech_st/11.1.0/appsutil/ 

answer: select option  

Only used to r12.24

how to make patch editition?

Then  fs1 copy to fs2 only EBSapps

Configure the target system application tier server nodes
Log on to the target system as the APPLMGR user and type the following commands:

2.      cd <COMMON_TOP>/clone/bin
3.     cd /d01/oracle/test/apps/apps_st/comn/clone/bin
4.     perl adcfgclone.pl appsTier

select single nod or dual  [single] : enter

select  Edition file system [run] : patch

Target System Hostname (virtual or normal) [prodebsc]

ANSWER :enter

Target System Database SID

ANSWER :CLONE

Target System Database Server Node [prodebsc]

ANSWER :enter

Target System Base Directory

ANSWER :/d01/oracle/PROD

then we write
full run file system name

/opt/oracle/TEST/fs1/inst/apps/TEST_testapps/appl/admin/TEST_testapps.xml

Target System Tools ORACLE_HOME Directory [/d01/oracle/PROD/apps/tech_st/10.1.2]

ANSWER :enter

Target System Web ORACLE_HOME Directory [/d01/oracle/PROD/apps/tech_st/10.1.3]

ANSWER :enter

Target System APPL_TOP Directory [/d01/oracle/PROD/apps/apps_st/appl]

ANSWER :enter

Target System COMMON_TOP Directory [/d01/oracle/PROD/apps/apps_st/comn]

ANSWER :enter

Target System Instance Home Directory [/d01/oracle/PROD/inst]

ANSWER :enter

Target System Root Service [enabled]

ANSWER :enter

Target System Web Entry Point Services [enabled]

ANSWER :enter

Target System Web Application Services [enabled]

ANSWER :enter

Target System Batch Processing Services [enabled]

ANSWER :enter

Target System Other Services [disabled]

ANSWER :enter

Do you want to preserve the Display [prodebs:0.0] (y/n) ?

ANSWER :n or y

Target System Display [prodebsc:0.0]

ANSWER :enter

prodebsc:0.0

Determining ConfigHome ..

instantiate file:

   source : /tmp/temp.xml

   dest   : /tmp/tmpPreCtxClone.xml

instantiate file:

   source : /tmp/tmpPreCtxClone.xml

   dest   : /tmp/tmpPreCtxClone.xml

instantiate file:

   source : /tmp/tmpPreCtxClone.xml

   dest   : /tmp/tmpPreCtxClone.xml

instantiate file:

   source : /tmp/tmpPreCtxClone.xml

   dest   : /tmp/tmpPreCtxClone.xml

instantiate file:

   source : /tmp/tmpPreCtxClone.xml

   dest   : /tmp/tmpPreCtxClone.xml

Evaluated ConfigHome: /d01/oracle/PROD/inst/apps/CLONE_prodebsc

Validating Config Home: /d01/oracle/PROD/inst/apps/CLONE_prodebsc

Set s_config_home to: /d01/oracle/PROD/inst/apps/CLONE_prodebsc

Do you want the the target system to have the same port values as the source system (y/n) [y] ?

ANSWER :n

port :1

 For Example if you want to use 8010 then press 10 it will add 10 in default port 8000

last question select answer  we write path in db question answer util file directory 

 e.g /usr/tmp

e.g /d01/oracle/clone/db/tech_st/11.1.0/appsutil/ 

answer: select option