Yuvi Sekar Apps DBA Consultant

Monday 24 March 2014

R12.2. Cloning Step-by-Step 27 comments

Here we go………………….

My First R12.2. Clone

STEP1:Prepare Souce Node for Cloning

Run adpreclone.pl from RUN File System

cd /d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/admin/scripts/

[applprod@idbaprod-appl 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:
Enter the Weblogic AdminServer password :
Checking the status of the Oracle WebLogic Administration Server....
Running perl /d01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/appl/admin/PROD_idbaprod-appl.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /d01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/d01/oracle/R122/fs1/FMW_Home/jrockit64 mode=stage stage=/d01/oracle/R122/fs1/EBSapps/comn/clone component=appsTier method= appctx=/d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/appl/admin/PROD_idbaprod-appl.xml showProgress

Setting the wls environment
Beginning application tier Stage - Wed Oct 23 04:32:22 2013
/d01/oracle/R122/fs1/FMW_Home/jrockit64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /d01/oracle/R122/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/d01/oracle/R122/fs1/EBSapps/comn/java/classes:/d01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/share.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/d01/oracle/R122/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/d01/oracle/R122/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/d01/oracle/R122/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/appl/admin/PROD_idbaprod-appl.xml -stage /d01/oracle/R122/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /d01/oracle/R122/fs1/inst/apps/PROD_idbaprod-appl/admin/log/StageAppsTier_10230432.log
| 20% completed
Completed Stage...
Wed Oct 23 04:40:32 2013

Step2:WHAT NEEDS TO BE COPIED
----------------------------

Choose only RUN FILE SYSTEM for copying

Prepare Target

mkdir -p /u01/oracle/R122/fs1/
mkdir -p /u01/oracle/R122/fs2/
mkdir -p /u01/oracle/R122/fs_ne/

STEP3:After finishing the copy CONFIGURE TARGET RUN FILE SYSTEM

Go to clone directory

cd /u01/oracle/R122/fs1/EBSapps/comn/clone/bin

RUN perl adcfgclone.pl appsTier

[appltest@rel-dem-test01 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 :
Running:
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password :
Running:
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource

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

Running:
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojdbc5.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_17052.lst -stage /u01/oracle/R122/fs1/EBSapps/comn/clone 2> /tmp/adcfgclone_17052.err; echo $? > /tmp/adcfgclone_17052.res
Log file located at /u01/oracle/R122/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) [rel-dem-test01] :
Target System Database SID : TEST
Target System Database Server Node [rel-dem-prodas01] : rel-dem-testdb01
Target System Database Domain Name [ora.ad] :
Target System Base Directory : /u01/oracle/R122
Target System Base Directory set to /u01/oracle/R122
Target System Current File System Base set to /u01/oracle/R122/fs1
Target System Other File System Base set to /u01/oracle/R122/fs2
Target System Fusion Middleware Home set to /u01/oracle/R122/fs1/FMW_Home
Target System Web Oracle Home set to /u01/oracle/R122/fs1/FMW_Home/webtier
Target System Appl TOP set to /u01/oracle/R122/fs1/EBSapps/appl
Target System COMMON TOP set to /u01/oracle/R122/fs1/EBSapps/comn
Target System Instance Home Directory [/u01/oracle/R122] :
Target System Instance Top set to /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01
Do you want to preserve the Display [rel-dem-prod01:0.0] (y/n) : n
Target System Display [rel-dem-test01:0.0] : rel-dem-test01:1.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] : 0
Checking the port pool 0
done: Port Pool 0 is free
Report file located at /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/admin/out/portpool.lst
Complete port information available at /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /u01/oracle/product/11.2.0/appsutil/outbound/TEST_rel-dem-proddb01
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
Creating the new APPL_TOP Context file from :
 /u01/oracle/R122/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
 /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-prodas01/appl/admin/TEST_rel-dem-test01.xml
Log file located at /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/CloneContext_1023030803.log
Check Clone Context logfile /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/CloneContext_1023030803.log for details.
Running Rapid Clone with command:
Running:
perl /u01/oracle/R122/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/oracle/R122/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/oracle/R122/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u01/oracle/R122/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml -stage /u01/oracle/R122/fs1/EBSapps/comn/clone -log /u01/oracle/R122/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Wed Oct 23 03:09:54 2013
/u01/oracle/R122/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/R122/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml -stage /u01/oracle/R122/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/admin/log/ApplyAppsTier_10230309.log
 | 100% completed
Completed Apply...
Wed Oct 23 03:28:43 2013

 Executing command: /u01/oracle/R122/fs1/EBSapps/10.1.2/bin/sqlplus @/u01/oracle/R122/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] :
Services not started

STEP4:Once we are done with everything. Start the application Tier using adstral.sh
———————————————————————————–

RUN the ENV for the Applciation tier

cd $ADMIN_SCRIPTS_HOME

adstral.sh apps/apps

Provide Weblogic Password:
Once application is up do a sample Health Check.
STEP4:RUN adpreclone on TARGET RUN FILESYSTEM

