Friday, 20 May 2016

R12.2 Oracle EBS Cloning Part-2


                          RUN adpreclone on TARGET RUN FILESYSTEM
cd /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/admin/scripts
RUN   perl adpreclone.pl appsTier
[oracle@testdevapp01 scripts$]$ adpreclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adpreclone Version 120.31.12020000.7
Enter the APPS User Password: /<prod apps pwd>
Enter the Weblogic AdminServer password: <prod weblogic pwd>.
Checking the status of the Oracle WebLogic Administration Server....
Running perl /testdevapps/R12.2/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /testdevapps/R12.2/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/testdevapps/R12.2/fs1/FMW_Home/jrockit64 mode=stage stage=/testdevapps/R12.2/fs1/EBSapps/comn/clone component=appsTier method= appctx=/testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml showProgress
Setting the wls environment
Beginning application tier Stage - Wed Oct 23 04:32:22 2013
/testdevapps/R12.2/fs1/FMW_Home/jrockit64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /testdevapps/R12.2/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/testdevapps/R12.2/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/testdevapps/R12.2/fs1/EBSapps/comn/java/classes:/testdevapps/R12.2/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/testdevapps/R12.2/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/testdevapps/R12.2/fs1/FMW_Home/webtier/oui/jlib/share.jar:/testdevapps/R12.2/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/testdevapps/R12.2/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/testdevapps/R12.2/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/testdevapps/R12.2/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /testdevapps/R12.2/fs1/inst/apps/TEST_rel-dem-prodas01/appl/admin/TESTDEV_testdevapp01.xml -stage /testdevapps/R12.2/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/admin/log/StageAppsTier_10230432.log
| 20% completed
Completed Stage...
Wed Oct 23 04:40:32 2013

      SHUTDOWN THE APPLICATION which is running on RUN FILESYSTEM
cd $ADMIN_SCRIPTS_HOME
adadminsrvctl.sh stop apps/<prod apps pwd>
Provide Weblogic admin password: <prod weblogic pwd>.
             COPY THE TARGET RUN FILESYSTEM to TARGET PATCH FILESYSTEM
Make sure you already created the directory structure like
mkdir -p /testdevapps/R12.2/fs1/
mkdir -p /testdevapps/R12.2/fs2/<----Here We need to copy EBSapps from /testdevapps/R12.2/fs1/
mkdir -p /testdevapps/R12.2/fs_ne/
UNSET the application Environment. Previously we have executed env.
Before we run adcfgclone.pl dont run any env's, directly go to
/testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/ and execute adcfgclone.pl
    Once Finished copying START CONFIGURING TARGET PATCH FILESYSTEM
cd  /testdevapps/R12.2/fs2/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 pwd>
Running:
/testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password: <prod weblogic pwd>
Running:
/testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] : no

Running:
/testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_4606.lst -stage /testdevapps/R12.2/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_4606.err; echo $? > /tmp/adcfgclone_4606.res
Log file located at /testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/CloneContext_1023054232.log
Target System File Edition type [run] : patch
Enter the full path of Run File System Context file :  
Provide the values required for creation of the new APPL_TOP Context file.
Target System Fusion Middleware Home set to /testdevapps/R12.2/fs2/FMW_Home
Target System Web Oracle Home set to /testdevapps/R12.2/fs2/FMW_Home/webtier
Target System Appl TOP set to /testdevapps/R12.2/fs2/EBSapps/appl
Target System COMMON TOP set to /testdevapps/R12.2/fs2/EBSapps/comn
Target System Instance Top set to /testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01
Target System Port Pool [0-99] : 3
Checking the port pool 3
done: Port Pool 3 is free
Report file located at /testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01/admin/out/portpool.lst
Complete port information available at /testdevapps/R12.2/fs2/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/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
 /testdevapps/R12.2/fs2/inst/apps/TEST_rel-dem-prodas01/appl/admin/TESTDEV_testdevapp01.xml
