Step by step guide for Online Multi-node Cloning:

 Step by step guide for Online Multi-node Cloning:

Pre Cloning Tasks:

1) Prepare Target node:

Install Linux Operating System

Install required Rpms

2)On Target Machine:

Create group for DbTier

useradd -d /d01/ -g -m Username

Change the Permissions for User and change password

Chmod -R 755 /d01/

Chown -R Username:Group name /d01/

passwd Username

3)On Source Machine(DbTier):

Run adpreclone.pl

perl adpreclone.pl dbTier

File Location:$ORACLE_HOME/appsutil/scripts//

Cloning TASKS:

4)On Source Machine(AppsTier):

Run adpreclone.pl

perl adpreclone.pl appsTier

File Location:$INST_TOP//admin/scripts

5)Create Control file and SCP to target DbTier node and Edit trace file:

alter database backup control to trace;

Trace file Location:$ORACLE_HOME/admin//udump/

to get latest trace file type >ls -ltr

scp trace_file.trc root@target:/d01

Open trace_file.trc go to Startup nomount and press ESC-->:dgg it will delete all above rows then go below row ; and press ESC-->:dG then change SID ,NORESETLOGS to RESETLOGS,location of all datafiles.

6) On source(DbTier) take Hot backup and SCP dbtier to target(DbTier) and AppsTier on target(appsTier):

alter system archive log current;

alter database begin backup;

select count(*) from v$backup where status='ACTIVE';

scp -r db/ root@target:/d01// after copying done

alter system archive log current;

alter database end backup;

alter system switch logfile;(3 times)

scp -r archive/ root@target:$ORACLE_SID/dbs

Scp -r apps ins root@targerapps:/d01//

7) On Target DbTier:

Run adcfgclone.pl

File Location:$ORACLE_HOME/appsutil/clone/bin/

perl adcfgclone.pl dbTechStack(should complete with status 0)will create CONTEXT FILE and Environment file.

8) Create Control File:

Note: Run the environment file

login to database (sqlplus '/as sysdba')

>startup nomount;

>@trace_file.trc

>recover database using backup controlfile until cancel;

Add datafiles for TEMP tablespace as mentioned in trace

>altertablespaceTEMP1addtempfile'/d01//db/apps/apps_st/data/temp01.dbf'size 5012M reuse autoextend on;

>alter database default temporary tablespace TEMP1;

9) Update the Oracle binaries on Target DbTier:

Run aduplib.sql

File Location: $ORACLE_HOME/appsutil/install//

>@adupdlib.sql so

10) On Target DbTier:

Run adcfgclone.pl

File Location:$ORACLE_HOME/appsutil/clone/bin/

Note: Make sure that database and listener is up and running.

]$ perl adcfgclone.pl database $CONTEXT_FILE(will configure database)

should complete with status '0'.

11) On Target AppsTier :

Run adcfgclone.pl

File Location:$COMMON_TOP/clone/bin/

]$ perl adcfgclone.pl appsTier(should complete with status 0)

12) Create appsutil directory by using admkappsutil.pl

]$ perl admkappsutil.pl

scp appsutil.zip to target DbTier $ORACLE_HOME

unzip -o appsutil.zip (at DbTier and run autoconfig on both tiers first dbtier and the appstier)

Till here all major cloning tasks are done..

Post Cloning tasks:

If u want to know the URL of apps then:

Login to database connect as apps user:

>select home_url from icx_parameters;

13) Change the color of application so that it will differentiate production and clone Instance form

System administrator>System>Profile---->java color Scheme

--->change color

14) Check for instance name and display_name form application if different then update

>select name.display_name from apps.wf_systems;

>update apps.wf_systems set name='clone_name',dispaly_name='.domain name';

>Commit;

>update wf_agents set address=replace(address,'PROD','clone_name');

>commit;

15) Clear Fnd_Concurrent_nodes

exec FND_CONC_CLONE_SETUP_CLEAN (as apps user)

>commit;

Note if necessary run cmclean.sql script and don't forget to commit;

16) Generate Jar files from adadmin utility(1-4)

17) Relink applications programs(2-1)

18) Run autoconfig on both tiers first DbTier and second AppsTier