[appltest@rel-dem-test01 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:
Enter the Weblogic AdminServer password :
Checking the status of the Oracle WebLogic Administration Server....
Running perl /u01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /u01/oracle/R122/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/oracle/R122/fs1/FMW_Home/jrockit64 mode=stage stage=/u01/oracle/R122/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml showProgress

Setting the wls environment
Beginning application tier Stage - Wed Oct 23 04:32:22 2013
/u01/oracle/R122/fs1/FMW_Home/jrockit64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/R122/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/oracle/R122/fs1/EBSapps/comn/java/classes:/u01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/R122/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/oracle/R122/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/R122/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-prodas01/appl/admin/TEST_rel-dem-test01.xml -stage /u01/oracle/R122/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/admin/log/StageAppsTier_10230432.log
| 20% completed
Completed Stage...
Wed Oct 23 04:40:32 2013

STEP5:SHUTDOWN THE APPLICATION which is running on RUN FILESYSTEM
------------------------------------------------------------------
cd $ADMIN_SCRIPTS_HOME
adstpal.sh apps/apps
provide Weblogic admin password:

STEP6:COPY THE TARGET RUN FILESYSTEM to TARGET PATCH FILESYSTEM
----------------------------------------------------------------
make sure you already created the directory structure like

mkdir -p /u01/oracle/R122/fs1/
mkdir -p /u01/oracle/R122/fs2/<-------------------Here We need to copy EBSapps from /u01/oracle/R122/fs1/
mkdir -p /u01/oracle/R122/fs_ne/
UNSET the application Enviroment.Previously we have executed env.
Before we run adcfgclone.pl dont run any env's, Directly go to /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/ and execute adcfgclone.pl
STEP7:Once Finished copying START CONFIGURING TARGET PATCH FILESYSTEM
---------------------------------------------------------------------
[appltest@rel-dem-test01 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 :
Running:
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password :
Running:
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource

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

Running:
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_4606.lst -stage /u01/oracle/R122/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_4606.err; echo $? > /tmp/adcfgclone_4606.res
Log file located at /u01/oracle/R122/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 : /u01/oracle/R122/fs1/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml
Provide the values required for creation of the new APPL_TOP Context file.
Target System Fusion Middleware Home set to /u01/oracle/R122/fs2/FMW_Home
Target System Web Oracle Home set to /u01/oracle/R122/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/oracle/R122/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/oracle/R122/fs2/EBSapps/comn
Target System Instance Top set to /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01
Target System Port Pool [0-99] : 1
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/admin/out/portpool.lst
Complete port information available at /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /u01/oracle/product/11.2.0/appsutil/outbound/TEST_rel-dem-testdb1
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
Creating the new APPL_TOP Context file from :
 /u01/oracle/R122/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
 /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-prodas01/appl/admin/TEST_rel-dem-test01.xml
Log file located at /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/CloneContext_1023054232.log
Check Clone Context logfile /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/CloneContext_1023054232.log for details.
Running Rapid Clone with command:
Running:
perl /u01/oracle/R122/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/oracle/R122/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/oracle/R122/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u01/oracle/R122/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-test01.xml -stage /u01/oracle/R122/fs2/EBSapps/comn/clone -log /u01/oracle/R122/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Wed Oct 23 05:43:35 2013
/u01/oracle/R122/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/java:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/oracle/R122/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/oracle/R122/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/R122/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/appl/admin/TEST_rel-dem-prodas01.xml -stage /u01/oracle/R122/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/oracle/R122/fs2/inst/apps/TEST_rel-dem-test01/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

STEP8:Once we are done with everything. Start the application Tier using adstral.sh

This time set the env to RUN File System

. /u01/oracle/R122/EBSapps.env run

cd $ADMIN_SCRIPTS_HOME

adstral.sh apps/apps

Hope so this Helps…………………

Ref : http://balaoracledba.com/2013/10/23/r12-2-cloning-step-by-step/

Saturday 22 February 2014

Change Apps Password For Oracle EBS 11i and R12 with FNDCPASS

Oracle E-Business Suite provides a command line utility called FNDCPASS to change passwords.
4 mode is avaliable for FNDCPASS, details below
Note: To use this command line utility set application enviroment file (for example APPSORA.env)

SYSTEM ==> To change the APPS and APPLSYS schema password
ORACLE ==> To change single Application Schema password (other than APPS/APPLSYS)
ALLORACLE === To change all ORACLE schema passwords
USER ==> To change Oracle Applications user password

1. Usage: FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new_password>
Example: FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
Note: Passwords for APPLSYS and the APPS schemas must be the same.
If you change the password for one, FNDCPASS automatically changes the others.
Change password for APPS and APPLSYS when concurrent manager is down.
After changing APPLSYS and APPS password in 11i should change hardcoded password manually in wdbsvr.app file under $IAS_ORACLE_HOME/Apache/modplsql/cfg. Also recommend to run autoconfig
Also there are some files to modify listed below but for new versions of 11.5.x is not necessary

$FND_TOP/resource/wfmail.cfg
$COMMON_TOP/admin/scripts/<context_name>/adcmctl.sh
$AD_TOP/admin/template/CGIcmd.dat
$OA_HTML/bin/appsweb.cfg

2. Usage: FNDCPASS <logon> 0 Y <system/password> ORACLE <username> <new_password>

Example: FNDCPASS apps/apps 0 Y system/manager ORACLE AP passwd1

3. Usage: FNDCPASS <logon> 0 Y <system/password> ALLORACLE <new_password>
Example: FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME
Note: Usernames must appear in the FND_USER or FND_ORACLE_USERID tables.
FNDCPASS utility and ALLORACLE functionality was designed for applications users/schemas.
Other users passwords must be manually changed(Examle: ABM,CSS,DBSNMP,EVM,SYS,etc.)

4. Usage: FNDCPASS <logon> 0 Y <system/password> USER <username> <new_password>
Example : FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN WELCOME

How to change the Apps Password in 11i Oracle Application

Everyone knows Apps Password changing policy or process. But after changing the password, We have to run autoconfig in Application Level. Sometimes, After autoconfig run, Custom level setting will be lose. So, Better We can choose manually way the apps password.

Two Method for Changing Apps Password using FNDCPSS

A. Autoconfig method after password change

B. Manually method after password change.

A. Autocong method after password change:-

1. Shutdown all the application nodes.

2. Issue the commands at the Unix command line similar to the following:

To change the APPS and APPLSYS passwords:

$FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps123

3. Check the apps password is working using "sqlplus apps/apps123".

4. Run the autoconfig in application nodes.

5. Start the application services.

6. Check Application Health checkup.

B. Manually method after password change.

1. Shutdown all the application nodes.

2. Shutdown the concurrent node.

3. Backup the below given 3 files before changing the apps password:

i) $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app

ii) 8.0.6 Oracle_home : $ORACLE_HOME/reports60/server/CGIcmd.dat

iii) $FND_TOP/resource/wfmail.cfg

4. Issue the commands at the Unix command line similar to the following:

To change the APPS and APPLSYS passwords:

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS <new password>

$FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps123

NOTE 1: Changing the APPLSYS password automatically changes the APPS password

to match as these two must always agree.

NOTE 2: VERY IMPORTANT!!

When changing the password for APPS it is important to manually change the APPS

password in the following files as well as necessary:

5. Change the apps password in the following files:

i). $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app

(Otherwise users will not be able to login to the Personal Home Page or Self-service web apps.)

ii). 8.0.6 Oracle_home : $ORACLE_HOME/reports60/server/CGIcmd.dat

iii). Workflow Notification Mailer - $FND_TOP/resource/wfmail.cfg

6. Start the concurrrent manager script.

7. Start all the application nodes.

8. Application Health checkup.

8. Submit a concurrent request and check that request completes successfully.

Migrating an Oracle database from non-ASM to ASM

By Sangamesh B Satihal, Oracle DBA

We can configure an ASM using DBCA or manually. Once the ASM is configured on the server and diskgroup is created, any database that resides on that server can start using ASM for its data storage. We can achieve this by migrating all datafiles, controlfiles, redolog files, archive logs and, if required, parameter files to ASM.

Use the following steps to migrate an existing Oracle database from a local file system to ASM. These steps are applicable for both 10g and 11g releases.

1. In this example, we will use MYASMDB database to migrate from file system to ASM. Get the details of all files of the database MYASMDB as below. All of the files listed in this query will be relocated from the local file system to ASM:

#> . oraenv
ORACLE_SID = [oracle] ? MYASMDB
The Oracle base for ORACLE_HOME=/orasw/app/oracle/product/11_2_0_2 is /orasw/app/oracle
#= Testing Env =oracle@sangam /var/opt/oracle
#> sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.2.0 Production on Wed Dec 7 05:10:09 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SQL> SELECT
2 d.tablespace_name tablespace
3 , d.file_name filename
4 , d.bytes filesize
5 , d.autoextensible autoextensible
, d.increment_by * e.value increment_by
6 7 , d.maxbytes maxbytes
8 FROM
9 sys.dba_data_files d
10 , v$datafile v
11 , (SELECT value
12 FROM v$parameter
13 WHERE name = 'db_block_size') e
14 WHERE
15 (d.file_name = v.name)
16 UNION
17 SELECT
18 d.tablespace_name tablespace
19 , d.file_name filename
20 , d.bytes filesize
21 , d.autoextensible autoextensible
22 , d.increment_by * e.value increment_by
23 , d.maxbytes maxbytes
24 FROM
sys.dba_temp_files d
25 26 , (SELECT value
27 FROM v$parameter
28 WHERE name = 'db_block_size') e
29 UNION
30 SELECT
31 '[ ONLINE REDO LOG ]'
32 , a.member
33 , b.bytes
34 , null
35 , TO_NUMBER(null)
, TO_NUMBER(null)
36 37 FROM
38 v$logfile a
39 , v$log b
40 WHERE
41 a.group# = b.group#
42 UNION
43 SELECT
44 '[ CONTROL FILE ]'
45 , a.name
46 , TO_NUMBER(null)
47 , null
48 , TO_NUMBER(null)
49 , TO_NUMBER(null)
50 FROM
51 v$controlfile a
52 ORDER BY 1,2
/ 53

