Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

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