Sunday, January 4, 2009

CLONING OF ORACLE APPS – RAPID CLONING (FRESH CLONING)---COLD

CLONING OF ORACLE APPS – RAPID CLONING
(FRESH CLONING)---COLD


PREREQUISITES:

 Database must be Up.
 Stop the DB listener.
 Stop all the Services.

Stage 1 (SOURCE-SIDE)

In this Stage we need to Copy the Database files, Techstacks and APPL_TOP and COMMON_TOP. In this we copy the below five tops from Source to Target.
 DATA_TOP
 DB_TOP
 APPL_TOP
 COMMON_TOP
 ORA_TOP
Source Server: 192.168.0.202
Target Server: 192.168.0.204

But before copying the above TOP’s from source to target we need to perfom some Pre-Clone Steps.
Stage 2 ( PRECLONE STEPS)

DATABASE SIDE :
 Log on as oracle user We need to gather the entire information. For this we need to run adpreclone.pl.
[oracle@linux2 ~] cd /appsutil/scripts/
[oracle@linux2 ~] perl adpreclone.pl dbTier
When we run the above script, it will prompts us for the password of apps user.
It will create a Clone Directory under
/appsutil/
This is Key file for cloning.
APPLICATION SIDE :
 Log on as applmgr user. Here also we need to gather entire information about the File System. For this also we need to run adpreclone.pl
[applmgr@linux2 ~] cd $COMMON_TOP/admin/scripts/
[applmgr@linux2 ~] perl adpreclone.pl appsTier
When we run the above script, it will prompts us for the password of apps user.
It will create a Clone Directory under
$COMMON_TOP/admin/
Also it creates the appsutil Directory under 8.0.6 Home and IAS_ORACLE_HOME.
These are the Key files for cloning.

Now copy the files Source to Target.

COPY THE FIVE TOPS FROM SOURCE TO TARGET AS BELOW :

While copying the 5 TOP’s make sure that all the services are stopped including
the Database.
 Copy the DATA_TOP from source to target.
[app@linux2 ~] scp –r proddata app@192.168.0.204:/oraAPP/app/.
 Copy the DB_TOP from source to target.
[app@linux2 ~] scp –r proddb app@192.168.0.204:/oraAPP/app/.
 Copy the APPL_TOP from source to target.
[app@;inux2 ~] scp –r prodappl app@192.168.0.204:/oraAPP/app/.
 Copy the COMMON_TOP from source to target.
[app@linux2 ~] scp –r prodcomn app@192.168.0.204:/oraAPP/app/.
 Copy the ORA_TOP from source to target.
[app@linux2 ~] scp –r prodora app@192.168.0.204:/oraAPP/app/.


Stage 3 (TARGET SIDE)

In this stage we clone the Database.

Stage 3 (TARGET SIDE)

DATABASE TIER:
 Log on as oracle user and go to the Clone Directory under
/appsutil /clone/bin.
[oracle@linux2 ~] cd /appsutil/clone/bin
[oracle@linus2 ~] perl adcfgclone.pl dbTier
Now it will ask for the below inputs.
ORACLE_SID, APPS PASSWORD, HOSTNAME, PORTS, LOCATIONS OF RDBMS
HOME, LOCATION AND NUMBER OF DATATOPS, LOCATION OF UTL_FILEetc.
This will build XML file and runs Autoconfig and starts the Database;



APPLICATION TIER :
 Log on as applmgr user and go to Clone Directory under
/admin/clone/bin.
[applmgr@linux2 ~] cd $COMMON_TOP/admin/clone/bin
[applmgr@linux2 ~] perl adcfgclone.pl appsTier
Now it will asks for the below inputs.
APPS PASSWORD, ORACLE_SID, HOSTNAME, PORTS, SERVER NODE, DOMAIN
NAME,IS APPLICATION TIER SERVER NODE ONE OR NOT, IS APPL TOP
DIVIDED INTO MULTIPLE MOUNT POINTS OR NOT,LOCATIONS OF
APPL_TOP, COMMON_TOP,8.0.6,IAS,UTL_FILE DIRECTORY.

This will build XML file and runs Autoconfig and starts all the Application Services.

Stage 3 (POST STEPS)

 Retire the Unnecessary Application Users.
 Update Non-Site level profiles.(if necessary)
 Update Printer settings. (if necessary)
 Update Workflow components. (if necessary)
 Clear Cache in COMMON_TOP/_pages.
 Start Services.


NOTE : In Real Time we need to perform some steps after before running the Autoconfig on Application Tier. The steps are as bellows.
 We need to run the below script as apps user. we need to download this script from metalink.
[app@linux2 ~] sqlplus
SQL > conn apps/apps
SQL > @?/RAPIDMAGIC/admin /cmclean.sql.
 Purge fnd_nodes.
SQL > exec fnd_conc_clone.setup_clone();

No comments:

Post a Comment