Tablespace Name / File Class Filename File Size Auto Next Max
----------------------------- ---------------------------------------------------------------- --------------- ---- --------------- ---------------
CISTS_01 /oradata_01/MYASMDB/cists01.dbf 536,870,912 YES 8,388,608 34,359,721,984
SYSAUX /oradata_01/MYASMDB/SYSAUX.dbf 188,743,680 YES 10,485,760 34,359,721,984
SYSTEM /oradata_01/MYASMDB/system01.dbf 501,219,328 YES 10,485,760 34,359,721,984
TEMP /oradata_01/MYASMDB/temp01.dbf 67,108,864 YES 8,388,608 34,359,721,984
TOOLS /oradata_01/MYASMDB/tools01.dbf 67,108,864 YES 8,388,608 34,359,721,984
UNDOTBS1 /oradata_01/MYASMDB/UNDOTBS1.dbf 379,584,512 YES 8,192 34,359,721,984
USERS /oradata_01/MYASMDB/user01.dbf 536,870,912 YES 8,388,608 34,359,721,984
XMLDBTS_01 /oradata_01/MYASMDB/xmldbts01.dbf 536,870,912 YES 8,388,608 34,359,721,984
[ CONTROL FILE ] /oradata_01/MYASMDB/control01.ctl
[ CONTROL FILE ] /oradata_01/MYASMDB/control02.ctl
[ CONTROL FILE ] /oradata_01/MYASMDB/control03.ctl
[ ONLINE REDO LOG ] /oradata_01/MYASMDB/redo01.log 10,485,760
[ ONLINE REDO LOG ] /oradata_01/MYASMDB/redo02.log
[ ONLINE REDO LOG ] /oradata_01/MYASMDB/redo03.log 10,485,760

14 rows selected.

2. With the target database open, edit the initialization parameter control_files and db_create_file_dest to point to the ASM disk group + DATA. Also configure db_recovery_file_dest to point to the ASM disk group +DATA as below.

SQL> ALTER SYSTEM SET control_files='+DATA' scope=spfile;
ALTER SYSTEM SET control_files='+DATA' scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use

Since DB was brought up with pfile so we got above error. Let us create spfile and bring up the database with spfile as blow.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile;

File created.

SQL> startup;
ORACLE instance started.

Total System Global Area 1603887104 bytes
Fixed Size 2158744 bytes
Variable Size 419434344 bytes
Database Buffers 1174405120 bytes
Redo Buffers 7888896 bytes
Database mounted.
Database opened.
SQL>
SQL> ALTER SYSTEM SET control_files='+DATA' scope=spfile;

System altered.

SQL> ALTER SYSTEM SET db_create_file_dest='+DATA' scope=spfile;

System altered.

SQL> ALTER SYSTEM SET db_recovery_file_dest='+DATA' scope=spfile;

System altered.

3. Startup the target database in NOMOUNT mode:

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1603887104 bytes
Fixed Size 2158744 bytes
Variable Size 436211560 bytes
Database Buffers 1157627904 bytes
Redo Buffers 7888896 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
#= Testing Env =oracle@sangam /var/opt/oracle

4. From an RMAN session, copy one of your controlfiles from the local file system to its new location in ASM. The new controlfile will be copied to the value specified in the initialization parameter control_files

#> rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Wed Dec 7 05:25:46 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: MYASMDB (not mounted)

RMAN> RESTORE CONTROLFILE FROM '/oradata_01/MYASMDB/control01.ctl';

Starting restore at 07-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1345 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATA/MYASMDB/controlfile/current.502.769238817
Finished restore at 07-DEC-11

5. From an RMAN or SQL*Plus session, mount the database. This will mount the database using the controlfile stored in ASM

RMAN> ALTER DATABASE MOUNT;

database mounted
released channel: ORA_DISK_1

6. From an RMAN session, copy the database files from the local file system to ASM

RMAN> BACKUP AS COPY DATABASE FORMAT '+DATA';

Starting backup at 07-DEC-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1345 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/oradata_01/MYASMDB/cists01.dbf
output file name=+DATA/MYASMDB/datafile/cists_01.503.769238853 tag=TAG20111207T052733 RECID=1 STAMP=769238942
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/oradata_01/MYASMDB/user01.dbf
output file name=+DATA/MYASMDB/datafile/users.504.769238949 tag=TAG20111207T052733 RECID=2 STAMP=769239026
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/oradata_01/MYASMDB/xmldbts01.dbf
output file name=+DATA/MYASMDB/datafile/xmldbts_01.505.769239035 tag=TAG20111207T052733 RECID=3 STAMP=769239111
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/oradata_01/MYASMDB/system01.dbf
output file name=+DATA/MYASMDB/datafile/system.506.769239119 tag=TAG20111207T052733 RECID=4 STAMP=769239191
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/oradata_01/MYASMDB/UNDOTBS1.dbf
output file name=+DATA/MYASMDB/datafile/undotbs1.507.769239195 tag=TAG20111207T052733 RECID=5 STAMP=769239239
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/oradata_01/MYASMDB/SYSAUX.dbf
output file name=+DATA/MYASMDB/datafile/sysaux.508.769239249 tag=TAG20111207T052733 RECID=6 STAMP=769239273
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/oradata_01/MYASMDB/tools01.dbf
output file name=+DATA/MYASMDB/datafile/tools.509.769239275 tag=TAG20111207T052733 RECID=7 STAMP=769239286
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=+DATA/MYASMDB/controlfile/backup.510.769239289 tag=TAG20111207T052733 RECID=8 STAMP=769239290
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 07-DEC-11
channel ORA_DISK_1: finished piece 1 at 07-DEC-11
piece handle=+DATA/MYASMDB/backupset/2011_12_07/nnsnf0_tag20111207t052733_0.511.769239291 tag=TAG20111207T052733 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 07-DEC-11

7. From an RMAN session, update the control file / data dictionary so that all database files point to the RMAN copy made in ASM

RMAN> SWITCH DATABASE TO COPY;

datafile 1 switched to datafile copy "+DATA/MYASMDB/datafile/system.506.769239119"
datafile 2 switched to datafile copy "+DATA/MYASMDB/datafile/sysaux.508.769239249"
datafile 3 switched to datafile copy "+DATA/MYASMDB/datafile/undotbs1.507.769239195"
datafile 4 switched to datafile copy "+DATA/MYASMDB/datafile/tools.509.769239275"
datafile 5 switched to datafile copy "+DATA/MYASMDB/datafile/cists_01.503.769238853"
datafile 6 switched to datafile copy "+DATA/MYASMDB/datafile/users.504.769238949"
datafile 7 switched to datafile copy "+DATA/MYASMDB/datafile/xmldbts_01.505.769239035"

