This document is divided into four parts
·
Pre-clone(Source)
·
Clone(Target)
·
Post-clone(Target)
·
Testing(Target)
Source System: - PROD
Target System:- TESTDEV
Details of PROD
- Applications :-- Multi node,
- Application Version :- 12.2.3
- Platform
:- Red Hat Enterprise Linux
Server release 6.6 (Santiago)
- Database Version :- Oracle Database 11g
Enterprise Edition Release 11.2.0.4.0
- Platform
:- Red Hat Enterprise Linux
Server release 6.5 (Santiago)
Details of TESTDEV
- Applications :-- Single node,
- Application Version :- 12.2.3
- Platform
:- Red Hat Enterprise Linux
Server release 6.6 (Santiago)
- Database Version :- Oracle Database 11g
Enterprise Edition Release 11.2.0.4.0
- Platform
:- Red Hat Enterprise Linux
Server release 6.6 (Santiago)
Step: -
1
Pre-clone PROD (Source)
We have to run this in Production. PROD should be up and
running.
Prepare the source system login to dbtier node of source and
execute the following script
$ORACLE_HOME/appsutil/scripts/PROD_proddb/
perl adpreclone.pl
dbTier
Login to appstier node of source and execute the following
script (Only from RUN File System)
$INST_TOP/admin/scripts/
perl adpreclone.pl
appsTier
Pre clone steps on TESTDEV (Target)
Bring down the services of the TESTDEV
instance if they are running for an existing instance. Login as oracle user and
run the adstpall.sh
$INST_TOP/admin/scripts/adstpall.sh
Apps pwd: xxxxx
Weblogic pwd: xxxxx
Login as the oracle user and bring down the
database and listener
Listener
: - lsnrctl stop TESTDEV. (Listener will be down by this command)
Database: - Connect to sqlplus and issue
the following command
Shut immediate
Verify the services are down or not by this
command
ps -ef|grep oracle
ps -ef|grep oracle
Backup the existing environment and XML
files before deleting the TOPS and Homes of the TESTDEV instance
As oracle User
RUN File System
cp /testdevapps/R12.2/fs1/EBSapps/appl/*env
/u01/backup/RUN
cp /testdevapps/R12.2/fs1/EBSapps/appl/admin/*env
/u01/backup/RUN
cp /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appl/admin/*xml
/u01/backup/RUN
Patch File System
cp /testdevapps/R12.2/fs2/EBSapps/appl/*env/
/u01/backup/PATCH
cp /testdevapps/R12.2/fs2/EBSapps/appl/admin/*env
/u01/backup/PATCH
cp /testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01/appl/admin/*xml
/u01/backup/PATCH
Database Backup
As oracle User
cp /oracle/11.2.0/TESTDEV/*env /u01/backup/DB
cp /oracle/11.2.0/TESTDEV/appsutil/*xml /u01/backup/DB
cp /oracle/11.2.0/TESTDEV/dbs/u01/backup/DB
cp /oracle/11.2.0/TESTDEV/network/admin/TESTDEV_testdevdb/*.ora
/u01/backup/DB
Note: - Will follow hotbackup or RMAN backup method to clone Database from
Source to Target.
Hotbackup:
1.
Login to source database and put in begin backup mode
Alter database begin backup;
2.
Copy dbf files to Target database node
3.
Once copy done put Source database in end backup mode
Alter database end backup;
4.
Take control file backup from source and copy to target.
5.
Edit control file and recreate it in target database.
6.
Recover database to supply archive log files.
7.
Run autoconfig.
8.
Start target database listener.
Application Cloning Processes
Step: - 1
Prepare Target
mkdir -p /testdevapps/R12.2/fs1/
mkdir -p /testdevapps/R12.2/fs2/
mkdir -p /testdevapps/R12.2 /fs_ne/
Choose only RUN FILE SYSTEM for copying from Source to target.
/PRODapps/R12.2/fs1
Copy Only
EBSapps directory to target
location /testdevapps/R12.2/fs1
After finishing the copy CONFIGURE TARGET RUN FILE SYSTEM
Go to clone directory
cd /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin
RUN
perl adcfgclone.pl appsTier
[oracle@testdevapp01 bin]$ perl
adcfgclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.22
Enter the APPS password: <prod apps
password>
Running:
/testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath /testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/clone/jlib/java:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/emCfg.jar
oracle.apps.ad.clone.util.OPWrapper -encryptpwd /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password:
<prod weblogic password>
Running:
/testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath /testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/emCfg.jar
oracle.apps.ad.clone.util.OPWrapper /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath /testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/emCfg.jar
oracle.apps.ad.clone.util.OPWrapper /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource
Do you want to add a node
(yes/no) [no] : no
Running:
/testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -cp /testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/ojdbc5.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/emCfg.jar
oracle.apps.ad.context.CloneContext -e /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_17052.lst -stage /testdevapps/R12.2/fs1/EBSapps/comn/clone
2> /tmp/adcfgclone_17052.err; echo $? > /tmp/adcfgclone_17052.res
Log file located at /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/CloneContext_1023030803.log
Target System File
Edition type [run] :run
Provide the values required for creation of
the new APPL_TOP Context file.
Target System Hostname
(virtual or normal) [Testdevapp01] : Testdevapp01
Target System Database
SID : TESTDEV
Target System Database
Server Node [testdevdb] : testdevdb
Target System Database
Domain Name [company.com] : company.com
Target System Base
Directory : /testdevapps/R12.2
Target System Base Directory set to /testdevapps/R12.2
Target System Current File System Base set to
/testdevapps/R12.2/fs1
Target System Other File System Base set to
/testdevapps/R12.2/fs2
Target System Fusion Middleware Home set to
/testdevapps/R12.2/fs1/FMW_Home
Target System Web Oracle Home set to /testdevapps/R12.2/fs1/FMW_Home/webtier
Target System Appl TOP set to /testdevapps/R12.2/fs1/EBSapps/appl
Target System COMMON TOP set to /testdevapps/R12.2/fs1/EBSapps/comn
Target System Instance Home Directory [/testdevapps/R12.2]
:
Target System Instance Top set to /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01
Do you want to preserve
the Display [prodapp01:0.0] (y/n) : n
Target System Display
[rel-dem-test01:0.0] : Testdevapp01:0.0
Target System Root Service [enabled] :
Target System Web Administration [enabled]
:
Target System Web Entry Point Services
[enabled] :
Target System Web Application Services
[enabled] :
Target System Batch Processing Services
[enabled] :
Target System Other Services [enabled] :
Do you want the target
system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool
[0-99] : 2
Checking the port pool 2
done: Port Pool 2 is free
Report file located at /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/admin/out/portpool.lst
Complete port information available at /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of
the following directories.
1. /usr/tmp
2. /tmp
3. /oracle/11.2.0/TESTDEV/appsutil/outbound/TESTDEV_testdevdb
4. /usr/tmp
Choose a value which will
be set as APPLPTMP value on the target node [1] : 1
Creating the new APPL_TOP Context file from
:
/testdevapps/R12.2/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been
created :
/testdevapps/R12.2/fs1/inst/apps/TEST_rel-dem-prodas01/appl/admin/TESTDEV_testdevapp01.xml
Log file located at /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/CloneContext_1023030803.log
Check Clone Context logfile /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/CloneContext_1023030803.log
for details.
Running Rapid Clone with command:
Running:
perl /testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/adclone.pl
java=/testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/testdevapps/R12.2/fs1/EBSapps/comn/clone
component=appsTier method=CUSTOM appctxtg=/testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml
showProgress contextValidated=true
FMW Pre-requisite check log file location :
/testdevapps/R12.2/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /testdevapps/R12.2/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java
-classpath /testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/java
oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml
-stage /testdevapps/R12.2/fs1/EBSapps/comn/clone
-log /testdevapps/R12.2/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Wed Oct
23 03:09:54 2013
/testdevapps/R12.2/fs1/EBSapps/comn/clone/bin/../jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/testdevapps/R12.2/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/testdevapps/R12.2/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar
oracle.apps.ad.clone.ApplyAppsTier -e /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml
-stage /testdevapps/R12.2/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/admin/log/ApplyAppsTier_10230309.log
|
100% completed
Completed Apply...
Wed Oct 23 03:28:43 2013
Executing
command: /testdevapps/R12.2/fs1/EBSapps/10.1.2/bin/sqlplus @/testdevapps/R12.2/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql
Do you want to startup
the Application Services for TEST? (y/n) [n] : n
Services not started
Once we are done with everything on RUN
File System. Start the admin server
RUN the ENV for the Application tier
cd $ADMIN_SCRIPTS_HOME
adadminsrvctl.sh start apps/<prod apps pwd>
Provide Weblogic Password: <prod weblogic pwd>.
Note: If TESTDEV RUN context file is
available in backup location then copy to its original location and give
absolute path in adcfgclone.pl script. Target RUN file system applications
configure automatically without prompting any paths, values etc.,
Eg: cp /u01/backup/RUN/TESTDEV_testdevapp01.xml
/testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appl/admin/
perl adcfgclone.pl appsTier
/testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml
Note:Please refer R12.2 Oracle EBS Cloning Part-2
No comments:
Post a Comment