Tuesday, August 27, 2013

Oracle APPS R12.1.3 Rapid Clone Application and Database

Pre clone Activity

Database Tier
$ su – <dbuser>
$ cd <db script home> (ex:/u01/orcln/crp/db/tech_st/11.1.0/appsutil/scripts/)
$ sh adautocfg.sh
Pwd: apps

$ perl adpreclonr.pl dbTier
Prompt Pwd: apps

$ exit

Application Tier

$ su– <application user>testcrp
$ cd <application script home> (ex: /u01/orcln/crp/apps/inst/apps/TEST10_vis/admin/scripts)
$ sh adautocfg.sh
Pwd: apps

$ perl adpreclone.pl appsTier
$ exit

Stop Instance
and ensure all process are stop

Login as root
copy all folder(apps,db,inst) to destination
$ cp –R <source>(/u01/orcln/crp/*) <destination>( /b01/UAT/)

After completion of copy change permission and ownership:-
$ chown – R orauat:dba db
$ chown – R appluat:dba apps
$ chown – R appluat:dba inst

$ chmod –R 777 db

$chmod –R 777 apps
$chmod –R 777 inst
Post Clone Activity database
$ su – <new db user> orauat
$ cd <clone/bin> (ex:/b01/UAT/db/tech_st/11.1.0/appsutil/clone/bin)
$ perl adcfgclone.pl dbTier
Prompt Pwd: apps

Target system host name : <host name> (test)
RAC(Y/N): N
Target system Database SID: <SID> (UAT)
Target system: /b01/UAT/db/tech_st/11.1.0
Target system utl_file_dir Directody list : /usr/tmp
DATA_TOP: 1
DATA_TOP_Directory: /b01/UAT/db/apps_st/data
ORACLE_HOME Directory: /b01/UAT/db/tech_st/11.1.0
Do you want to preserve display : y
Target system port pool : 6
$ exit

Checking for database connection (database up or not)

Post Clone Activity Application
$ su – <new application user>(appluat)
$ cd /b01/UAT/apps/apps_st/comn/clone/bin
$ perl adcfgclone.pl appsTier
Prompt Pwd: apps
Host name : test
SID : <sid> (UAT)
Database server node : vis
System database domain name : kross.com
System base directory : - /b01/UAT/apps/apps_st/appl
System tool oracle_home: - /b01/UAT/apps/tech_st/10.1.2
System web oracle_home :- /b01/UAT/apps/tech_st/10.1.3
System appl_top:- /b01/UAT/apps/apps_st/appl
System common_top:- /b01/UAT/apps/apps_st/comn
System instance home:- /b01/UAT/apps/inst
<accept other default value by pressing enter>

Preserve display: y
Port pool : 6
Appltmp : - 1( /usr/tmp)
Do you want to startup application services: y

Stop and start new instance

Run Autoconfig on Database
Run Autoconfig on Application

Stop and start New instance

No comments:

Post a Comment