RMAN> exit
Recovery Manager complete.
#= Testing Env =oracle@sangam /var/opt/oracle

8. From a SQL*Plus session, perform incomplete recovery and open the database using the RESETLOGS option

#> sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.2.0 Production on Wed Dec 7 05:35:40 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279: change 717263 generated at 12/07/2011 05:24:55 needed for thread 1
ORA-00289: suggestion : +DATA
ORA-15173: entry 'ARCHIVELOG' does not exist in directory 'MYASMDB'
ORA-00280: change 717263 for thread 1 is in sequence #177

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL> select name,status from v$database,v$instance;

NAME STATUS
--------- ------------
MYASMDB OPEN

9. From a SQL*Plus session, re-create any tempfiles that are still currently on the local file system to ASM. This is done by simply dropping the tempfiles from the local file system and re-creating them in ASM as below.
SQL> select tablespace_name, file_name, bytes from dba_temp_files;

TABLESPACE_NAME
------------------------------
FILE_NAME
--------------------------------------------------------------------------------
BYTES
----------
TEMP
/oradata_01/MYASMDB/temp01.dbf
67108864

SQL> alter database tempfile '/oradata_01/MYASMDB/temp01.dbf' drop including datafiles;

Database altered.

SQL> alter tablespace temp add tempfile size 512m;

Tablespace altered.

SQL> select tablespace_name, file_name, bytes from dba_temp_files;

TABLESPACE_NAME
------------------------------
FILE_NAME
--------------------------------------------------------------------------------
BYTES
----------
TEMP
+DATA/MYASMDB/tempfile/temp.512.769239527
536870912

10. From a SQL*Plus session, re-create any online redo logfiles that are still currently on the local file system to ASM. This is done by simply dropping the logfiles from the local file system and re-creating them in ASM as below.

Note : While dropping redolog group, make sure that it is not current redolog group. If you do so, you will get error as
SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE GROUP 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance MYASMDB (thread 1)
ORA-00312: online log 1 thread 1: '<file_name>'

It cab resolved by making that redogroup inactive by switching log file or by performing checkpoint on the database.

SQL> set linesize 500;
SQL> select a.group#, a.member, b.bytes from v$logfile a, v$log b where a.group# = b.group#;

GROUP#
----------
MEMBER
--------------------------------------
BYTES
----------
1
/oradata_01/MYASMDB/redo01.log
10485760

2
/oradata_01/MYASMDB/redo02.log
10485760

GROUP#
----------
MEMBER

BYTES
----------

3
/oradata_01/MYASMDB/redo03.log
10485760

SQL> set pagesize 500;
SQL> /

GROUP#
----------
MEMBER

BYTES
----------
1
/oradata_01/MYASMDB/redo01.log
10485760

2
/oradata_01/MYASMDB/redo02.log
10485760

3
/oradata_01/MYASMDB/redo03.log
10485760

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 CURRENT
2 UNUSED
3 UNUSED

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 CURRENT
2 INACTIVE
3 INACTIVE

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> select group#,status from v$log;

GROUP# STATUS
---------- ----------------
1 INACTIVE
2 INACTIVE
3 CURRENT

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database add logfile group 1 size 100m;

Database altered.

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 UNUSED
2 INACTIVE
3 CURRENT

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database add logfile group 2 size 100m;

Database altered.

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 UNUSED
2 UNUSED
3 CURRENT

SQL> alter system switch logfile;

System altered.

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 CURRENT
2 UNUSED
3 ACTIVE

SQL> alter system switch logfile;

System altered.

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 ACTIVE
2 CURRENT
3 ACTIVE

SQL> alter system switch logfile;

System altered.

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 ACTIVE
2 ACTIVE
3 CURRENT

SQL> alter system switch logfile;
/
System altered.

SQL> /

System altered.

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 INACTIVE
2 CURRENT
3 INACTIVE

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database add logfile group 3 size 100m;

Database altered.

11. Verify that all online redo logfiles have been created in ASM

SQL> select a.group#, a.member, b.bytes from v$logfile a, v$log b where a.group# = b.group#;

GROUP#
----------
MEMBER

BYTES
----------
1
+DATA/MYASMDB/onlinelog/group_1.513.769239709
104857600

2
+DATA/MYASMDB/onlinelog/group_2.515.769239751
104857600

3
+DATA/MYASMDB/onlinelog/group_3.517.769239855
104857600

1
+DATA/MYASMDB/onlinelog/group_1.514.769239709
104857600

2
+DATA/MYASMDB/onlinelog/group_2.516.769239751
104857600

3
+DATA/MYASMDB/onlinelog/group_3.518.769239855
104857600

6 rows selected.

12. Perform the below steps to relocate the SPFILE from the local file system to an ASM disk group.

SQL> create pfile from spfile;

File created.

SQL> CREATE SPFILE='+DATA/MYASMDB/spfileMYASMDB.ora' from pfile;

File created.

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1603887104 bytes
Fixed Size 2158744 bytes
Variable Size 452988776 bytes
Database Buffers 1140850688 bytes
Redo Buffers 7888896 bytes
Database mounted.
Database opened.

13. Verify that all database files have been created in ASM

SQL>
SQL> SELECT
2 d.tablespace_name tablespace
3 , d.file_name filename
4 , d.bytes filesize
5 , d.autoextensible autoextensible
6 , d.increment_by * e.value increment_by
7 , d.maxbytes maxbytes
8 FROM
9 sys.dba_data_files d
10 , v$datafile v
11 , (SELECT value
12 FROM v$parameter
13 WHERE name = 'db_block_size') e
14 WHERE
15 (d.file_name = v.name)
UNION
16 17 SELECT
18 d.tablespace_name tablespace
19 , d.file_name filename
, d.bytes filesize
20 21 , d.autoextensible autoextensible
22 , d.increment_by * e.value increment_by
23 , d.maxbytes maxbytes
24 FROM
25 sys.dba_temp_files d
26 , (SELECT value
27 FROM v$parameter
28 WHERE name = 'db_block_size') e
29 UNION
30 SELECT
31 '[ ONLINE REDO LOG ]'
32 , a.member
33 , b.bytes
34 , null
35 , TO_NUMBER(null)
36 , TO_NUMBER(null)
37 FROM
38 v$logfile a
39 , v$log b
40 WHERE
41 a.group# = b.group#
42 UNION
SELECT
43 44 '[ CONTROL FILE ]'
45 , a.name
46 , TO_NUMBER(null)
47 , null
48 , TO_NUMBER(null)
49 , TO_NUMBER(null)
50 FROM
51 v$controlfile a
52 ORDER BY 1,2
53 /

