Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com 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 by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 40 Vote(s) - 2.73 Average
  • 1
  • 2
  • 3
  • 4
  • 5
R12 Rapid clone mulit node to single node (12.1.1 on linux 5)
#1
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


Reply
Thanks given by:


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



Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!