How to Create the Shared APPL_TOP
First preclone your current env
copy source server to distination server
1Configure the Database System
Execute the following commands to configure the target system. You will be prompted for the target system specific values (SID, Paths, Ports, etc)
1.1. Configure the target system database server
Log on to the target system as the ORACLE user and type the following commands to configure and start the database:
$ cd / oracle/db/11.1.0/appsutil/clone/bin
$ perl adcfgclone.pl dbTier
Example :-
Variables extracted from pairsfile: /tmp/adpairsfile_18100.lst
****************************************************/n
s_dbuser = oraprod
s_dbgroup = dba
****************************************************
PROMPT :
Target System Hostname (virtual or normal) [our12-db]
ANSWER : our12db
Current host : our12-db
Target host : our12db
Inputs cannot be validated. Turing validation off.
PROMPT :
Target Instance is RAC (y/n) [n]
ANSWER : n
PROMPT :
Target System Database SID
ANSWER : OURPROD
PROMPT :
Target System Base Directory
ANSWER : /oracle
PROMPT :
Target System utl_file_dir Directory List
ANSWER : /usr/tmp
PROMPT :
Number of DATA_TOP's on the Target System [1]
ANSWER : 4
PROMPT :
Target System DATA_TOP Directory 1
ANSWER : 4
PROMPT :
Target System DATA_TOP Directory 1
ANSWER : /r01/oradata
PROMPT :
Target System DATA_TOP Directory 2
ANSWER : /r02/oradata
PROMPT :
Target System DATA_TOP Directory 3
ANSWER : /r03/oradata
PROMPT :
Target System DATA_TOP Directory 4
ANSWER : /r04/oradata
Creating /oracle/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.
PROMPT :
Target System RDBMS ORACLE_HOME Directory [/oracle/db/tech_st/11.1.0]
ANSWER : /oracle/db/tech_st/11.1.0
Creating /oracle/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.
PROMPT :
Do you want to preserve the Display [our12prod:0.0] (y/n) ?
ANSWER : n
PROMPT :
Target System Display [our12db:0.0]
ANSWER : y
PROMPT :
Do you want the the target system to have the same port values as the source system (y/n) [y] ?
ANSWER : n
Start the database server and the Net Listener
Log on to the target system as the ORACLE user and type the following commands to configure and start the database:
$ cd /oracle/db/11.1.0/appsutil/<context-name>
$ addlnctl.sh start OURPROD
$ addbctl.sh start
1.2: Create Applications Context File and Instance Home
The steps describe below should be use to create a new context file and a new Instance Home to associate the application middle tier node (in the our12-apps1.bilt.com) with the new database instance.
Oracle E-Business Suite Prod Server: our12-apps1.bilt.com
This server has a single-node installation of the Release 12 Vision database, and the Applications file system is installed in the following directories:
INSTANCE NAME: OURPROD
COMMON_TOP: /applprod/apps/apps_st/comn
APPL_TOP: /applprod/apps/apps_st/appl
OracleAS 10.1.2 ORACLE_HOME: /applprod/apps/tech_st/10.1.2
OracleAS 10.1.3 ORACLE_HOME: /applprod/apps/tech_st/10.1.3
INSTANCE HOME: /oracle/inst/apps/OURPROD_our12-apps1
Oracle E-Business Suite Prod Server-2: our12-apps2.bilt.com
To create a context file for the database instance running on our12-apps2.bilt.com, execute the following command on the Prod server our12-apps2.bilt.com.
$ perl $COMMON_TOP/clone/bin/adclonectx.pl \
contextfile=/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Enter the APPS password: APPS
Target hostname (virtual or normal) [test]:Our12-apps1
Do you want the inputs to be validated (y/n) [n] y
?:y
Target system database SID OURPROD
Target system database server node [our12-apps1] our12db
Target system base directory for source homes /applprod
Target system base directory for Instance Homes [/d1/R12/inst] /oracle/inst
Username for the applications file system owner [user1] oraapps
Group for the applications file system owner [dba] dba
Do you want to preserve the Display set to our12-apps1:0.0 (y/n) [y] ?:y
Do you want the the target system to have the same port values as the source system (y/n) [y] ?:n
Enter the port pool to be used for the target system node [0-99]:2
New context path and file name [OURPROD_our12-apps2.xml]: /oracle/inst/apps/OURPROD_our12-apps1/appl/admin/OURPROD_our12-apps1.xml
1.3: Review Oracle E-Business Suite Applications Context File for the New Instance
Verify the Context File Created for the New Instance
Check the new context file created by the adclonectx utility. Ensure that values for the AutoConfig variables shown in the table below are set correctly:
Variable Name Remarks
s_dbhost Ensure value of this variable is set to the hostname of the new database server.
s_dbport Ensure value of this variable is set to the TNS listener port on the new database server.
s_appl_config_home Ensure value of this variable is set to <instance_top>/appl, where <instance_top> is the top level directory created for the new instance.
s_adconfig_file Ensure value of this variable is set to <instance_top>/appl/admin/adconfig.txt, where <instance_top> is the top level directory created for the new instance.
s_adovars_file Ensure value of this variable is set to <instance_top>/appl/admin/admin/adovars.env, where <instance_top> is the top level directory created for the new instance.
s_appsora_file Ensure value of this variable is set to <instance_top>/appl/APPS<s_contextname>.env, where <instance_top> is the top level directory created for the new instance.
s_applsys_file Ensure value of this variable is set to <instance_top>/appl/<s_contextname>.env, where <instance_top> is the top level directory created for the new instance.
• Run AutoConfig to Configure the New Instance
As the apps user, log in to the node where the application tier is installed (test.us.oracle.com in the example), and execute the following command:
$ $AD_TOP/bin/adconfig.pl \
contextfile=/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Example Shared File System
The following is an example of mount points shared on each application tier node:
• COMMON_TOP: /applprod/apps/apps_st/comn
• APPL_TOP: /applprod/apps/apps_st/appl
• OracleAS 10.1.2 ORACLE_HOME: /applprod/apps/tech_st/10.1.2
• OracleAS 10.1.3 ORACLE_HOME: /applprod /apps/tech_st/10.1.3
In the figure shown below, entitled "Shared Application Tier File System", our12-apps1.bilt.com is the primary application tier node, and uses the file systems "/applprod/" The file system "/applprod" contains the Instance Home, and "/applprod" contains the APPL_TOP, COMMON_TOP, OracleAS 10.1.2 and 10.1.3 Oracle Home.
our12-apps2.bilt.com is the secondary application tier node, and the shared file system "/applprod" is also mounted on this node. The file systems "/oracle/inst/apps/<CONTEXT NAME for our12-apps2.bilt.com >" and "/oracle/inst/apps/<CONTEXT NAME for our12-apps1.bilt.com >"are only visible on the respective nodes.
Creating your Appltier
[oracle@our12-dev bin]$ perl adcfgclone.pl dbTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.1
Enter the APPS password :
Running:
/backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/java:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_32115.lst -stage /backup/PROD/db/tech_st/11.1.0/appsutil/clone 2> /tmp/adcfgclone_32115.err; echo $? > /tmp/adcfgclone_32115.res
Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0402075626.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [our12-dev] :
Target Instance is RAC (y/n) [n] :
Target System Database SID : PROD
Target System Base Directory : /backup/PROD
Target System utl_file_dir Directory List : /usr/tmp
Number of DATA_TOP's on the Target System [4] :
Target System DATA_TOP Directory 1 [/r03/oradata] : /oradata/PROD/r03/oradata
Target System DATA_TOP Directory 2 [/r02/oradata] : /backup/PROD/oradata
Target System DATA_TOP Directory 3 [/r04/oradata] : /oradata/PROD/r04/oradata
Target System DATA_TOP Directory 4 [/r01/oradata] : /oradata/PROD/r01/oradata
Target System RDBMS ORACLE_HOME Directory [/backup/PROD/db/tech_st/11.1.0] :
Do you want to preserve the Display [y] (y/n) ? : n
Target System Display [our12-dev:0.0] : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 75
Checking the port pool 75
done: Port Pool 75 is free
Report file located at /backup/PROD/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Complete port information available at /backup/PROD/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Creating the new Database Context file from :
/backup/PROD/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp
The new database context file has been created :
/backup/PROD/db/tech_st/11.1.0/appsutil/PROD_our12-dev.xml
Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneConte
Check Clone Context logfile /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/Cl
Running Rapid Clone with command:
perl /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/backup/P /11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/backup/PROD/db/te
Running:
perl /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/backup/P /11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/backup/PROD/db/te
APPS Password :
Beginning database tier Apply - Sat Apr 2 07:58:20 2011
/backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCON spath /backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/backup psutil/clone/jlib/java:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/Or ROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/backup/PROD/db/tech_st/ ib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /backup/PROD/db/tech_st/11.1 howProgress
APPS Password : Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/log/
- 15% completed
Completed Apply...
Sat Apr 2 08:03:06 2011
Starting database listener for PROD:
Running:
/backup/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_our12-dev/addlnctl.sh start PROD
You are running addlnctl.sh version 120.1.12010000.2
Logfile: /backup/PROD/db/tech_st/11.1.0/appsutil/log/PROD_our12-dev/addlnctl.txt
Starting listener process PROD ...
Listener PROD has already been started.
addlnctl.sh: exiting with status 0
[oracle@our12-dev bin]$cd /applprod/apps/apps_st/comn/
[oracle@our12-dev bin]$ perl adcfgclone.pl appsTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.1
Enter the APPS password :
Running:
/applprod/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /applprod/apps/apps_st/comn/clone/jlib/java:/applprod/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/applprod/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /applprod/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_5889.lst -stage /applprod/apps/apps_st/comn/clone 2> /tmp/adcfgclone_5889.err; echo $? > /tmp/adcfgclone_5889.res
Log file located at /applprod/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [our12-dev] :
Target System Database SID : PROD
Target System Database Server Node [our12-dev] :
Target System Base Directory : /applprod
Target System Tools ORACLE_HOME Directory [/applprod/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/applprod/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/applprod/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/applprod/apps/apps_st/comn] :
Target System Instance Home Directory [/applprod/inst] :
Target System Root Service [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 to preserve the Display [y] (y/n) ? : n
Target System Display [our12-dev:0.0] : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 75
Checking the port pool 75
done: Port Pool 75 is free
Report file located at /oracle/inst/apps/OURPROD_our12-apps1/admin/out/portpool.lst
Complete port information available at /oracle/inst/apps/OURPROD_our12-apps1/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /oracle/db/tech_st/11.1.0/appsutil/outbound/OURPROD_our12db
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 :
/applprod/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/oracle/inst/apps/OURPROD_our12-apps1/appl/admin/PROD_our12-dev.xml
Log file located at /applprod/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log
Check Clone Context logfile /applprod/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log for details.
Running Rapid Clone with command:
perl /applprod/apps/apps_st/comn/clone/bin/adclone.pl java=/applprod/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/applprod/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/applprod/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml showProgress contextValidated=true
Running:
perl /applprod/apps/apps_st/comn/clone/bin/adclone.pl java=/applprod/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/applprod/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/applprod/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml showProgress contextValidated=true
APPS Password :
Beginning application tier Apply - Sat Apr 2 08:13:37 2011
/applprod/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /applprod/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/applprod/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/applprod/apps/apps_st/comn/clone/jlib/java:/applprod/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/applprod/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/applprod/apps/apps_st/comn/clone/jlib/oui/share.jar:/applprod/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/applprod/apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /applprod/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml -stage /applprod/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /oracle/inst/apps/OURPROD_our12-apps1/admin/log/ApplyAppsTier_04020813.log
\ 89% completed
Completed Apply...
Sat Apr 2 08:20:10 2011
Starting application Services for PROD:
Running:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adstrtal.sh -nopromptmsg
You are running adstrtal.sh version 120.15
The logfile for this session is located at /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adstrtal.log
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adopmnctl.sh start
script returned:
****************************************************
You are running adopmnctl.sh version 120.6
Starting Oracle Process Manager (OPMN) ...
opmnctl: opmn started.
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adopmnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_PROD.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adalnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adapcctl.sh start
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adapcctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adoacorectl.sh start
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adoacorectl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adformsctl.sh start
script returned:
****************************************************
You are running adformsctl.sh version 120.16
Starting OPMN managed FORMS OC4J instance ...
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adformsctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adoafmctl.sh start
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Starting OPMN managed OAFM OC4J instance ...
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adoafmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.3
Starting concurrent manager for PROD ...
Starting PROD_0402@PROD Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adcmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/ieo/ieoicsm.sh start
script returned:
****************************************************
You are running ieoicsm.sh version 120.6
Starting Oracle ICSM server ...
ieoicsm.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Validating Fulfillment patch level via /applprod/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for PROD on port 9375 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adstrtal.log for more information ...
[oracle@our12-dev bin]$
Adding Addditional Node :-
[oraapps@our12-apps2 ~]$ ping our12db
PING our12db.bilt.com (10.2.0.183) 56(84) bytes of data.
64 bytes from our12db.bilt.com (10.2.0.183): icmp_seq=1 ttl=64 time=0.921 ms
64 bytes from our12db.bilt.com (10.2.0.183): icmp_seq=2 ttl=64 time=0.102 ms
--- our12db.bilt.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1000ms
rtt min/avg/max/mdev = 0.102/0.511/0.921/0.410 ms
[oraapps@our12-apps2 ~]$ clear
[oraapps@our12-apps2 bin]$ perl adclonectx.pl addnode \contextfile=/oracle/OURPROD_our12-apps1.xml
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/applprod/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /applprod/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/applprod/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/applprod/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /oracle/OURPROD_our12-apps1.xml -addnode
Enter the APPS password : apps
Log file located at /applprod/apps/apps_st/comn/clone/bin/CloneContext_1224105224.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [our12-apps2] :
It is recommended that your inputs are validated by the program.
However you might choose not to validate them under following circumstances:
-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and
you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.
Do you want the inputs to be validated (y/n) [n] ? : y
Target System Root Service [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 to preserve the Display [y] (y/n) ? : n
Target System Display [our12-apps2:0.0] : y
Database port is 1523
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 2
Checking the port pool 2
done: Port Pool 2 is free
Report file located at /oracle/inst/apps/OURPROD_our12-apps2/admin/out/portpool.lst
Complete port information available at /oracle/inst/apps/OURPROD_our12-apps2/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /oracle/db/tech_st/11.1.0/appsutil/outbound/OURPROD_our12db
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 :
/applprod/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Log file located at /applprod/apps/apps_st/comn/clone/bin/CloneContext_1224105224.log
contextfile=/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Check Clone Context logfile /applprod/apps/apps_st/comn/clone/bin/CloneContext_1224105224.log for details.
[oraapps@our12-apps2 bin]$ gedit /oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
[oraapps@our12-apps2 bin]$ perl adc
adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl
[oraapps@our12-apps2 bin]$ pwd
/applprod/apps/apps_st/comn/clone/bin
[oraapps@our12-apps2 bin]$ cd ../../
[oraapps@our12-apps2 comn]$ cd ../
[oraapps@our12-apps2 apps_st]$ cd appl/ad
ad/ admin/
[oraapps@our12-apps2 apps_st]$ cd appl/ad/12.0.0/bin/
[oraapps@our12-apps2 bin]$ perl adconfig.pl \contextfile=/oracle/inst/apps/OURPROD_our12-apps2/a
admin/ appl/
[oraapps@our12-apps2 bin]$ perl adconfig.pl \contextfile=/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Enter the APPS user password:
The log file for this session is located at: /oracle/inst/apps/OURPROD_our12-apps2/admin/log/12241057/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /oracle/inst/apps/OURPROD_our12-apps2
Classpath : /applprod/apps/apps_st/comn/java/lib/appsborg2.zip:/applprod/apps/apps_st/comn/java/classes
Using Context file : /oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.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........
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_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 IGS_TOP.......COMPLETED
Configuring IBY_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 XXSE_TOP.......COMPLETED
Configuring EAM_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.
[oraapps@our12-apps2 bin]$
First preclone your current env
copy source server to distination server
1Configure the Database System
Execute the following commands to configure the target system. You will be prompted for the target system specific values (SID, Paths, Ports, etc)
1.1. Configure the target system database server
Log on to the target system as the ORACLE user and type the following commands to configure and start the database:
$ cd / oracle/db/11.1.0/appsutil/clone/bin
$ perl adcfgclone.pl dbTier
Example :-
Variables extracted from pairsfile: /tmp/adpairsfile_18100.lst
****************************************************/n
s_dbuser = oraprod
s_dbgroup = dba
****************************************************
PROMPT :
Target System Hostname (virtual or normal) [our12-db]
ANSWER : our12db
Current host : our12-db
Target host : our12db
Inputs cannot be validated. Turing validation off.
PROMPT :
Target Instance is RAC (y/n) [n]
ANSWER : n
PROMPT :
Target System Database SID
ANSWER : OURPROD
PROMPT :
Target System Base Directory
ANSWER : /oracle
PROMPT :
Target System utl_file_dir Directory List
ANSWER : /usr/tmp
PROMPT :
Number of DATA_TOP's on the Target System [1]
ANSWER : 4
PROMPT :
Target System DATA_TOP Directory 1
ANSWER : 4
PROMPT :
Target System DATA_TOP Directory 1
ANSWER : /r01/oradata
PROMPT :
Target System DATA_TOP Directory 2
ANSWER : /r02/oradata
PROMPT :
Target System DATA_TOP Directory 3
ANSWER : /r03/oradata
PROMPT :
Target System DATA_TOP Directory 4
ANSWER : /r04/oradata
Creating /oracle/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.
PROMPT :
Target System RDBMS ORACLE_HOME Directory [/oracle/db/tech_st/11.1.0]
ANSWER : /oracle/db/tech_st/11.1.0
Creating /oracle/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.
PROMPT :
Do you want to preserve the Display [our12prod:0.0] (y/n) ?
ANSWER : n
PROMPT :
Target System Display [our12db:0.0]
ANSWER : y
PROMPT :
Do you want the the target system to have the same port values as the source system (y/n) [y] ?
ANSWER : n
Start the database server and the Net Listener
Log on to the target system as the ORACLE user and type the following commands to configure and start the database:
$ cd /oracle/db/11.1.0/appsutil/<context-name>
$ addlnctl.sh start OURPROD
$ addbctl.sh start
1.2: Create Applications Context File and Instance Home
The steps describe below should be use to create a new context file and a new Instance Home to associate the application middle tier node (in the our12-apps1.bilt.com) with the new database instance.
Oracle E-Business Suite Prod Server: our12-apps1.bilt.com
This server has a single-node installation of the Release 12 Vision database, and the Applications file system is installed in the following directories:
INSTANCE NAME: OURPROD
COMMON_TOP: /applprod/apps/apps_st/comn
APPL_TOP: /applprod/apps/apps_st/appl
OracleAS 10.1.2 ORACLE_HOME: /applprod/apps/tech_st/10.1.2
OracleAS 10.1.3 ORACLE_HOME: /applprod/apps/tech_st/10.1.3
INSTANCE HOME: /oracle/inst/apps/OURPROD_our12-apps1
Oracle E-Business Suite Prod Server-2: our12-apps2.bilt.com
To create a context file for the database instance running on our12-apps2.bilt.com, execute the following command on the Prod server our12-apps2.bilt.com.
$ perl $COMMON_TOP/clone/bin/adclonectx.pl \
contextfile=/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Enter the APPS password: APPS
Target hostname (virtual or normal) [test]:Our12-apps1
Do you want the inputs to be validated (y/n) [n] y
?:y
Target system database SID OURPROD
Target system database server node [our12-apps1] our12db
Target system base directory for source homes /applprod
Target system base directory for Instance Homes [/d1/R12/inst] /oracle/inst
Username for the applications file system owner [user1] oraapps
Group for the applications file system owner [dba] dba
Do you want to preserve the Display set to our12-apps1:0.0 (y/n) [y] ?:y
Do you want the the target system to have the same port values as the source system (y/n) [y] ?:n
Enter the port pool to be used for the target system node [0-99]:2
New context path and file name [OURPROD_our12-apps2.xml]: /oracle/inst/apps/OURPROD_our12-apps1/appl/admin/OURPROD_our12-apps1.xml
1.3: Review Oracle E-Business Suite Applications Context File for the New Instance
Verify the Context File Created for the New Instance
Check the new context file created by the adclonectx utility. Ensure that values for the AutoConfig variables shown in the table below are set correctly:
Variable Name Remarks
s_dbhost Ensure value of this variable is set to the hostname of the new database server.
s_dbport Ensure value of this variable is set to the TNS listener port on the new database server.
s_appl_config_home Ensure value of this variable is set to <instance_top>/appl, where <instance_top> is the top level directory created for the new instance.
s_adconfig_file Ensure value of this variable is set to <instance_top>/appl/admin/adconfig.txt, where <instance_top> is the top level directory created for the new instance.
s_adovars_file Ensure value of this variable is set to <instance_top>/appl/admin/admin/adovars.env, where <instance_top> is the top level directory created for the new instance.
s_appsora_file Ensure value of this variable is set to <instance_top>/appl/APPS<s_contextname>.env, where <instance_top> is the top level directory created for the new instance.
s_applsys_file Ensure value of this variable is set to <instance_top>/appl/<s_contextname>.env, where <instance_top> is the top level directory created for the new instance.
• Run AutoConfig to Configure the New Instance
As the apps user, log in to the node where the application tier is installed (test.us.oracle.com in the example), and execute the following command:
$ $AD_TOP/bin/adconfig.pl \
contextfile=/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Example Shared File System
The following is an example of mount points shared on each application tier node:
• COMMON_TOP: /applprod/apps/apps_st/comn
• APPL_TOP: /applprod/apps/apps_st/appl
• OracleAS 10.1.2 ORACLE_HOME: /applprod/apps/tech_st/10.1.2
• OracleAS 10.1.3 ORACLE_HOME: /applprod /apps/tech_st/10.1.3
In the figure shown below, entitled "Shared Application Tier File System", our12-apps1.bilt.com is the primary application tier node, and uses the file systems "/applprod/" The file system "/applprod" contains the Instance Home, and "/applprod" contains the APPL_TOP, COMMON_TOP, OracleAS 10.1.2 and 10.1.3 Oracle Home.
our12-apps2.bilt.com is the secondary application tier node, and the shared file system "/applprod" is also mounted on this node. The file systems "/oracle/inst/apps/<CONTEXT NAME for our12-apps2.bilt.com >" and "/oracle/inst/apps/<CONTEXT NAME for our12-apps1.bilt.com >"are only visible on the respective nodes.
Creating your Appltier
[oracle@our12-dev bin]$ perl adcfgclone.pl dbTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.1
Enter the APPS password :
Running:
/backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/java:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_32115.lst -stage /backup/PROD/db/tech_st/11.1.0/appsutil/clone 2> /tmp/adcfgclone_32115.err; echo $? > /tmp/adcfgclone_32115.res
Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0402075626.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [our12-dev] :
Target Instance is RAC (y/n) [n] :
Target System Database SID : PROD
Target System Base Directory : /backup/PROD
Target System utl_file_dir Directory List : /usr/tmp
Number of DATA_TOP's on the Target System [4] :
Target System DATA_TOP Directory 1 [/r03/oradata] : /oradata/PROD/r03/oradata
Target System DATA_TOP Directory 2 [/r02/oradata] : /backup/PROD/oradata
Target System DATA_TOP Directory 3 [/r04/oradata] : /oradata/PROD/r04/oradata
Target System DATA_TOP Directory 4 [/r01/oradata] : /oradata/PROD/r01/oradata
Target System RDBMS ORACLE_HOME Directory [/backup/PROD/db/tech_st/11.1.0] :
Do you want to preserve the Display [y] (y/n) ? : n
Target System Display [our12-dev:0.0] : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 75
Checking the port pool 75
done: Port Pool 75 is free
Report file located at /backup/PROD/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Complete port information available at /backup/PROD/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Creating the new Database Context file from :
/backup/PROD/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp
The new database context file has been created :
/backup/PROD/db/tech_st/11.1.0/appsutil/PROD_our12-dev.xml
Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneConte
Check Clone Context logfile /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/Cl
Running Rapid Clone with command:
perl /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/backup/P /11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/backup/PROD/db/te
Running:
perl /backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/backup/P /11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/backup/PROD/db/te
APPS Password :
Beginning database tier Apply - Sat Apr 2 07:58:20 2011
/backup/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCON spath /backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/backup psutil/clone/jlib/java:/backup/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/Or ROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/backup/PROD/db/tech_st/ ib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /backup/PROD/db/tech_st/11.1 howProgress
APPS Password : Log file located at /backup/PROD/db/tech_st/11.1.0/appsutil/log/
- 15% completed
Completed Apply...
Sat Apr 2 08:03:06 2011
Starting database listener for PROD:
Running:
/backup/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_our12-dev/addlnctl.sh start PROD
You are running addlnctl.sh version 120.1.12010000.2
Logfile: /backup/PROD/db/tech_st/11.1.0/appsutil/log/PROD_our12-dev/addlnctl.txt
Starting listener process PROD ...
Listener PROD has already been started.
addlnctl.sh: exiting with status 0
[oracle@our12-dev bin]$cd /applprod/apps/apps_st/comn/
[oracle@our12-dev bin]$ perl adcfgclone.pl appsTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.1
Enter the APPS password :
Running:
/applprod/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /applprod/apps/apps_st/comn/clone/jlib/java:/applprod/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/applprod/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /applprod/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_5889.lst -stage /applprod/apps/apps_st/comn/clone 2> /tmp/adcfgclone_5889.err; echo $? > /tmp/adcfgclone_5889.res
Log file located at /applprod/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [our12-dev] :
Target System Database SID : PROD
Target System Database Server Node [our12-dev] :
Target System Base Directory : /applprod
Target System Tools ORACLE_HOME Directory [/applprod/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/applprod/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/applprod/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/applprod/apps/apps_st/comn] :
Target System Instance Home Directory [/applprod/inst] :
Target System Root Service [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 to preserve the Display [y] (y/n) ? : n
Target System Display [our12-dev:0.0] : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 75
Checking the port pool 75
done: Port Pool 75 is free
Report file located at /oracle/inst/apps/OURPROD_our12-apps1/admin/out/portpool.lst
Complete port information available at /oracle/inst/apps/OURPROD_our12-apps1/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /oracle/db/tech_st/11.1.0/appsutil/outbound/OURPROD_our12db
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 :
/applprod/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/oracle/inst/apps/OURPROD_our12-apps1/appl/admin/PROD_our12-dev.xml
Log file located at /applprod/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log
Check Clone Context logfile /applprod/apps/apps_st/comn/clone/bin/CloneContext_0402081258.log for details.
Running Rapid Clone with command:
perl /applprod/apps/apps_st/comn/clone/bin/adclone.pl java=/applprod/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/applprod/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/applprod/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml showProgress contextValidated=true
Running:
perl /applprod/apps/apps_st/comn/clone/bin/adclone.pl java=/applprod/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/applprod/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/applprod/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml showProgress contextValidated=true
APPS Password :
Beginning application tier Apply - Sat Apr 2 08:13:37 2011
/applprod/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /applprod/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/applprod/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/applprod/apps/apps_st/comn/clone/jlib/java:/applprod/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/applprod/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/applprod/apps/apps_st/comn/clone/jlib/oui/share.jar:/applprod/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/applprod/apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /applprod/inst/apps/PROD_our12-dev/appl/admin/PROD_our12-dev.xml -stage /applprod/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /oracle/inst/apps/OURPROD_our12-apps1/admin/log/ApplyAppsTier_04020813.log
\ 89% completed
Completed Apply...
Sat Apr 2 08:20:10 2011
Starting application Services for PROD:
Running:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adstrtal.sh -nopromptmsg
You are running adstrtal.sh version 120.15
The logfile for this session is located at /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adstrtal.log
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adopmnctl.sh start
script returned:
****************************************************
You are running adopmnctl.sh version 120.6
Starting Oracle Process Manager (OPMN) ...
opmnctl: opmn started.
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adopmnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_PROD.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adalnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adapcctl.sh start
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adapcctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adoacorectl.sh start
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adoacorectl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adformsctl.sh start
script returned:
****************************************************
You are running adformsctl.sh version 120.16
Starting OPMN managed FORMS OC4J instance ...
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adformsctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adoafmctl.sh start
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Starting OPMN managed OAFM OC4J instance ...
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adoafmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.3
Starting concurrent manager for PROD ...
Starting PROD_0402@PROD Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adcmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/ieo/ieoicsm.sh start
script returned:
****************************************************
You are running ieoicsm.sh version 120.6
Starting Oracle ICSM server ...
ieoicsm.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/oracle/inst/apps/OURPROD_our12-apps1/admin/scripts/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Validating Fulfillment patch level via /applprod/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for PROD on port 9375 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /oracle/inst/apps/OURPROD_our12-apps1/logs/appl/admin/log/adstrtal.log for more information ...
[oracle@our12-dev bin]$
Adding Addditional Node :-
[oraapps@our12-apps2 ~]$ ping our12db
PING our12db.bilt.com (10.2.0.183) 56(84) bytes of data.
64 bytes from our12db.bilt.com (10.2.0.183): icmp_seq=1 ttl=64 time=0.921 ms
64 bytes from our12db.bilt.com (10.2.0.183): icmp_seq=2 ttl=64 time=0.102 ms
--- our12db.bilt.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1000ms
rtt min/avg/max/mdev = 0.102/0.511/0.921/0.410 ms
[oraapps@our12-apps2 ~]$ clear
[oraapps@our12-apps2 bin]$ perl adclonectx.pl addnode \contextfile=/oracle/OURPROD_our12-apps1.xml
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adclonectx Version 120.23.12010000.1
Running:
/applprod/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /applprod/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/applprod/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/applprod/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /oracle/OURPROD_our12-apps1.xml -addnode
Enter the APPS password : apps
Log file located at /applprod/apps/apps_st/comn/clone/bin/CloneContext_1224105224.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [our12-apps2] :
It is recommended that your inputs are validated by the program.
However you might choose not to validate them under following circumstances:
-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and
you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.
Do you want the inputs to be validated (y/n) [n] ? : y
Target System Root Service [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 to preserve the Display [y] (y/n) ? : n
Target System Display [our12-apps2:0.0] : y
Database port is 1523
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 2
Checking the port pool 2
done: Port Pool 2 is free
Report file located at /oracle/inst/apps/OURPROD_our12-apps2/admin/out/portpool.lst
Complete port information available at /oracle/inst/apps/OURPROD_our12-apps2/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /oracle/db/tech_st/11.1.0/appsutil/outbound/OURPROD_our12db
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 :
/applprod/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Log file located at /applprod/apps/apps_st/comn/clone/bin/CloneContext_1224105224.log
contextfile=/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Check Clone Context logfile /applprod/apps/apps_st/comn/clone/bin/CloneContext_1224105224.log for details.
[oraapps@our12-apps2 bin]$ gedit /oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
[oraapps@our12-apps2 bin]$ perl adc
adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl
[oraapps@our12-apps2 bin]$ pwd
/applprod/apps/apps_st/comn/clone/bin
[oraapps@our12-apps2 bin]$ cd ../../
[oraapps@our12-apps2 comn]$ cd ../
[oraapps@our12-apps2 apps_st]$ cd appl/ad
ad/ admin/
[oraapps@our12-apps2 apps_st]$ cd appl/ad/12.0.0/bin/
[oraapps@our12-apps2 bin]$ perl adconfig.pl \contextfile=/oracle/inst/apps/OURPROD_our12-apps2/a
admin/ appl/
[oraapps@our12-apps2 bin]$ perl adconfig.pl \contextfile=/oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.xml
Enter the APPS user password:
The log file for this session is located at: /oracle/inst/apps/OURPROD_our12-apps2/admin/log/12241057/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /oracle/inst/apps/OURPROD_our12-apps2
Classpath : /applprod/apps/apps_st/comn/java/lib/appsborg2.zip:/applprod/apps/apps_st/comn/java/classes
Using Context file : /oracle/inst/apps/OURPROD_our12-apps2/appl/admin/OURPROD_our12-apps2.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........
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_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 IGS_TOP.......COMPLETED
Configuring IBY_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 XXSE_TOP.......COMPLETED
Configuring EAM_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.
[oraapps@our12-apps2 bin]$
No comments:
Post a Comment