Tablespace Name / File Class Filename File Size Auto Next Max
----------------------------- ---------------------------------------------------------------- --------------- ---- --------------- ---------------
CISTS_01 +DATA/MYASMDB/datafile/cists_01.503.769238853 536,870,912 YES 8,388,608 34,359,721,984
SYSAUX +DATA/MYASMDB/datafile/sysaux.508.769239249 188,743,680 YES 10,485,760 34,359,721,984
SYSTEM +DATA/MYASMDB/datafile/system.506.769239119 501,219,328 YES 10,485,760 34,359,721,984
TEMP +DATA/MYASMDB/tempfile/temp.512.769239527 536,870,912 YES 262,144,000 34,359,721,984
TOOLS +DATA/MYASMDB/datafile/tools.509.769239275 67,108,864 YES 8,388,608 34,359,721,984
UNDOTBS1 +DATA/MYASMDB/datafile/undotbs1.507.769239195 379,584,512 YES 8,192 34,359,721,984
USERS +DATA/MYASMDB/datafile/users.504.769238949 536,870,912 YES 8,388,608 34,359,721,984
XMLDBTS_01 +DATA/MYASMDB/datafile/xmldbts_01.505.769239035 536,870,912 YES 8,388,608 34,359,721,984
[ CONTROL FILE ] +DATA/MYASMDB/controlfile/current.502.769238817
[ ONLINE REDO LOG ] +DATA/MYASMDB/onlinelog/group_1.513.769239709 104,857,600
[ ONLINE REDO LOG ] +DATA/MYASMDB/onlinelog/group_1.514.769239709 104,857,600
[ ONLINE REDO LOG ] +DATA/MYASMDB/onlinelog/group_2.515.769239751 104,857,600
[ ONLINE REDO LOG ] +DATA/MYASMDB/onlinelog/group_2.516.769239751 104,857,600
[ ONLINE REDO LOG ] +DATA/MYASMDB/onlinelog/group_3.517.769239855 104,857,600
[ ONLINE REDO LOG ] +DATA/MYASMDB/onlinelog/group_3.518.769239855 104,857,600

15 rows selected.

14. At this point, the target database(MYASMDB) is open with all of its datafiles, controlfiles, online redo logfiles, tempfiles, and SPFILE stored in ASM. If we want to remove the database files that were stored on the local file system , this can be done from an RMAN session by executing below command. You could also then remove the old version of the controfile(s) that were stored on the local file system. All local file system files can be removed manually also.

RMAN> DELETE NOPROMPT FORCE COPY;

Wednesday 19 February 2014

11I CLONING ISSUES:
*******************

Troubleshooting RapidClone issues with Oracle Applications 11i [ID : 364565.1]

DB TIER:
********

ISSUE 1:

kshell unable to connect.
orasdev@oraapps # export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'

*********************************************************************************************************************

ISSUE 2:

While running adcfgclone on the "DBTIER" we would get the following error:
$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps
ERROR : Unable to set CLASSPATH
/visdb/proddb/9.2.0/appsutil/clone/bin/../jlib/classes111.zip: is missing

ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone.err file for errors

When we would go through the adcfgclone.err:

vi /tmp/adcfgclone.err

orasdev@oraapps # cp $iAS_TOP/portal30/admin/plsql/lib/classes111.zip /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/jlib/

*********************************************************************************************************************

ISSUE 3:

While running adcfgclone on the "DBTIER" we would get the following error:
$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:

ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone.err file for errors

orasdev@oraapps # vi /tmp/adcfgclone.err
orasdev@oraapps # /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/jre/bin/i386/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory

*******************************************************************************************************************

ISSUE 4:

Jdk file installation
root@oraapps # chmod +x jdk-6u26-linux-i586-rpm.bin
root@oraapps # ./jdk-6u26-linux-i586-rpm.bin

*****************************************************************************************************************

ISSUE 5:

ln -s /usr/lib/libstdc++-libc6.2.2.so.3 /usr/lib/libstdc++-libc6.1-1.so.2

*********************************************************************************************************************

ISSUE 6:

The 806 installer uses the oratab file.
The file oratab needs to exist at:
/etc/oratab
Rapid Clone will use the oraInst.loc file.
The file oraInst.loc needs to exist at:
/etc/oraInst.loc
Please run the script /tmp/orainstRoot.sh as root

Restart adclone.pl after performing required corrections.

ERROR: Failed to execute /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/bin/adclone.pl

Please check logfile.

root@oraapps # cd /tmp
root@oraapps tmp # sh orainstRoot.sh

******************************************************************************************************************

ISSUE 7:

Beginning database tier Apply - Mon May 7 19:24:48 2012
Log file located at /sdev/p02/oracle/pixdb/9.2.0/appsutil/log/sdev_oraapps/Apply DBTier_05070724.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
RC-50014: Fatal: Execution of AutoConfig was failed

ERROR while running Apply... 50%

ERROR: Failed to execute /sdev/p02/oracle/pixdb/9.2.0/appsutil/clone/bin/adclone.pl

Please check logfile.

root@oraapps # vi /sdev/p02/oracle/pixdb/9.2.0/appsutil/log/sdev_oraapps/Apply DBTier_05070724.log

afmkinit.sh exiting with status 127

.end std out.
cp: error while loading shared libraries: /usr/lib/libc.so.6: invalid ELF header
touch: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory

.end err out.
****************************************************

Skipping Profile Phase
Skipping Apply Phase

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>

[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /sdev/p02/oracle/pixdb/9.2.0/appsutil/install/sdev_oraapps
afmkinit.sh INSTE8_SETUP 127

AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDatabase

StackTrace:
java.lang.Exception: RC-50014: Fatal: Execution of AutoConfig was failed
at oracle.apps.ad.clone.ApplyDatabase.checkAutoConfigErr(ApplyDatabase.java:2792)
at oracle.apps.ad.clone.ApplyDatabase.runAutoConfig(ApplyDatabase.java:2587)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:595)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)

root@oraapps # vi /sdev/p02/oracle/pixdb/9.2.0/appsutil/bin/adgetlnxver.sh
Edit from LD to XD

**********************************************************************************************************************

APPS TIER:
**********

ISSUE 1:

kshell unable to connect.
orasdev@oraapps # export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'

**********************************************************************************************************************

ISSUE 2:
/etc/oraInst.loc points to an Inventory that does not exist:
/home/orasdev/oraInventory
mkdir /home/orasdev/oraInventory: Permission denied at /sdev/p01/oracle/pixcomn/clone/bin/adclone.pl line 1331

ERROR: Failed to execute /sdev/p01/oracle/pixcomn/clone/bin/adclone.pl
Please check logfile.

root@oraapps # vi /etc/oraInst.loc
Edit from /home/orasdev/oraInventory to /home/applsdev/oraInventory

*********************************************************************************************************************

ISSUE 3:

Beginning application tier Apply - Mon May 7 20:16:57 2012
Log file located at /sdev/p01/oracle/pixappl/admin/sdev_oraapps/log/ApplyAppsTier_05070816.log
/ 50% completed
AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management
Deactivating Context Value Management System.
Restored the Context file in :
/sdev/p01/oracle/pixappl/admin/sdev_oraapps.xml

Aborting the running of Context Value Management
Error occured before Context Value Management could be completed

Completed Apply...
Mon May 7 20:21:57 2012

Beginning APPSIAS_sdev registration to central inventory...

ORACLE_HOME NAME : APPSIAS_sdev
ORACLE_HOME PATH : /sdev/p01/oracle/pixora/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /home/applsdev/oraInventory/logs/OracleHomeCloner_05070821.log
ORACLE_HOME /sdev/p01/oracle/pixora/iAS was registered successfully.

Skipping the starting of services
INFO : Rapid Clone completed successfully , but the AutoConfig run recorded some errors.
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line after fixing the problem
Once Autoconfig issue is fixed , you can start services

