11i Cloning (Multi Node to Single Node)

Merging from Multinode to Single node environments

Author - Jaspreet Singh Anand
Version 1.0
Created - 01-08-2007

Source: PRODUCTION -- Multinode Environment (RAC Environment)
10.14.6.23 ---- FORM/WEB TIER (Primary node)
10.14.6.13 ---- CONCURRENT+DB+ADMIN TIER(Primary Concurrent Node)
10.14.6.16 ---- CONCURRENT+DB+ADMIN TIER(Secondary Concurrent Node)

Important Note: Always start the merging from WEB node and then go to remaining Admin/Concurrent Nodes

Target: TEST -- Single node (Non RAC Environment)
10.5.72.127 ---- FORM/WEB/CONCURRENT/DB/ADMIN TIER


NODE A : 10.14.6.23 (FORM/WEB TIER) PRIMARY NODE Source
NODE B : 10.14.6.13 (CONCURRENT+DB+ADMIN TIER) Source
NODE C : 10.14.6.16 (CONCURRENT+DB+ADMIN TIER) Source
NODE E : 10.5.72.127 FORM/WEB/CONCURRENT+DB+ADMIN TIER Target


SOURCE SYSTEM

First refer note 230672.1 apply all the prereq patches and then refer Note: 233428.1 Section 4 for further steps.

1.Login as ora user (10.14.6.13) NODE B
Prepare the source system database tier for cloning
$cd /appsutil/scripts/
$perl adpreclone.pl dbTier

2.Login as ora user (10.14.6.16) NODE C
Prepare the source system database tier for cloning
$cd /appsutil/scripts/
$perl adpreclone.pl dbTier


3.Login as appl user (10.14.6.23) NODE A
cd $COMMON_TOP/admin/scripts/context_name1
$perl adpreclone.pl appsTier merge

It will create clone directort in common_top/clone/contextname1

4.Login as appl user (10.14.6.13) NODE B
$cd $COMMON_TOP/admin/scripts/context_name2
$perl adpreclone.pl appltop merge

It will create APPL_TOPs direcory in common_top/clone/appl/contextname2


5.Login as appl user (10.14.6.16) NODE C
$cd $COMMON_TOP/admin/scripts/context_name3
$perl adpreclone.pl appltop merge

It will create APPL_TOPs direcory in common_top/clone/appl/contextname3

6.Copy following from Node A(Primary Forms Tier) to Node E(Target Node) by tarring


<806 ORACLE_HOME>


7.On NODE A
$nohup tar -cvf finprdappl.tar finprdappl &
$nohup tar cvf finprdcomn.tar finprdcomn &
$nohup tar -cvf finprdora.tar finprdora &

8.Copy the Tar files to Target location(As an appl user)
$cd /oraprod/oracle
$scp -rC finprdappl.tar appl@10.5.72.127:/oraprod/oracle
$scp -rC finprdcomn.tar appl@10.5.72.127:/oraprod/oracle
$scp -rC finprdora.tar appl@10.5.72.127:/oraprod/oracle

9.And then untar it by using following command
$tar -xvf finprdappl.tar
$tar -xvf finprdcomn.tar
$tar -xvf finprdora.tar

10.Copy the required files from NODE B & C(SOURCE) to NODE E(TARGET)
$COMMON_TOP/clone/appl/contextname2 (NODE B) to $COMMON_TOP/clone/appl(NODE E)
$COMMON_TOP/clone/appl/contextname3 (NODE C) to $COMMON_TOP/clone/appl(NODE E)

Login as appl user 10.14.6.13 (NODE B)
$cd /oraprod/oracle/finprdappl/clone/appl
$scp -R appl applscm@10.5.72.127:/oraprod/oracle/finprdcomn/clone

Login as appl user 10.14.6.16 (NODE C)
$cd /oraprod/oracle/finprdappl/clone/appl
$scp -R appl applscm@10.5.72.127:/oraprod/oracle/finprdcomn/clone


11.From NODE B(Source) and NODE C(Source) to NODE E(TARGET)
Copy the database tier file system
Copy the database (DBF) files from the source to the target system
Copy the source database ORACLE_HOME(9.2.0) to the target system



TARGET SYSTEM

1.On Node E (Login as ora user and run the following :- )

Use the following method if database was backup-ed using COLD BACKUP methology
$cd /appsutil/clone/bin
$perl adcfgclone.pl dbTier


Use this method if database was backup-ed using HOT BACKUP methology
$cd /appsutil/clone/bin
$perl adcfgclone.pl dbTechStack

Create the target database control files manually
Start the target system database in open mode

Run the library update script against the database
$cd /appsutil/install/
$sqlplus "/ as sysdba" @adupdlib.sql
where is "sl" for HP-UX, "so" for any other UNIX/LINUX platform
Configure the target database (the database must be open)

$cd /appsutil/clone/bin
$perl adcfgclone.pl dbconfig

Database and DB Listener should be up and running

2.Login as appl user 10.5.72.127 (NODE E)
$cd $COMMON_TOP/clone/bin
$perl adcfgclone.pl appsTier

3.Finishing Task
* Run the following tasks in adadmin for all products:
* generate JAR files
* generate message files
* relink executables
* copy files to destination
* Depending on which tier you chose as the primary node, certain files may be missing. Run adadmin to
verify files required at runtime. If any files are listed as missing files, you
must manually copy them to the merged APPL_TOP.
* Remove the temporary directory /clone/appl(NODE E) to reduce disk space usage.