+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Oracle EBS R11i, R12.1, R12.2 Installation, Administration (http://www.oraerp.com/forum-5.html)
+---- Thread: R12 Rapid clone mulit node to single node (12.1.1 on linux 5) (/thread-170.html)
R12 Rapid clone mulit node to single node (12.1.1 on linux 5) - Pryia Rai - 06-05-2011
Oracle Application R12.1.1 on linux 5 with 11g Database. I have attached R12 Rapid clone doc. we have mulit node PROD and TEST is single node. DB node(Server) and Apps node(Sever) and without shared appl_top.
R12 Clone Process set up in Spearlog
Esitmate hours : 6 hours and 2 hours DBA task
Note : Please use the cold backup for R12 clone process
------------------------------------------------------------------------------------------------
1) login as oraprod
cd /u01/app/spearprod/dbtechst/11.1.0/appsutil/scripts/PROD_speardb
perl adpreclone.pl dbTier
log file : /u01/app/spearprod/dbtechst/11.1.0/appsutil/log/PROD_speardb/StageDBTier_05081242.log
2) login as applmgr
cd /u01/app/spearprod/inst/apps/PROD_spearapp/admin/scripts
perl adpreclone.pl appsTier
Log file located at /u01/app/spearprod/inst/apps/PROD_spearapp/admin/log/StageAppsTier_05081250.log
3) Shutdown apps node (Server --> )
--------------------------------------------------------
cd $INST_TOP/admin/scripts
./adstpall.sh apps/prod0310apps
4) Shutdown Database node
--------------------------------------------------------
a) cd $ORACLE_HOME or cd /u01/app/spearprod/dbtechst/11.1.0
b) [oraprod@speardb 11.1.0]$ ls *.env
PROD_speardb.env SPEARTST_speartest.env
c) . PROD_speardb.env
d) sqlplus "/as sysdba"
e) SQL> shutdown immediate;
f) exit
g) lsnrctl STOP PROD
Note : wait for 5 mintus
-----------------------------------------------------------------------------------------------------------------------
4.A
-----------------------------------------------------------------------------------------------------------------------
login as oreatest
Stop the Oracle Application and Database
Clear the file system in oratest
--------------------------------
STEP 1 cd /u01/app/speartst
rm -rf inst
rm -rf 10.1.3
rm -rf 10.1.2
rm -rf dbtechst
rm -rf appl
rm -rf comn
STEP 2 cd /d01/app/speartst
rm -rf oradata
mkdir oradata
5)login as oraprod
a) cd /u01/app/spearprod
scp -r dbtechst oratest@0.71:/u01/app/speartst > /tmp/dbtechst.log
b) cd /d01/app/spearprod/oradata
scp -r *.dbf oratest@0.71:/d01/app/speartst/oradata > /tmp/datafile.log
6)logins applmgr(root) ()
cd /u01/app/spearprod/appl
scr -r inst 10.1.3 10.1.2 appl comn oratest@0.71:/u01/app/speartst > /tmp/apps.log
---------------------------------------------------------------------------------
7) cd /u01/app/speartst/dbtechst/11.1.0/appsutil/clone/bin
perl adcfgclone.pl dbTier (old password)
/u01/app/speartst/dbtechst/11.1.0/appsutil/log/SPEARTST_speartest/ApplyDBTier_05081706.log
8) /u01/app/speartst/comn/clone/bin
perl adcfgclone.pl appsTier (old password)
log file : /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/log/ApplyAppsTier_05082041.log
9) Post clone actitives
Change pasword
a) FNDCPASS apps/prod0310apps 0 Y system/aprodsystemspl USER SYSADMIN sysadmin123
FNDCPASS apps/prod0310apps 0 Y system/prodsystemspl SYSTEM APPLSYS apps123
change sys and system password
b) Shutdown the Application services in Apps tier node and db tier node before changing the APPS password.
------------------------------------------------------------------------------------------------------
c) DB node:
----------------
$ cd /u01/app/speartst/dbtechst/11.1.0
adautocfg.sh apps/newPasword
d) APPS node After running the autoconfig(new password)
---------------------------
$ cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts
adautocfg.sh apps/newPasword
e) Startup the Application on DB node & apps node
DB/CA Part
-------------------
Login oraTag ? user id . and shutdown all services
cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts
./adstrtal.sh apps/<apps Passwrd>
cd /u01/app/speartst/dbtechst/11.1.0
ls *.env
. SPEARTST_speartest.env
sqlplus "/as sysdba"
SQL > shutdown immediate
SQL > ! lsnrctl stop SPEARTST
SQL > startup
SQL > !lsnrctl start SPEARTST
APPS node
------------
cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts
./ adstrtal.sh apps/<apps Passwrd>
---------------------------------------------------------------------------
(h) Login as sysadmin through Application
http://speartest.spearlog.com:8020/OA_HTML/AppsLogin
---------------------------------------------------------------------------
i) Finishing task
---------------------
Change the Profile Values as below,
Site Name(eg: Spearlog PROD Clone of PROD as of 08/05/2010
Remove the timeout from profile :ICX%Sess%
java color :
Apps node: (all Manager are status like actual and target should be more >0 , if not run the Below the script
cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts./adcmctl.sh start apps/app01
Sumbit Active User Request & verified the Log file
j) verify the workflows managers
After the backup restore (usage in TEST server)
----------------------------------------------
[oratest@speartest appl]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p6 20G 11G 8.3G 56% /
/dev/cciss/c0d0p5 29G 173M 27G 1% /r01
/dev/cciss/c0d0p3 97G 47G 45G 52% /u01
/dev/cciss/c0d0p2 243G 55G 176G 24% /d01
/dev/cciss/c0d0p1 99M 12M 83M 12% /boot
tmpfs 2.5G 0 2.5G 0% /dev/shm