root@oraapps # vi /sdev/p01/oracle/pixappl/admin/sdev_oraapps/log/ApplyAppsTier_05070821.log
error while loading shared library libdb.so.3
error while loading shared library libdl.so.2
error while loading shared library librt.so.1

adautoconfig.sh exiting status with 127
(or)
adautoconfig.sh exiting status with 49

Solution:-

[applsdev@oraapps]$ cd /sdev/p01/oracle/pixappl
[applsdev@oraapps]$ . ./APPSsdev_oraapps.env
[applsdev@oraapps]$ unset LD_LIBRARY_PATH
[applsdev@oraapps]$ echo $LD_ASSUME_KERNEL
2.4.19
[applsdev@oraapps]$ unset LD_ASSUME_KERNEL

Apply Below Patch:-

Download patch no : 6365595
[applsdev@oraapps]$ cd /home/applsdev
[applsdev@oraapps]$ ls
oraInventory 6365595 p6365595_11i_GENERIC.zip
[applsdev@oraapps]$ unzip p6365595_11i_GENERIC.zip
[applsdev@oraapps]$ sh $AD_TOP/bin/adadmin
Make the maintenance mode.
[applsdev@oraapps]$ cd /home/applsdev
[applsdev@oraapps]$ chmod -R 777 6365595
[applsdev@oraapps]$ cd 6365595/
[applsdev@oraapps 6365595]$ ls
ad b6365595.ldt f6365595.ldt marker1.txt README.html README.txt u6365595.drv
[applsdev@oraapps 6365595]$ adpatch

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications AutoPatch

Version 11.5.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.

Your default directory is '/oracle/PROD1/prod1appl'.
Is this the correct APPL_TOP [Yes] ?

AutoPatch records your AutoPatch session in a text file
you specify. Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adpatch.log] : 6365595.log

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :

Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [PROD1] : PROD1 *

NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.

Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *

Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *

Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *

Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *

Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [dev144] : dev144 *

You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'PROD1'
using ORACLE executables in '/oracle/PROD1/prod1ora/8.0.6'.

Is this the correct database [Yes] ?

AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema: manager

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

AutoPatch is verifying your username/password.
The status of various features in this run of AutoPatch is:

<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y

Identifier for the current session is 1756

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:

Code Language Status
---- --------------------------------------- ---------
US American English Base

Your base language will be AMERICAN.

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...

Saving product information.

AD code level : [11i.AD.I.2]

Trying to obtain a lock...

Attempting to instantiate the current-view snapshot...

Was already instantiated. So no instantiation done this time.

**************** S T A R T O F U P L O A D ****************

Start date: Thu Feb 23 2012 14:32:06

0 "left over" javaupdates.txt files uploaded to DB: Thu Feb 23 2012 14:32:06

0 patches uploaded from the ADPSV format patch history files: Thu Feb 23 2012 14:32:06

Uploading information about files copied during the previous runs ...

0 "left over" filescopied_<session_id>.txt files uploaded to DB: Thu Feb 23 2012 14:32:06

****************** E N D O F U P L O A D ******************

End date: Thu Feb 23 2012 14:32:06

Enter the directory where your Oracle Applications patch has been unloaded

The default directory is [/home/oracle/6365595] :

Please enter the name of your AutoPatch driver file : u6365595.drv

Getting Oracle Applications Release...

Current installed release is 11.5.10.2

Reading patch driver file...

Parsing and loading patch driver file...
154 lines processed.

Not checking patch integrity as integrity checking flag is turned off.

Successfully read patch driver file.

Determining target release...

Current target release is 11.5.10.2

Determining which bug fixes to apply...

Done determining which bug fixes to apply.

Log and Info File sync point:
Thu Feb 23 2012 14:32:11

Turning off actions that reference unrecognized products.

Log and Info File sync point:
Thu Feb 23 2012 14:32:11

End of unrecognized products checking.

AutoPatch will run in serial mode.

Did not need to apply new applterr.txt.

Applying new applprod.txt (if any)...

Did not need to apply new applprod.txt.

Performing version checking for driver files...

Log and Info File sync point:
Thu Feb 23 2012 14:32:11
AutoPatch found some files which it will not apply.
These files are listed in the AutoPatch informational message file.

Copying driver files into installation area...

No driver files were selected for copying.

Skipping...
ForceCopy driver files into installation area for Specified driver
since no such action is present for this driver file

Screening out files not valid for this installation...

Determining valid on-site files...

Skipping...
Extract object modules from libraries for Specified driver
since no such action is present for this driver file

Performing version checking...

Log and Info File sync point:
Thu Feb 23 2012 14:32:17
AutoPatch found some files which it will not apply.
These files are listed in the AutoPatch informational message file.

Skipping...
Determine directories to create for Specified driver
since no such action is present for this driver file

Skipping...
Determine executables to link for Specified driver
since no such action is present for this driver file

Skipping...
Determine forms to generate for Specified driver
since no such action is present for this driver file

Skipping...
Determine Oracle Reports libraries to generate for Specified driver
since no such action is present for this driver file

Skipping...
Determine reports to generate for Specified driver
since no such action is present for this driver file

Skipping...
Determine if need to generate message files for Specified driver
since no such action is present for this driver file

Looking for active bug fixes with no active actions...

Reading customized files list (if any)...

This patch replaces the following customized files:

No customized files are replaced by this patch.
Copying files into installation area...

**********************************************************
You are running admvcode

Header information is:
$Header: aiopatch.lc 115.44 2004/07/07 09:05:05 cbhati ship $

Start of admvcode session
Date/Time is Thu Feb 23 2012 14:32:17

Filelist file is: /oracle/PROD1/prod1appl/admin/PROD1/out/copymast.txt
Patch Character Set is: us7ascii
On-site Character Set is: US7ASCII

Log and Info File sync point:
Thu Feb 23 2012 14:32:17

Information about files copied to the APPL_TOP would be written to the
informational message file.

No character set conversion is required.

Copying files to APPL_TOP...

0 directories created.
1 files copied without character set conversion.
0 files copied with successful character set conversion.

1 files copied successfully.
0 files had fatal errors.

admvcode is exiting with status 0

End of admvcode session
Date/time is Thu Feb 23 2012 14:32:17
**********************************************************

Done copying files into installation area.

Skipping...
ForceCopy files into installation area for Specified driver
since no such action is present for this driver file

Skipping...
Archive object modules into product libraries for Specified driver
since no such action is present for this driver file

Skipping...
Create Directories for Specified driver
since no such action is present for this driver file

Skipping...
Relink for Specified driver
since no such action is present for this driver file

Performing second half of mirrored copies...

No mirrored copies were executed in this patch.

Updating Oracle Applications Java files if necessary...

No Oracle Applications Java files required updates.

Checking to see if any files possibly included in the product JAR files
were copied by this patch...

No files possibly included in the product JAR files
were copied by this patch.

Skipping ...
Running AutoConfig to instantiate templates which affect
the generation of JAR files since none of these templates
were patched during this run of adpatch.

No product JAR files need to be re-generated.

Checking to see if adjborg.txt or any files included in
adjborg.txt were copied by this patch...

Neither adjborg.txt nor any file included in
adjborg.txt was copied by this patch.

Checking to see if adjborg2.txt or any files included in
adjborg2.txt were copied by this patch...