Log file located at /testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/CloneContext_1023054232.log
Check Clone Context logfile /testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/CloneContext_1023054232.log for details.
Running Rapid Clone with command:
Running:
perl /testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/adclone.pl java=/testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/testdevapps/R12.2/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /testdevapps/R12.2/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /testdevapps/R12.2/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml -stage /testdevapps/R12.2/fs2/EBSapps/comn/clone -log /testdevapps/R12.2/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Wed Oct 23 05:43:35 2013
/testdevapps/R12.2/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/java:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/testdevapps/R12.2/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/testdevapps/R12.2/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/testdevapps/R12.2/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01/appl/admin/TEST_rel-dem-prodas01.xml -stage /testdevapps/R12.2/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01/admin/log/ApplyAppsTier_10230543.log
 / 100% completed
Completed Apply...
Wed Oct 23 06:03:53 2013
Looking for incomplete CLONE record in ad_adop_session_patches table
The CLONE record status is no rows selected
Updating incomplete CLONE record to COMPLETED

Note: If TESTDEV PATCH context file is available in backup location then copy to its original location and give absolute path in adcfgclone.pl script. Target PATCH file system applications configure automatically without prompting any paths, values etc.,
Eg: cp /u01/backup/PATCH/TESTDEV_testdevapp01.xml /testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01/appl/admin/
perl adcfgclone.pl appsTier /testdevapps/R12.2/fs2/inst/apps/TESTDEV_testdevapp01/appl/admin/TESTDEV_testdevapp01.xml


 POST CLONE STEPS

Clean FND_ NODES

Select NODE_NAME, SUPPORT_CP, SUPPORT_FORMS,SUPPORT_WEB,SUPPORT_ADMIN from FND_NODES;

EXEC FND_CONC_CLONE.SETUP_CLEAN;

Update Concurrent Node Values as per below


Select target_node, node_name, node_name2 from FND_CONCURRENT_QUEUES;

Update FND_CONCURRENT_QUEUES set target_node='TESTDEVAPP01';

Update FND_CONCURRENT_QUEUES set node_name='TESTDEVAPP01';

Update FND_CONCURRENT_QUEUES set NODE_NAME2='TESTDEVAPP01';

Update fnd_concurrent_processes set node_name='TESTDEVAPP01';

Update FND_CONCURRENT_REQUESTS set LOGFILE_NODE_NAME='TESTDEVAPP01';


Cancel Requests by sql scripts

UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code =‘T’ OR phase_code = 'R';

UPDATE fnd_concurrent_requests
SET hold_flag = 'Y'
WHERE phase_code = 'P'
AND status_code in ('Q','I');
                                                                                                                                
 APPS Password Change

FNDCPASS apps/<prod apps pwd  0 Y system/<test system pwd> SYSTEM APPLSYS <test apps pwd>

FNDCPASS apps/<test apps pwd> 0 Y system//<test system pwd>  USER SYSADMIN <test Sysadmin pwd>

 Run Autoconfig in Database Tier and then Application tier

Note:-

Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. Do not start any other application tier services

Change the "apps" password in WLS Data source as follows:

Ø  Log in to WLS Administration Console.
Ø  Click Lock & Edit in Change Center.
Ø  In the Domain Structure tree, expand Services, then select Data Sources.
Ø  On the "Summary of JDBC Data Sources" page, select EBSDataSource.
Ø  On the "Settings for EBSDataSource" page, select the Connection Pool tab.
Ø  Enter the new password in the "Password" field.
Ø  Enter the new password in the "Confirm Password" field.
Ø  Click Save.
Ø  Click Activate Changes in Change Center.


Front End Activities if applicable

Ø  Profile BNE UIX Physical Directory should be updated by below value.

/testdevapps/R12.2/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/html/cabo/

Ø  Profile ICX: Session Timeout should be updated to 480 from 30.

Ø  Update XML Publisher Responsibility  administration value to $APPLTMP

/testdevapps/R12.2/fs1/inst/apps/TESTDEV_testdevapp01/appltmp

No comments:

Post a Comment