Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 52 Vote(s) - 2.73 Average
  • 1
  • 2
  • 3
  • 4
  • 5
R12 Rapid clone mulit node to single node (12.1.1 on linux 5)
06-05-2011, 04:31 AM,
R12 Rapid clone mulit node to single node (12.1.1 on linux 5)
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 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 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
./ 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

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 dbTier (old password)


8) /u01/app/speartst/comn/clone/bin
perl 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 apps/newPasword

d) APPS node After running the autoconfig(new password)
$ cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts 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
./ 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
./ apps/<apps Passwrd>

(h) Login as sysadmin through Application

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./ 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

Thanks given by:

Possibly Related Threads…
Thread Author Replies Views Last Post
  EBS R12 cannot print DPF Archita Jartin 2 4,543 08-21-2017, 04:21 PM
Last Post: mma007
  EBS R12.2 Installation error Sara Khan 1 4,458 07-16-2014, 05:39 AM
Last Post: Kashif Manzoor
  Creating ODG for DB part of Oracle Apps R12.1.3 sandy 4 5,784 07-03-2013, 05:30 AM
Last Post: Kashif Manzoor
  EBS R12 with RAC & ASM Installation on Solaris UNIX/RedHat Linux Richard 1 4,989 09-13-2012, 03:38 AM
Last Post: Kashif Manzoor

Users browsing this thread: 1 Guest(s)
Open Tech Talks Get Oracle Tutorials, Tips! Post a Question!