Neither adjborg2.txt nor any file included in
adjborg2.txt was copied by this patch.

Compiling JSP files...

Not compiling JSPs: no JSPs in patch.

No JSP files were compiled.

Skipping...
Run SQL scripts and EXEC commands for Specified driver
since no such action is present for this driver file

Attempting to maintain MRC...

No action necessary for MRC.

Skipping...
Compile invalid objects for Specified driver
since no such action is present for this driver file

Skipping...
Generate forms library files for Specified driver
since no such action is present for this driver file

Skipping...
Generate forms menu files for Specified driver
since no such action is present for this driver file

Skipping...
Generate forms for Specified driver
since no such action is present for this driver file

Skipping...
Generate reports libraries for Specified driver
since no such action is present for this driver file

Skipping...
Generate reports for Specified driver
since no such action is present for this driver file

Skipping...
Generate graphics libraries for Specified driver
since no such action is present for this driver file

Skipping...
Generate graphics for Specified driver
since no such action is present for this driver file

Skipping...
Generate Messages for Specified driver
since no such action is present for this driver file

Skipping...
Generate Workflow resource files for Specified driver
since no such action is present for this driver file

Skipping ...
Running AutoConfig since none of its templates were
patched during this run of adpatch.

Saving Patch History information to Database...

Trying to obtain a lock...

> Inserted 1 patch history records (total).

Gathering Statistics for AD_PATCH_HIST_TEMP

Done Gathering Statistics for AD_PATCH_HIST_TEMP

>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 52 action history records for this bug (total).

Gathering Statistics for AD_PATCH_HIST_TEMP

Done Gathering Statistics for AD_PATCH_HIST_TEMP

>>> Inserted 9 bug history records for this patch (total).
>>>>> Inserted 52 action history records for this bug (total).

Updating the current-view snapshot...

Done saving Patch History information.

About to do IREP processing...

Attempting to process IREP files ...

The package FND_ADPATCH does not exist, continuing...

Done IREP processing.

Copying applprod.tmp to applprod.txt (if needed)...

Did not need to copy applprod.tmp to applprod.txt.

Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...

Did not need to copy admin/PROD1/applterr.txt to admin/applterr.txt.

There is no timing information available for the current session.

AutoPatch is complete.

AutoPatch may have written informational messages to the file
/oracle/PROD1/prod1appl/admin/PROD1/log/6365595.lgi

Errors and warnings are listed in the log file
/oracle/PROD1/prod1appl/admin/PROD1/log/6365595.log

and in other log files in the same directory.

[applsdev@oraapps]$ cd $COMMON_TOP/admin/scripts/sdev_oraapps
[applsdev@oraapps]$ ./adautocfg.sh
Enter the APPS user password:
AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using APPL_TOP location : /oracle/PROD1/prod1appl
Classpath : /oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/oracle/PROD1/prod1comn/java/appsborg2.zip:/oracle/PROD1/prod1comn/java

Using Context file : /oracle/PROD1/prod1appl/admin/PROD1_dev144.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring ABM_TOP.......COMPLETED
Configuring ECX_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring GL_TOP........COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring XNC_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring PA_TOP........COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring IMT_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
The log file for this session is located at: /oracle/PROD1/prod1appl/admin/PROD1_dev144/log/02231433/adconfig.log

REF : http://muthuappsdba.blogspot.in/2012/02/touch-error-while-loading-shared.html

DISABLE MAINTENANCE MODE USING ADADMIN

************************************************************************************************************************

ISSUE 4:

[applsdev@oraapps sdev_oraapps]$./adstrtal.sh apps/apps

You are running adstrtal.sh version 115.16

Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adapcctl.sh start
script returned:
****************************************************

adapcctl.sh version 115.47

Starting Apache Web Server Listener (dedicated HTTP) ...
Starting Apache Web Server Listener (dedicated PLSQL) ...

adapcctl.sh: exiting with status 3

.end std out.

.end err out.

****************************************************

Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version

Checking for FNDFS executable.
Starting listener process APPS_sdev.

adalnctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 115.24

Starting concurrent manager for sdev ...
Starting sdev_0508@sdev Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfrmctl.sh start
script returned:
****************************************************

You are running adfrmctl.sh version 115.37

Starting forms server for sdev on port 9051.

adfrmctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adrepctl.sh start
script returned:
****************************************************

You are running adrepctl.sh version 115.31

starting Reports Server for sdev on port 7051.

adrepctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfmcctl.sh start
script returned:
****************************************************

You are running adfmcctl.sh version 115.19

Starting forms load balancing client for sdev.

adfmcctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/adfmsctl.sh start
script returned:
****************************************************

You are running adfmsctl.sh version 115.15

starting forms metrics server for sdev.

adfmsctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Executing service control script:
/sdev/p01/oracle/pixcomn/admin/scripts/sdev_oraapps/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 115.16

Validating Fulfillment patch level via /sdev/p01/oracle/pixcomn/java
Fulfillment patch level validated.
Starting Fulfillment Server for sdev on port 9351 ...

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

Check logfile /sdev/p01/oracle/pixcomn/admin/log/sdev_oraapps/05081532.log for details

Exiting with status 1

solution:

Download and apply the OS library patch 6078836

root@oraapps # ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3

**********************************************************
END
**********************************************************

For Oracle Linux 5 and Red Hat Enterprise Linux 5 only :

# ln -s /usr/bin/ld215 /usr/bin/ld

Download and apply the OS library patch 6078836 from My Oracle Support and create the following symbolic link:
# ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3

But i resolved the issue by copying the libdb.so.3 file from working server instance to the required server.

FINALLY I CLONED AN 11I INSTANCE SUCCESSFULLY.

********************************************************************************************************************

ANOTHER ONE ISSUE 1:

applfdev@oraapps # perl adcfgclone.pl appsTier /fdev/p01/oracle/pixappl/admin/fdev_oraapps.xml

Cannot proceed with ApplyApplTop - the paths/ports in the context file are not valid.
RC-20403: The following port numbers are busy - please make sure the ports are available and try again.
Raised by oracle.apps.ad.clone.ApplyAppsTechStack
s_webssl_port : 443
--------------------------------------

StackTrace:
java.lang.Exception: Cannot proceed with ApplyAppsTechStack - the paths/ports in the context file are not valid.
at oracle.apps.ad.clone.ApplyAppsTechStack.validateContext(ApplyAppsTechStack.java:428)

NOTHING TO WORRY

SOLUTION

applfdev@oraapps # perl adcfgclone.pl appsTier

REF : https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocID=390901.1&from=BOOKMARK&bmDocDsrc=KB&viewingMode=1143))
ID : 390901.1

*********************************************************************************************************************

ISSUE 2 :

Autoconfig exiting status with 1

When checking logfile

"Thread: Error:ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated"

SOLUTION :

applfdev@oraapps # sqlplus apps/apps
applfdev@oraapps # select APPL_TOP_ID, NAME from ad_appl_tops;

APPL_TOP_ID NAME
----------- --------------------------------------------------
2069 *PRESEEDED*
2072 oraapps
2075 ebs
2078 ebs

1)What to do next, how to take backup of ad_timestamps, ad_appl_tops?
2)How to remove the rows which correspond to current node (on which the script is failing)
esp search for these rows in AD_TIMESTAMPS(ID 727990.1)?

