Adding a Middle Tier to an Existing R12 Instance

The following steps will help in adding a Middle Tier to an Existing R12 Instance.

Pre-Step : Configure the Node to be added with equivant Operating System and Kernel version as of the Primary Node.
Create the Users/Group as that was done to the Primary Node

Step 1: Make the File System of the Primary Node accessible on the Secondary Node
The following mount points must be present on the Secondary Node
COMMON_TOP
APPL_TOP
10.1.2 ORACLE HOME
10.1.3 ORACLE HOME

Step 2: Log on the Second Node and move to the COMMON_TOP/clone/bin
adclonectx.pl needs to be run with the option addnode with the context file as a parameter.
The context file will be of the first node.
Syntax : perl adclonectx.pl addNode contextfile=
This step will display the path of the new context file that got generated.
[aptest@node02 bin]$ perl adclonectx.pl addnode
contextfile=…./TEST_node01/appl/admin/TEST_node01.xml
….//apps/apps_st/comn/clone/bin
Classpath: …./apps/apps_st/comn/clone/bin/
/home1/aptest/test/apps/apps_st/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath /home1/aptest/test/apps/apps_st/comn…….
oracle.apps.ad.context.CloneContext -e
…./TEST_node01/appl/admin/TEST_node01.xml -addnode
Running command:
…./apps_st/comn/clone/bin/../jre/bin/java
-Xmx600M -classpath /home1/aptest/test/apps/apps_st/comn/clone/………….
oracle.apps.ad.context.CloneContext -e
…./TEST_node01/appl/admin/TEST_node01.xml -addnode
Enter the APPS password : apps
Log file located at …./apps_st/comn/clone/bin/CloneContext_02061014.log
Provide the values required for creation of the new APPL_TOP Context file.
Target hostname (virtual or normal) [node02]:
It is recommended that your inputs are validated by the program.
However you might choose not to validate your inputs 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] ?:
Target system service groups – enable Root Service Group [enabled] [enabled]:
Target system service groups – enable Web Entry Point Services [enabled] [enabled]:
Target system service groups – enable Web Application Services [enabled] [enabled]:
Target system service groups – enable Batch Processing Services [enabled] [disabled]:
Target system service groups – enable Other Service Group [disabled] [disabled]:
Do you want to preserve the Display set to inchmgmt101:0.0 (y/n) [y] ?:
Database port is 1526
Do you want the the target system to have the same port values as the source system (y/n) [y] ?:
Complete port information available at
…./apps_st/comn/clone/bin/out/TEST_node02/portpool.lst
Target system proxy hostname:www-proxy.us.test.com
Target system proxy port:80
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /home1/ortest/test/db/tech_st/10.2.0/appsutil/outbound/TEST_node01
4. /usr/tmp
 
Choose a value which will be set as APPLPTMP value on the target node [1]:1
New context path and file name [..../apps/TEST_node02/appl/admin/TEST_node02.xml]:
Creating the new APPL_TOP Context file from : …./ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created : …./TEST_node02/appl/admin/TEST_node02.xml
Log file located at …./apps_st/comn/clone/bin/CloneContext_02061014.log
contextfile=…./apps/TEST_node02/appl/admin/TEST_node02.xml
Check logfile …./apps_st/comn/clone/bin/CloneContext_02061014.log for details.

[aptest@node02 bin]$
Note : Node 2 will act as a web node.
Step 3: On the Second Node move to the AD_TOP/bin directory
Run adconfig.sh with the context_file that got generated after Step2
[aptest@node02 admin]$ adconfig.sh
Enter the full path to the Context file: /home1/aptest/test/inst/apps/TEST_node02/appl/admin/TEST_node02.xml
Enter the APPS user password: AutoConfig is configuring the Applications environment…
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /home1/aptest/test/inst/apps/TEST_node02
Classpath : /home1/aptest/test/apps/apps_st/comn/java/lib/appsborg2.zip:
/home1/aptest/test/apps/apps_st/comn/java/classes
Using Context file : /home1/aptest/test/inst/apps/TEST_node02/appl/admin/TEST_node02.xml
Context Value Management will now update the Context file
Updating Context file…COMPLETED
Attempting upload of Context file and templates to database…COMPLETED
Configuring templates from all of the product tops…
Configuring AD_TOP……..COMPLETED
Configuring FND_TOP…….COMPLETED
Configuring ICX_TOP…….COMPLETED
Configuring IEO_TOP…….COMPLETED
Configuring 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 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
AutoConfig completed successfully.
The log file for this session is located at: /home1/aptest/test/inst/apps/TEST_node02/admin/log/02061035/adconfig.log
[aptest@node02 admin]$

Step 4: Perform a Health Check
Shutdown the Middle Tier Components on Node1 and Start the Services on Node2
The webentry on the context files would be pointing to Node 2 and simillarly all the Agent Profile Option would have been marked with Node 2.
Later Node 1 can be made as a primary node by running autoconfig.
The Setup will a complete one with a Load Balancer in place , since there are two web nodes added and have Web Entry Point Services enabled.

Must Read :
Note.384248.1 Ext/Pub Sharing The Application Tier File System in Oracle E-Business Suite Release 12