CLONING_DETAILS
We prepare the Source System for Database Tier and Application Tier and then copy both Database Tier and Application Tier nodes from the Source System to Target System. So, lastly we configure the Target System for both Database Tier and Application Tier. So the process flow is just like the old versions..
In the application tier cloning process,we clone the EBS's Run edition Filesystem to the Target, and then clone the copied target file system again to create the Patch Edition Filesystem in the Target. So we dont touch the Patch Edition File System of the source environment during our Clone process.
1)
So we start by preparing our Source system.
1a)
For preparing our application tier, we basically run adpreclone.pl from the Run file system.
Adpreclone creates compressed archives of Oracle Fusion Middleware components as follows:
A compressed archive of the:
1. Oracle WebLogic Server home,
2. Oracle Web Tier Utilities home,
3. Oracle Common Utilities home and the
4. Oracle E-Business Suite home:<COMMON_TOP>/clone/FMW/FMW_Home.jar
5. A compressed archive of the Oracle E-Business Suite Weblogic domain:<COMMON_TOP>/clone/FMW/WLS/EBSdomain.jar
6. The Oracle E-Business Suite Weblogic domain's configuration template:<COMMON_TOP>/clone/FMW/WLS/plan/moveplan.xml
7. A compressed archive of the Oracle Web Tier/Oracle HTTP Server configuration instance:<COMMON_TOP>/clone/FMW/OHS/ohsarchive.jar
8. The Oracle HTTP Server configuration instance's configuration template:<COMMON_TOP>/clone/FMW/OHS/moveplan.xml
So we run adpreclone.pl as follows:
Login as application owner (applmgr)
Source the run edition environment
$ cd <INST_TOP>/admin/scripts
$ perl adpreclone.pl appsTier
1b)
For preparing our database tier, we basically run adpreclone.pl from the database node using database software owner OS account as follows:
$ cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>
$ perl adpreclone.pl dbTier
It will create following directories in the $ORACLE_HOME/appsutil/clone "Jlib", "db" & "data" where "Jlib" relates to libraries "db" will contain the techstack information, "data" will contain the information related to datafiles required for cloning.
Creates driver files at $ORACLE_HOME/appsutil/driver/instconf.drv
Converts inventory from binary to xml, the xml file is located at $ORACLE_HOME/appsutil/clone/context/db/Sid_context.xml
Prepare database for cloning:
This includes creating database control file script and datafile location information file at
$ORACLE_HOME/appsutil/template/
"adcrdbclone.sql" & "dbfinfo.lst"
Generates database creation driver file at ORACLE_HOME/appsutil/clone/data/driverdata.drv
Copy JDBC Libraries at ORACLE_HOME/appsutil/clone/jlib/classes12.jar and appsutil
2)
After we complete running adpreclone.pl successfully, we copy our source environment to the target.. Note that we clone our database and we copy the necessary application tier directories.
2a)
For copying the database, we can use scp..
So, We can basically shutdown our source environment and use scp to copy our database files to the target system's server.
If our database is in ASM, we can use rman duplicate to duplicate our source db to the target server.. (we can duplicate it into a ASM running on the target server , or we can duplicate our source db into a cooked filesystem on the target server).
NOTE: We can duplicate our database when it is running..
Anyways, if we use offline copy, we can startup our source database and application services, right after our copy command, which is used for copy the database files from source to target, is complete.
Also in this step, we copy our source system oracle home to the target system..
NOTE: If our target system's database Home will be different than our source system's database Home, we may use relink all command to relink the binaries.
2b)
For copying the application tier:
We login to the source application environment using application owner and source the Run filesystem..
So after sourcing the run filesystem we identify the following directories:
<APPL_TOP>
<COMMON_TOP>
<OracleAS Tools 10.1.2 ORACLE_HOME>
Then we copy them from source to target..
NOTE: In 12.2 we have a dual file system. So we have fs1 and fs2. So we copy APPL_TOP,COMMON_TOP and 10.1.2 ORACLE_HOME from the run filesystem of the Source environment to the target.. So we need to maintain these dual directory structure in target system. I mean we need to have directories named fs1 and fs2, accordingly.
Also, In the target ,the copied directories will belong to our run filesystem ..
For example: If our Run filesystem is ; /u01/erman/fs2 ->
we need to copy $APPL_TOP, which is in /apps/fs2/EBSapps/appl to the target servers as /ANY_NAMES_YOU_WANT/fs2/EBSapps/appl
3)
Once we copy all the necessary application files and copy/duplicate our database, we countinue with the configuration of the target environment..
Note that following commands should be run with the related OS accounts.. DB owner for db configuration, Application owner for the appsTier configuration.. Also we need to ensure that, all the directory permissions are set properly before executing the configuration scripts..
3a)
We first configure our database tier using adcfgclone dbTier:
$ cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
$ perl adcfgclone.pl dbTier
4a)
Then we configure our application tier using adcfgclone appsTier:
$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier
NOTE: When the script asks for "Target System Base Directory", we enter the location of the base directory that we will use in the target system.
For example: /ANY_NAMES_YOU_WANT
When the adcfgclone appsTier is completed successfully, we continue by executing adpreclone.pl appsTier on the target system. This step is necessary, because we will clone our target run filesystem in order to have a patch filesystem, in the next steps..
$ cd <COMMON_TOP>/clone/bin
$ perl adpreclone.pl appsTier.
So after our preclone is finished, we are ready to copy our target Run edition filesystem to the patch edition.
We use cp -RH to accomplish that..
For example: Suppose our run filesystem in the target is /u01/erman/fs1
$ cp -RH /u01/erman/fs1 /u01/erman/fs2
Note that:
-RH is needed for keeping the softlinks and copying the directory structure recursively...
-H follow command-line symbolic links in SOURCE
-R, -r, --recursiven copy directories recursively.
After copying our run filesytem to patch filesystem in the target, we execute adcfgclone.pl once again, but this time in the Patch Edition environment..
So source the patch edition environment in the target and run the following as Application Owner:
$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier
adcfgclone.pl will asks us to supply the associated Run Filesystem's Context File location:
We need to supply the location of the target system's Run Filesystem Context File Location(full path)..
For ex: /u01/erman/fs1 /inst/apps/PROD_atgserver/appl/admin/PROD_atgserver.xml.
Once, adcfgclone.pl is complete, Our clone work will be finished.
After this point we may continue with our post actions if needed..
CLONING_STEPS
We have following phases in the cloning process:
1. Running Pre-Clone on the Source Apps Tier
2. Running Pre-Clone on the Source DB Tier
3. Copying Application Tier from Source to Target
4. Copying RDBMS Oracle Home from the Source To Target
5. Backing up database online (with rman)
6. Copying source database backup from Source to Target
7. Configuring the ownership of the directories on the Target Servers
8. Configuring Oracle RDBMS on the Target Server
9. Duplicating/ Opening the cloned database on the Target Database Server
10. Running Post Clone in the Target Database Server
11. Running Post Clone in the Target Application Tier
12. Running Pre-Clone on the Target Apps Tier
13. Copying EBSpps directory from Run edition to patch edition (in this case fs2 to fs1) in the Target Application server
14. Running postclone on the Patch Edition of the Target Application server & fixing the errors
15. Starting our clone environment
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1. Running Pre-Clone on the Source Apps Tier:
SOURCE with applmgr user >
$ cd $ADMIN_SCRIPTS_HOME
$ perl 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.15
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
Checking the status of the Oracle WebLogic Administration Server....
Running perl /apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/apps/fs2/inst/apps/dberp_erpprod/appl/admin/dberp_erpprod.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /apps/fs2/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/apps/fs2/EBSapps/comn/util/jdk64 mode=stage stage=/apps/fs2/EBSapps/comn/clone component=appsTier method= appctx=/apps/fs2/inst/apps/dberp_erpprod/appl/admin/dberp_erpprod.xml showProgress
Setting the wls environment
Beginning application tier Stage - Wed Jul 2 10:18:32 2014
/apps/fs2/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /apps/fs2/FMW_Home/webtier/lib/xmlparserv2.jar:/apps/fs2/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/apps/fs2/EBSapps/comn/java/classes:/apps/fs2/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/apps/fs2/FMW_Home/webtier/oui/jlib/ewt3.jar:/apps/fs2/FMW_Home/webtier/oui/jlib/share.jar:/apps/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/apps/fs2/FMW_Home/webtier/jlib/ojmisc.jar:/apps/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/apps/fs2/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /apps/fs2/inst/apps/dberp_erpprod/appl/admin/dberp_erpprod.xml -stage /apps/fs2/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /apps/fs2/inst/apps/dberp_erpprod/admin/log/clone/StageAppsTier_07021018.log
/ 20% completed
Completed Stage...
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2. Running Pre-Clone on the Source DB Tier:
$ cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>
[oracle@erpproddb dberp_erpproddb]$ perl adpreclone.pl dbTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adpreclone Version 120.31.12020000.4
Enter the APPS User Password:
Running:
perl /oracle/product/11.2.0.3/db/appsutil/bin/adclone.pl java=/oracle/product/11.2.0.3/db/appsutil/jre mode=stage stage=/oracle/product/11.2.0.3/db/appsutil/clone component=dbTier method=CUSTOM dbctx=/oracle/product/11.2.0.3/db/appsutil/dberp_erpproddb.xml showProgress
Beginning database tier Stage - Wed Jul 2 10:40:30 2014
/oracle/product/11.2.0.3/db/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oracle/product/11.2.0.3/db/oui -classpath /oracle/product/11.2.0.3/db/lib/xmlparserv2.jar:/oracle/product/11.2.0.3/db/jdbc/lib/ojdbc6.jar:/oracle/product/11.2.0.3/db/appsutil/java:/oracle/product/11.2.0.3/db/oui/jlib/OraInstaller.jar:/oracle/product/11.2.0.3/db/oui/jlib/ewt3.jar:/oracle/product/11.2.0.3/db/oui/jlib/share.jar:/oracle/product/11.2.0.3/db/oui/jlib/srvm.jar:/oracle/product/11.2.0.3/db/jlib/ojmisc.jar oracle.apps.ad.clone.StageDBTier -e /oracle/product/11.2.0.3/db/appsutil/dberp_erpproddb.xml -stage /oracle/product/11.2.0.3/db/appsutil/clone -tmp /tmp -method CUSTOM -showProgress
APPS Password :
Log file located at /oracle/product/11.2.0.3/db/appsutil/log/dberp_erpproddb/StageDBTier_07021040.log
/ 50% completed
Completed Stage...
Wed Jul 2 10:40:47 2014
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3. Copying Application Tier from Source to Target:
connect to target application server with root user and copy the run edition filesystem from source to target.
TARGET> scp -r root@source:/u01/fs2 /u02
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4. Copying RDBMS Oracle Home from the Source To Target:
connect to target db server with root user and copy databsae oracle home from source to target.
TARGET> scp -r root@source:/u01/oracle/product /u02/oracle/
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5. Backing up to database online (with rman) :
Connect to source database using rman, and backup your database plus archive log in to the directory you want..
rman target /
backup device type disk format '/yedek/Bck_For_Clone/%d_full_%s_%p.bck' database plus archivelog;
piece handle=/yedek/Bck_For_Clone/DBERP_full_10_1.bck tag=TAG20140702T110301 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-JUL-14
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
6. Copying source database backup from Source to Target:
connect to target db server with root user and copy database backup that we created in the previous steps, from source to target.
SOURCE> scp -r root@target:/yedek/Bck_For_Clone /u01/backup_sil
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
7. Configuring the ownership of the directories on the Target Servers:
TARGET>
$ chown -R applmgr:dba /u01/fs2
$ chown -R oracle:dba /u01/oracle/
$ chown -R oracle:dba /u01/backup_sil/
Ensure oratab is writable by oracle (just in case)
Ex:
$ ls -al /etc/oratab, and oraInst.loc is readable
-rw-rw-r-- 1 oracle oinstall 779 Jul 1 14:31 /etc/oratab
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
8. Configuring Oracle RDBMS on the Target Server:
TARGET>
If your source database filesystem / paths are the same with your source filesystem, just ;
$ su - oracle
$ cd /u01/oracle/product/11.2.0.3/db
$ echo ". `pwd`/dberp_erpproddb.env " >> /home/oracle/.bash_profile
exit
$ su - oracle
$ cd $ORACLE_HOME/bin
./relink all
Check the relink.log for the errors. Ensure there are no errors encountered during relink.
/u01/oracle/product/11.2.0.3/db/install/relink.log
If your source database filesystem / paths are the different than your source filesystem,
set your db environment and run relink all after that.
$ su - oracle
$ export ORACLE_SID=PREPROD
$ export PATH=$ORACLE_HOME/bin:$PATH
$ cd $ORACLE_HOME
$ export ORACLE_HOME=/u01/oracle/product/11.2.0.3/db
./relink all
Check the relink.log for the errors. Ensure there are no errors encountered during relink.
/u01/oracle/product/11.2.0.3/db/install/relink.log
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
9. Duplicating/ Opening the cloned database on the Target Database Server:
Connect to target, modify your pfile according to your needs, create an spfile and startup nomount your database with the new name on the target server.
Also set your db_file_name_convert, log_file_name_convert parameters before duplicating the db.
db_file_name_convert=(+DATA,+DATAERMAN)
log_file_name_convert=(+DATA,+DATAERMAN)
SQL>startup nomount;
Connect to the auxilary and duplicate the database with the name by specifying the backup location which resides on your target server.
TARGET>
rman auxiliary /
RMAN>duplicate target database to "PREPROD" BACKUP LOCATION '/u01/backup_sil/Bck_For_Clone';
NOTE: In oracle 11g, the duplication from the Target Database to the Auxiliary Database can be done using RMAN without connecting to the Target database or to a Catalog Database. If you have your full backup and if it accessible from the target server, then connect to auxiliary only and duplicate your database.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
10. Running Post Clone in the Target Database Server:
$ cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
$ perl adcfgclone.pl dbTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.7.1202010.2
Enter the APPS password :
Running:
/u01/oracle/product/11.2.0.3/db/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/java:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/xmlparserv2.jar:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /u01/oracle/product/11.2.0.3/db/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_27846.lst -stage /u01/oracle/product/11.2.0.3/db/appsutil/clone 2> /tmp/adcfgclone_27846.err; echo $? > /tmp/adcfgclone_27846.res
Log file located at /u01/oracle/product/11.2.0.3/db/appsutil/clone/bin/CloneContext_0702143324.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [erppreprod] :
Target Instance is RAC (y/n) [n] :
Target System Database SID : PREPROD
Target System Base Directory : /u01/oracle/product
Target System utl_file_dir Directory List : /tmp
Number of DATA_TOP's on the Target System [4] : 1
Target System DATA_TOP Directory 1 : +DATAERP
Target System RDBMS ORACLE_HOME Directory [/u01/oracle/product/11.2.0] : /u01/oracle/product/11.2.0.3/db
Do you want to preserve the Display [null] (y/n) : n
Target System Display [erppreprod:0.0] :
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] : 1
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/oracle/product/11.2.0.3/db/appsutil/temp/portpool.lst
Complete port information available at /u01/oracle/product/11.2.0.3/db/appsutil/temp/portpool.lst
Creating the new Database Context file from :
/u01/oracle/product/11.2.0.3/db/appsutil/template/adxdbctx.tmp
The new database context file has been created :
/u01/oracle/product/11.2.0.3/db/appsutil/PREPROD_erppreprod.xml
Log file located at /u01/oracle/product/11.2.0.3/db/appsutil/clone/bin/CloneContext_0702143324.log
Check Clone Context logfile /u01/oracle/product/11.2.0.3/db/appsutil/clone/bin/CloneContext_0702143324.log for details.
Running Rapid Clone with command:
Running:
perl /u01/oracle/product/11.2.0.3/db/appsutil/clone/bin/adclone.pl java=/u01/oracle/product/11.2.0.3/db/appsutil/clone/bin/../jre mode=apply stage=/u01/oracle/product/11.2.0.3/db/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/u01/oracle/product/11.2.0.3/db/appsutil/PREPROD_erppreprod.xml showProgress contextValidated=true
Beginning database tier Apply - Wed Jul 2 14:34:43 2014
/u01/oracle/product/11.2.0.3/db/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/u01/oracle/product/11.2.0.3/db/oui -classpath /u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/xmlparserv2.jar:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/ojdbc6.jar:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/java:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/oui/ewt3.jar:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/oui/share.jar:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/oui/srvm.jar:/u01/oracle/product/11.2.0.3/db/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /u01/oracle/product/11.2.0.3/db/appsutil/PREPROD_erppreprod.xml -stage /u01/oracle/product/11.2.0.3/db/appsutil/clone -showProgress
APPS Password : Log file located at /u01/oracle/product/11.2.0.3/db/appsutil/log/PREPROD_erppreprod/ApplyDBTier_07021434.log
- 50% completed
Completed Apply...
Wed Jul 2 14:37:46 2014
Starting database listener for PREPROD:
Running:
/u01/oracle/product/11.2.0.3/db/appsutil/scripts/PREPROD_erppreprod/addlnctl.sh start PREPROD
Logfile: /u01/oracle/product/11.2.0.3/db/appsutil/log/PREPROD_erppreprod/addlnctl.txt
You are running addlnctl.sh version 120.4
Starting listener process PREPROD ...
Listener PREPROD has already been started.
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/oracle/product/11.2.0.3/db/appsutil/log/PREPROD_erppreprod/addlnctl.txt for more information ...
NOTE: After this point, our listener will be up & running , our db environment file will be created and fnd_nodes table will be cleared & the new db host will be added to that.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11.
$ lsnrctl status PREPROD
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 02-JUL-2014 14:42:18
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erppreprod)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias PREPROD
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 02-JUL-2014 14:36:44
Uptime 0 days 0 hr. 5 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0.3/db/network/admin/PREPROD_erppreprod/listener.ora
Listener Log File /u01/oracle/product/11.2.0.3/db/admin/PREPROD_erppreprod/diag/tnslsnr/erppreprod/preprod/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.erman.ermandom.com(PORT=1522)))
Services Summary...
Service "PREPROD" has 1 instance(s).
Instance "PREPROD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$ cd $ORACLE_HOME
$ ls -al |grep env
-rw-r--r-- 1 oracle oinstall 4268 Jul 2 14:37 PREPROD_erppreprod.env
. $ORACLE_HOME/PREPROD_erppreprod.env. ( you can source this environment in your .bash_profile)
sqlplus apps/apps;
SQL> select node_name,host from fnd_nodes;
NODE_NAME
------------------------------
HOST
--------------------------------------------------------------------------------
ERPPREPROD
erppreprod
Okay. At this point, we are done with the database, lets continue with the application configurations.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12. Running Post Clone in the Target Application Tier :
Before executing adcfgclone on AppsTier. Copy the application inventory directory from source to target, and make the necessary modifications in the /etc/oratab file to point to the oraInventory location residing on target server. Also configure the permission -> prevent null pointer exceptions during precheck phase of the post clone.
NOTE: You must only have appl_top,common_top and 10.1.2 oracle_home in the target server.
If you have copied FMW home too, then you will get FMW HOME found error in the beginning of post clone..
$ cd <COMMON_TOP>/clone/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.30
Enter the APPS password :
Running:
/u01/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs2/EBSapps/comn/clone/jlib/java:/u01/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password :
Running:
/u01/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs2/EBSapps/comn/clone/jlib/java:/u01/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs2/EBSapps/comn/clone/jlib/java:/u01/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource
Do you want to add a node (yes/no) [no] :
Running:
/u01/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/fs2/EBSapps/comn/clone/jlib/java:/u01/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar:/u01/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs2/EBSapps/comn/clone/jlib/java:/u01/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_12380.lst -stage /u01/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_12380.err; echo $? > /tmp/adcfgclone_12380.res
Log file located at /u01/fs2/EBSapps/comn/clone/bin/CloneContext_0702162307.log
Target System File Edition type [run] :
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [erppreprod] :
Target System Database SID : PREPROD
Target System Database Server Node [erppreprod] :
Target System Database Domain Name [erman.ermandom.com] :
Target System Base Directory : /u01
Target System Base Directory set to /u01
Target System Current File System Base set to /u01/fs2
Target System Other File System Base set to /u01/fs1
Target System Fusion Middleware Home set to /u01/fs2/FMW_Home
Target System Web Oracle Home set to /u01/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/fs2/EBSapps/comn
Target System Instance Home Directory [/u01] :
Target System Instance Top set to /u01/fs2/inst/apps/PREPROD_erppreprod
Do you want to preserve the Display [erpprod:0.0] (y/n) : n
Target System Display [erppreprod:0.0] :
Target System Root Service [enabled] :
Target System Web Administration [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [enabled] :
Do you want the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 1
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/fs2/inst/apps/PREPROD_erppreprod/admin/out/portpool.lst
Complete port information available at /u01/fs2/inst/apps/PREPROD_erppreprod/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /u01/oracle/product/11.2.0.3/db/appsutil/outbound/PREPROD_erppreprod
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/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/fs2/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml
Log file located at /u01/fs2/EBSapps/comn/clone/bin/CloneContext_0702162307.log
Check Clone Context logfile /u01/fs2/EBSapps/comn/clone/bin/CloneContext_0702162307.log for details.
Running Rapid Clone with command:
Running:
perl /u01/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/fs2/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml showProgress contextValidated=true
FMW Pre-requisite check log file location : /u01/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u01/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/fs2/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml -stage /u01/fs2/EBSapps/comn/clone -log /u01/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Wed Jul 2 16:23:45 2014
/u01/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/fs2/EBSapps/comn/clone/jlib/java:/u01/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/fs2/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml -stage /u01/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/fs2/inst/apps/PREPROD_erppreprod/admin/log/clone/ApplyAppsTier_07021623.log
\ 100% completed
Completed Apply...
Wed Jul 2 16:38:20 2014
Executing command: /u01/fs2/EBSapps/10.1.2/bin/sqlplus @/u01/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql
Do you want to startup the Application Services for PREPROD? (y/n) [n] : n
Services not started
Okay, after the post clone we have fs_ne directory in place, our environment selector file (EBSapps.env) is also created.
so we source the environment file ". /u01/EBSapps.env" and start our preclone process on the run edition filesystem of the target application server..
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
13. Running Pre-Clone on the Target Apps Tier:
TARGET> login with applmgr
$ . /u01/EBSapps.env run
$ cd $ADMIN_SCRIPTS_HOME
$ sh adadminsrvctl.sh start ( our weblogic admin server should be up before the execution of preclone script, preclone needs it..)
$ perl 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.15
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
Checking the status of the Oracle WebLogic Administration Server....
Running perl /u01/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/fs2/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /u01/fs2/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/fs2/EBSapps/comn/util/jdk64 mode=stage stage=/u01/fs2/EBSapps/comn/clone component=appsTier method= appctx=/u01/fs2/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml showProgress
Setting the wls environment
Beginning application tier Stage - Thu Jul 3 08:46:19 2014
/u01/fs2/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/fs2/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/fs2/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/fs2/EBSapps/comn/java/classes:/u01/fs2/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/fs2/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/fs2/FMW_Home/webtier/oui/jlib/share.jar:/u01/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/fs2/FMW_Home/webtier/jlib/ojmisc.jar:/u01/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/fs2/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/fs2/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml -stage /u01/fs2/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /u01/fs2/inst/apps/PREPROD_erppreprod/admin/log/clone/StageAppsTier_07030846.log
/ 20% completed
\ 20% completed
Completed Stage...
Thu Jul 3 09:11:40 2014
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
14. Copying EBSpps directory from Run edition to patch edition (in this case fs2 to fs1) in the Target Application server:
First we create the patch directory , in this case it is fs1
$ mkdir -p /u01/fs1
Then we copy the run edition's EBSApps directory keeping the softlinks ;
$ cp -RH /u01/fs2/EBSapps/ /u01/fs1/
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
15. Running postclone on the Patch Edition of the Target Application server:
NOTE: Unset your env.
$ cd /u01/fs1/EBSapps/comn/clone/bin (patch edition 's clone/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.30
Enter the APPS password :
Running:
/u01/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs1/EBSapps/comn/clone/jlib/java:/u01/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password :
Running:
/u01/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs1/EBSapps/comn/clone/jlib/java:/u01/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs1/EBSapps/comn/clone/jlib/java:/u01/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource
Do you want to add a node (yes/no) [no] :
Running:
/u01/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/fs1/EBSapps/comn/clone/jlib/java:/u01/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojdbc5.jar:/u01/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs1/EBSapps/comn/clone/jlib/java:/u01/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_5741.lst -stage /u01/fs1/EBSapps/comn/clone 2> /tmp/adcfgclone_5741.err; echo $? > /tmp/adcfgclone_5741.res
Log file located at /u01/fs1/EBSapps/comn/clone/bin/CloneContext_0703092807.log
Target System File Edition type [run] : patch
Enter the full path of Run File System Context file : /u01/fs2/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml
Provide the values required for creation of the new APPL_TOP Context file.
Target System Fusion Middleware Home set to /u01/fs1/FMW_Home
Target System Web Oracle Home set to /u01/fs1/FMW_Home/webtier
Target System Appl TOP set to /u01/fs1/EBSapps/appl
Target System COMMON TOP set to /u01/fs1/EBSapps/comn
Target System Instance Top set to /u01/fs1/inst/apps/PREPROD_erppreprod
Target System Port Pool [0-99] : 2
Checking the port pool 2
done: Port Pool 2 is free
Report file located at /u01/fs1/inst/apps/PREPROD_erppreprod/admin/out/portpool.lst
Complete port information available at /u01/fs1/inst/apps/PREPROD_erppreprod/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /u01/oracle/product/11.2.0.3/db/appsutil/outbound/PREPROD_erppreprod
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/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/fs1/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml
Log file located at /u01/fs1/EBSapps/comn/clone/bin/CloneContext_0703092807.log
Check Clone Context logfile /u01/fs1/EBSapps/comn/clone/bin/CloneContext_0703092807.log for details.
Running Rapid Clone with command:
Running:
perl /u01/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/fs1/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml showProgress contextValidated=true
FMW Pre-requisite check log file location : /u01/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u01/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/fs1/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml -stage /u01/fs1/EBSapps/comn/clone -log /u01/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Thu Jul 3 09:32:11 2014
/u01/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/fs1/EBSapps/comn/clone/jlib/java:/u01/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/fs1/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml -stage /u01/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/fs1/inst/apps/PREPROD_erppreprod/admin/log/clone/ApplyAppsTier_07030932.log
/ 100% completed
Completed Apply...
Thu Jul 3 09:46:32 2014
Skipping the starting of services
Enabling EBS_LOGON Trigger...
INFO : Rapid Clone completed successfully , but the AutoConfig run recorded some errors.
Please review the AutoConfig section in the logfile. and Re-Run the entire cloning cycle , after fixing the problem.
******************************** ERROR **************************************
Okay we completed the cloning but it seems that we have encountered a problem while running autoconfig..
Lets find that problem...
To find the cause of the error , we open the logfile of post clone, and search for autconfig related errors there..
vi /u01/fs1/inst/apps/PREPROD_erppreprod/admin/log/clone/ApplyAppsTier_07030932.log
Here, there is an important error in the 6th process of the Autoconfig..
AutoConfig Setup Phase
Running Setup Process 6 of 8 for AD_TOP
Executing script in InstantiateFile:
/u01/fs1/inst/apps/PREPROD_erppreprod/admin/install/afgcsreg.sh
script returned:
***********************************************************************************
afgcsreg.sh started at Thu Jul 3 09:38:46 EEST 2014
The environment settings are as follows ...
ORACLE_HOME : /u01/fs1/EBSapps/10.1.2
ORACLE_SID :
TWO_TASK : PREPROD_patch
PATH : /u01/fs_ne/EBSapps/appl/ad/bin:/u01/fs1/FMW_Home/modules/org.apache.ant_1.7.1/bin:/u01/fs1/inst/apps/PREPROD_erppreprod/admin/scripts:/u01/fs1/FMW_Home/webtier/perl/bin:/u01/fs1/EBSapps/10.1.2/bin:/u01/fs1/EBSapps/appl/fnd/12.0.0/bin:/u01/fs1/EBSapps/appl/ad/12.0.0/bin:/u01/fs1/EBSapps/comn/util/jdk32/jre/bin:/u01/fs1/EBSapps/comn/util/jdk32/bin::/u01/fs1/EBSapps/10.1.2/OPatch:/u01/fs1/EBSapps/10.1.2/bin:/usr/bin:/usr/sbin:/u01/fs1/EBSapps/comn/util/jdk32/jre/bin:/u01/fs1/EBSapps/comn/clone/bin/../jre/bin:/u01/fs1/EBSapps/comn/clone/bin/../jre/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/applmgr/bin Library Path : /u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/fs1/EBSapps/appl/cz/12.0.0/bin:/u01/fs1/EBSapps/10.1.2/lib32:/u01/fs1/EBSapps/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/server:/u01/fs1/EBSapps/10.1.2/jdk/jre/lib/i386/native_threads:/u01/fs1/EBSapps/appl/sht/12.0.0/lib
Executable : /u01/fs1/EBSapps/10.1.2/bin/sqlplus
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jul 3 09:38:47 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
after that, similar errors are coming like a rain :)
Uploading Metadata file /u01/fs1/EBSapps/appl/ad/12.0.0/admin/template/adctxinf.tmp
Metadata file /u01/fs1/EBSapps/appl/ad/12.0.0/admin/template/adctxinf.tmp upload failed.
Check log file created by FNDCPUCF program.
ERRORCODE = 1 ERRORCODE_END
.end std out.
APP-FND-01564: ORACLE error 12514 in AFPCOA
Cause: AFPCOA failed due to ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
The SQL statement being executed at the time of the error was: and was executed from the file .
APP-FND-01564: ORACLE error 12514 in AFPCOA
Cause: AFPCOA failed due to ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
**************************** ERROR **********************************************
So,
It is searching for the service name "PREPROD_patch" to connect to the db..
Lets check our db site, lets check our listener if it is listening for the "patching service"..
lsnrctl status PREPROD
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-JUL-2014 10:19:28
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erppreprod.erman.ermandom.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias PREPROD
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 02-JUL-2014 15:57:42
Uptime 0 days 18 hr. 21 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0.3/db/network/admin/PREPROD_erppreprod/listener.ora
Listener Log File /u01/oracle/product/11.2.0.3/db/admin/PREPROD_erppreprod/diag/tnslsnr/erppreprod/preprod/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreproderman.ermandom.com)(PORT=1522)))
Services Summary...
Service "PREPROD" has 1 instance(s).
Instance "PREPROD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Opps, it doesnt listens for "PREPROD_patch".
*************************** SOLUTION ********************************************
Lets make the listener to listen PREPROD_patch..
$ sqlplus "/as sysdba"
SQL> alter system set service_names='PREPROD','ebs_patch','PREPROD_patch' scope=memory;
System altered.
SQL> alter system set local_listener=PREPROD scope=memory;
System altered.
SQL> alter system register;
System altered.
lsnrctl status PREPROD
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-JUL-2014 10:30:25
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erppreprod.erman.ermandom.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias PREPROD
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 02-JUL-2014 15:57:42
Uptime 0 days 18 hr. 32 min. 43 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0.3/db/network/admin/PREPROD_erppreprod/listener.ora
Listener Log File /u01/oracle/product/11.2.0.3/db/admin/PREPROD_erppreprod/diag/tnslsnr/erppreprod/preprod/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erppreprod.erman.ermandom.com)(PORT=1522)))
Services Summary...
Service "PREPROD" has 2 instance(s).
Instance "PREPROD", status UNKNOWN, has 1 handler(s) for this service...
Instance "PREPROD", status READY, has 1 handler(s) for this service...
Service "PREPROD_patch" has 1 instance(s).
Instance "PREPROD", status READY, has 1 handler(s) for this service...
Service "ebs_patch" has 1 instance(s).
Instance "PREPROD", status READY, has 1 handler(s) for this service...
The command completed successfully
Okay, Now it is listening for PREPROD_patch..
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
So, lets execute our post clone process again.. (because it says: Re-Run the entire cloning cycle , after fixing the problem)
First clean what we have done before and recreate the fs1 directory
$ rm -fR fs1/
$ ls
backup_sil EBSapps.env fs2 fs_ne lost+found oracle
$ mkdir fs1
$ cp -RH fs2/EBSapps/ fs1/
Then, re-execute adcfgclone.pl appsTier from the patch edition filesystem.
/u01/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/fs1/EBSapps/comn/clone/jlib/java:/u01/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/fs1/inst/apps/PREPROD_erppreprod/appl/admin/PREPROD_erppreprod.xml -stage /u01/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/fs1/inst/apps/PREPROD_erppreprod/admin/log/clone/ApplyAppsTier_07031059.log
- 100% completed
Completed Apply...
Thu Jul 3 11:13:55 2014
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
Yes! This time ,it runs successfully...
Now we are ready to start our cloned evironment..
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
16. Starting our clone environment:
Lastly we source our run environment and start our application services on the cloned environment.
$ . /u01/EBSApps.env run
$ cd $ADMIN_SCRIPTS_HOME
$ sh adstrtal.sh apps/apps
####### END #########
No comments:
Post a Comment