1. create table ad_appl_tops_bak as select * from ad_appl_tops;
create table ad_timestamps_bak as select * from ad_timestamps;
2. delete ad_appl_tops where APPLICATIONS_SYSTEM_NAME='rdev';
3. commit;

Now autoconfig success and instance up.
ID 727990.1
REF :

https://support.oracle.com/CSP/ui/flash.html#tab=Dashboard(page=Dashboard&id=h23bc530()),(page=KBNavigator&id=h23bfsdt(searchControl=1146&&&searchMode=1145&viewingMode=1143))

https://forums.oracle.com/forums/thread.jspa?threadID=1049923

*********************************************************************************************************************

11I APPLICATION ISSUE :

ISSUE :
While giving concurrent manager request through forms it show the following error message
" concurrent phase 'completed,error' and also it denotes previous server url in forms.
When we click 'view log' in application it shows the following error message.

+---------------------------------------------------------------------------+

Application Object Library: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FNDSCARU module: Active Responsibilities
+---------------------------------------------------------------------------+

Current system time is 14-MAY-2012 17:07:22

+---------------------------------------------------------------------------+

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

APPLLCSP Environment Variable set to :

XML_REPORTS_XENVIRONMENT is :
/mdev/p01/oracle/pixora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

XENVIRONMENT is set to: /mdev/p01/oracle/pixora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

Spawned Process 21853
ar60run: relocation error: /mdev/p01/oracle/pixora/8.0.6/network/jre11/lib/i686/native_threads/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

Program exited with status 127
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 2908360.

Review your concurrent request log and/or report output file for more detailed information.

+---------------------------------------------------------------------------+
Executing request completion options...

Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed

SOLUTION :

RPM PACKAGE MISSING

root@server2 # rpm -ivh compat-libcwait-2.1-1.i386.rpm

ISSUE SOLVED............................

REF : https://forums.oracle.com/forums/thread.jspa?threadID=2192653

***************************************************************************************************************************
ANOTHER ISSUE:

-------------------ADX Database Utility Finished---------------

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: Control file creation failed
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:658)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)

controlfile created.

SOLUTION :

SQL> connect / as sysdba

SQL> shutdown immediate

SQL> startup mount

SQL> recover database using backup controlfile until cancel;

-- type CANCEL

SQL> alter database open resetlogs;

startup listener using script.

ISSUE SOLVED.....................................................................

********************************************************************************************************************************
ANOTHER ISSUE :

Autoconfig exiting status with 99

While checking logfile it shows as follows,

*******FATAL ERROR*******
PROGRAM : (txkGenExtSecConf.pl)
TIME : Wed Oct 14 22:41:34 2009
FUNCTION: TXK::IO::chmod [ Level 3 ]
MESSAGES:
error = Unable to chmod file - mode 511
errorno = Operation not permitted

SOLUTION

This error came in application tier. So i gave 777 permission to application files and rerun autoconfig

Now issue SOLVED......................................................................

*******************************************************************************************************************

ANOTHER ISSUE :

Autoconfig exiting status with 1
failed adadmprf.sh

while checking logfile it shows as follows,

Unique constraint error (00001) is OK if key already exists
Application server ID already exists for this host

While running adadmprf.sh it shows

ERROR:
ORA-12154: TNS:could not resolve service name

SOLUTION :

1) Login to sqlplus as user APPS

2) EXEC FND_CONC_CLONE.SETUP_CLEAN;

3) Repopulate FND_NODES by running Autoconfig on all middle tier nodes

4) SQL> SELECT table_name, column_name FROM all_tab_columns WHERE column_name LIKE 'APPLICATION%SYSTEM%NAME%';

5) SQL>create table FND_PRODUCT_GROUPS_BAK as select * from FND_PRODUCT_GROUPS;

6) SQL> update FND_PRODUCT_GROUPS set APPLICATIONS_SYSTEM_NAME = â€˜<NEW DATABASE NAME>â€™ ;

7) COMMIT;

8) RUN AUTOCONFIG IN MIDDLE TIER

NOW ISSUE SOLVED...................

Ref : http://onlineappsdba.com/index.php/2008/05/13/cloning-oam-system-name-pointing-to-source-instance/

*********************************************************************************************************************
ISSUE:

While applying patch it shows following error message.

Trying to obtain a lock...

Attempting to instantiate the current-view snapshot...
ORA-01403: no data found
ORA-06512: at "APPS.AD_FILE_SYS_SNAPSHOTS_PKG", line 2472
ORA-06512: at line 2

AutoPatch error:
Error while executing statement (curr-vw inst)

Error calling adusnapInstCurrVwSnapshot(ebs,11.5.10.2).
Error calling adphistLoadPtchHistFromFStoDB2

Updating the current-view snapshot...
ORA-01403: no data found
ORA-06512: at "APPS.AD_FILE_SYS_SNAPSHOTS_PKG", line 2095
ORA-06512: at line 2

AutoPatch error:
Error while executing statement (curr-vw updt)

SOLUTION :

SQL> select APPL_TOP_ID, NAME,APPLICATIONS_SYSTEM_NAME from ad_appl_tops;

APPL_TOP_ID NAME
----------- --------------------------------------------------
APPLICATIONS_SYSTEM_NAME
------------------------------
2069 *PRESEEDED*
*PRESEEDED*

2072 ebs
udev

SQL> select APPL_TOP_ID, NAME,APPLICATIONS_SYSTEM_NAME from ad_appl_tops_bak;

APPL_TOP_ID NAME
----------- --------------------------------------------------
APPLICATIONS_SYSTEM_NAME
------------------------------
2071 GLOBAL
hdev

2069 *PRESEEDED*
*PRESEEDED*

2070 ebs
hdev

SQL> update ad_appl_tops set APPL_TOP_ID='2070' where APPL_TOP_ID='2072';

-----> here 2070 is source id and 2072 is target id.

1 row updated.

SQL> commit;

Run Autoconfig and check the patching it solved........

Ref : http://oracleappstechnology.blogspot.in/2009/02/ora-01403-ora-06512-at.html

*******************************************************************************************************************************************************

Issue :
--------

While Running adcfgclone.pl on dbTier it shows following error message,

ora-27101 shared memory realm does not exist
linux error 2 no such file or directory
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Solution :
----------

Run autoconfig on appstier
Run $AD_TOP/bin/admkappsutil.pl and copy $INST_TOP/admin/out/appsutil.zip & unzip it to <RDBMS ORACLE_HOME>
Run $ORACLE_HOME/appsutil/bin/adbldxml.pl appsuser=apps appspasswd=apps
Run autoconfig on dbTier -> $ORACLE_HOME/appsutil/bin/adconfig.sh
Run adpreclone on dbTier
Run adpreclone on appsTier
Stop DB and its listener processes
Shutdown the Database with (Normal, Immediate ) Mode
Bring down the application services
Crosscheck with alert log whether DB has been shutdown completely
Run the following OS command to confirm/crosscheck that no DB process running , if any DB processes running , terminate them manually
ps -ef | grep pmon
Copy all the datafiles from Source to Target
Copy application file system to target.

Run the clone configuration command:
cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
perl adcfgclone.pl dbTier

Run the clone configuration command:
cd <COMMON_TOP>/clone/bin
perl adcfgclone.pl appsTier

**********************************************************************************************************************************************************************************************************