Multi Node to SingleNode Cloning Process

Two Node to Single Node
Two Node to Single Node is a interesting concept, if the db and application is separate
then Two Node to Single Node is very simple, you copy db first and application second.
In the below example where application tier is present in both the nodes then is becomes
challenging. Most of companies need it, there production environment is very complex
but they cannot give the same in the development for patches and testing purposes. I have
seen a environment where they have 4 node E-business system running on RAC but they
have single node for patching, testing etc.
This configuration is not supported by Oracle but his been tested in our environment,
unless tested properly don’t apply in production; this site is not responsible for any data
loss.
Figure says, what is the environment and what is required
Web
/Forms
Admin/
CPS
DB
Web
Forms
CPS
Admin
DB



Here are the steps.
1> DB,cps, admin on one node
2> Web and forms on second node
3> Run preclone on second node - WEB/FORMS
4> Update snapshot on both nodes, web first (optional)
5> copy visappl/viscomn/visora to the first node (db node) in new directory
6> Remove viscomn/visora in the first node (db node)
7> Merge appltop
scp -rp visappl/* /d01/oracle/visappl (no prompt)
8> cp viscomn/visora to /d01/oracle/
9> Run Postclone on the DB node (application tier)
10> Open application xml file and change all parameters "Yes"
YES
YES
YES
YES
YES
YES
YES
YES
YES
YES
YES
enabled
enabled
11> Run AutoConfig

------------------------------------------------------------------------------------------------
Source:- http://www.appsdba.info/docs/oracle_apps/cloning/MultiNodetoSingleNode.pdf
------------------------------------------------------------------------------------------------