Sunday, July 10, 2011

Multi to Single Node Cloning (11 Steps)

Multi to Single Node Cloning (11 Steps)

Scenario is that we have database which resides on server [titus].Concurrent Managers and Admin Servers are residing on same machine [titus] while Web Server and Forms Servers are residing on different server which is [dbdem].


 

We are going to do cloning of this environment on target system which is [firmus].This scenario will be call Maulti to Single Node cloning.


 

Step -1:

You need to make sure that these patches exist on the Source:

patch 4038964
patch 4175764


 

Step -2:

Login to both application nodes and run Maintain Snapshot through adadmin utility.


 

Step -3:

Now you need to make of the node as primary node.In our case we made the [dbdem] as the primary application node.

On the primary node you need to go to this root

$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]

And in there run the script

$ perl adpreclone.pl appsTier merge

This script will ask which nodes you want to merge and in our case we are going to merge dbdem apps and titus apps.


 

Step -4:

Now you need to login to the each apps node and go into

$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]

And run the script on both apps nodes

$ perl adpreclone.pl appltop merge

This script will merge the appltop of both the nodes.


 

Step -5:

Now you need to run the normal cloning scripts on each DB and APPS nodes.

For database:

$ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]

$ perl adpreclone.pl dbTier


 

Step -6:

Now shutdown all the services on all nodes including DB and APPS.Lgon to database node and create folders where you are going to copy the db and apps.

Create users for apps and db and assign those folders to these users and give the folders the read and write permissions.


 

Step -7:

Modify the $vi /etc/oraInst.loc


 

Step -8:

Copy database and only the primary node(in our case dbdem) to target firmus folders.


 

Step -9:

Login to the secondary apps node(titus) and copy the folder

[COMMON_TOP]/clone/appl

To the server node folder


 

[COMMON_TOP]/clone/appl


 

Step -10:

Login to the firmus the target system and in there go

$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin

$ perl adcfgclone.pl dbTier

After this run the database and the listener and go to

$ cd [COMMON_TOP]/clone/bin

And run

$ perl adcfglone.pl appsTier


 

Step -11:

Remove the temporary directory [COMMON_TOP]/clone/appl to reduce disk space usage.


 


 

3 comments:

  1. Dear Oracle APPS DBA
    i had mention titus is u r primary NODE, and DBDEM is u r sec. NODE , but u did a mistake in 3 step pls cheack and correct the mistaks

    ReplyDelete
  2. It is correct. He has mentioned DBDEM as primary node.

    ReplyDelete