Add Application Tier Node to Apps/EBS R12
After migrating the Apps/EBS R12 DB to RAC with two nodes it's the time to do the same for the Apps Tier.
There are two methods available for this addition of the new node. One is using shared file system and one is traditional method, using local file system on the node.
One can use OCFS2 or NFS as shared file system and can migrate the apps files to shared mount point which can then, in turn, can accessible by multiple nodes. However, I choose to go with the later approach for the sake of easy implementation.
Topology info -
apps_rac01 - Apps RAC DB Node1
apps_rac02 - Apps RAC DB Node2
DB - visr12
appsnode_new - Apps Application Tier Node1
appsnode2_new- Apps Application Tier Node2
The overall process is divided in three parts
1. Clone the node the target system
2. Add node using adaddnode.pl script
3. Set Up DB Load Balancing On Apps Tier
Clone New Node -
Configure Pre Clone
[oracle@appsnode2_new bin]$ perl ./adpreclone.pl appsTier
Copy the application tier file system
Log on to the source system application tier nodes and shut down the application tier server processes. Copy the "apps" from source node to the target application tier node
Start Clone
[oracle@appsnode2_new 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.8
Enter the APPS password :
Running:
/u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/app/oracle/visr12/apps/apps_st/comn/clone/jlib/java:/u01/app/oracle/visr12/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/app/oracle/visr12/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_25768.lst -stage /u01/app/oracle/visr12/apps/apps_st/comn/clone 2> /tmp/adcfgclone_25768.err; echo $? > /tmp/adcfgclone_25768.res
Log file located at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [appsnode2_new] : appsnode2_new.localdomain
Target System Database SID : visr12
Target System Database Server Node [appsnode2_new] : apps-scan.localdomain
Target System Base Directory : /u01/app/oracle/visr12
Target System Tools ORACLE_HOME Directory [/u01/app/oracle/visr12/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/u01/app/oracle/visr12/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/u01/app/oracle/visr12/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/u01/app/oracle/visr12/apps/apps_st/comn] :
Target System Instance Home Directory [/u01/app/oracle/visr12/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 [disabled] :
Do you want to preserve the Display [appsnode_new:0.0] (y/n) ? : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : y
Complete port information available at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/out/visr12_appsnode2_new/portpool.lst
RC-40201: Unable to connect to Database visr12.
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.8
Enter the APPS password :
Running:
/u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/app/oracle/visr12/apps/apps_st/comn/clone/jlib/java:/u01/app/oracle/visr12/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/app/oracle/visr12/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_25768.lst -stage /u01/app/oracle/visr12/apps/apps_st/comn/clone 2> /tmp/adcfgclone_25768.err; echo $? > /tmp/adcfgclone_25768.res
Log file located at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [appsnode2_new] : appsnode2_new.localdomain
Target System Database SID : visr12
Target System Database Server Node [appsnode2_new] : apps-scan.localdomain
Target System Base Directory : /u01/app/oracle/visr12
Target System Tools ORACLE_HOME Directory [/u01/app/oracle/visr12/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/u01/app/oracle/visr12/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/u01/app/oracle/visr12/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/u01/app/oracle/visr12/apps/apps_st/comn] :
Target System Instance Home Directory [/u01/app/oracle/visr12/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 [disabled] :
Do you want to preserve the Display [appsnode_new:0.0] (y/n) ? : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : y
Complete port information available at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/out/visr12_appsnode2_new/portpool.lst
RC-40201: Unable to connect to Database visr12.
Creating the new APPL_TOP Context file from :
/u01/app/oracle/visr12/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml
Log file located at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log
Check Clone Context logfile /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log for details.
Running Rapid Clone with command:
perl /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/app/oracle/visr12/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml showProgress contextValidated=true
Do you want to preserve the Display [appsnode_new:0.0] (y/n) ? : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : y
Complete port information available at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/out/visr12_appsnode2_new/portpool.lst
RC-40201: Unable to connect to Database visr12.
Creating the new APPL_TOP Context file from :
/u01/app/oracle/visr12/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml
Log file located at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log
Check Clone Context logfile /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log for details.
Running Rapid Clone with command:
perl /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/app/oracle/visr12/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml showProgress contextValidated=true
ApplyAppsTier_08100928.log
/ 73% completed
Completed Apply...
Fri Aug 10 09:42:06 2012
Do you want to startup the Application Services for visr12? (y/n) [y] : n
Services not started
Add Cloned Node to Existing Apps Instance -
-- Source the env
[oracle@appsnode2_new bin]$ cd /u01/app/oracle/visr12/apps/apps_st/appl/
[oracle@appsnode2_new appl]$ . ./APPSvisr12_appsnode2_new.env
-- Invoke the adaddnode.pl script
[oracle@appsnode2_new appl]$ cd /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/
[oracle@appsnode2_new bin]$ perl ./adaddnode.pl
Enter the APPS username: apps
Enter the APPS user password:
Using CONTEXT_FILE : /u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml
Using CTXORIG : /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml
APPL_TOP name of the source system (old APPL_TOP name) : appsnode_new
APPL_TOP name of the target system (new APPL_TOP name) : appsnode2_new
Configuring snapshot information for the original (clone source) node...
Executing command:
sqlplus /nolog @/u01/app/oracle/visr12/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adadmrat.sql APPS apps visr12 visr12 appsnode2_new appsnode_new /u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/temp/adadmat_sql.spool
APPL_TOP Names in AD_APPL_TOPS:
*PRESEEDED*
GLOBAL
ap6003bld
ap6004bld
ap6009bld
appsnode2_new
appsnode_new
7 rows selected.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Done
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Completed snapshot configuration on target node.
Set Up DB Load Balancing On Apps Tier -
To load balance the forms based applications database connections, set the value of "Tools OH TWO_TASK" to point to the <database_name>_balance alias generated in the tnsnames.ora file.
To load balance the self-service applications database connections, set the value of "iAS OH TWO_TASK" and "Apps JDBC Connect Alias" to point to the <database_name>_balance alias generated in the tnsnames.ora file.
Execute AutoConfig by running the command
[oracle@appsnode_new appl]$ adautocfg.sh
Restart the Applications processes, using the new scripts generated by AutoConfig.
Ensure that value of the profile option "Application Database ID" is set to dbc file name generated in $FND_SECURE.
Once you have added the node successfully, however you can only use only one node and there is no Active-Active load balancing in place, coz one need Load Ba-lancer for that.
/u01/app/oracle/visr12/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml
Log file located at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log
Check Clone Context logfile /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log for details.
Running Rapid Clone with command:
perl /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/app/oracle/visr12/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml showProgress contextValidated=true
Do you want to preserve the Display [appsnode_new:0.0] (y/n) ? : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : y
Complete port information available at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/out/visr12_appsnode2_new/portpool.lst
RC-40201: Unable to connect to Database visr12.
Creating the new APPL_TOP Context file from :
/u01/app/oracle/visr12/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml
Log file located at /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log
Check Clone Context logfile /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/CloneContext_0810092623.log for details.
Running Rapid Clone with command:
perl /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/app/oracle/visr12/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml showProgress contextValidated=true
ApplyAppsTier_08100928.log
/ 73% completed
Completed Apply...
Fri Aug 10 09:42:06 2012
Do you want to startup the Application Services for visr12? (y/n) [y] : n
Services not started
Add Cloned Node to Existing Apps Instance -
-- Source the env
[oracle@appsnode2_new bin]$ cd /u01/app/oracle/visr12/apps/apps_st/appl/
[oracle@appsnode2_new appl]$ . ./APPSvisr12_appsnode2_new.env
-- Invoke the adaddnode.pl script
[oracle@appsnode2_new appl]$ cd /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/
[oracle@appsnode2_new bin]$ perl ./adaddnode.pl
Enter the APPS username: apps
Enter the APPS user password:
Using CONTEXT_FILE : /u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/appl/admin/visr12_appsnode2_new.xml
Using CTXORIG : /u01/app/oracle/visr12/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml
APPL_TOP name of the source system (old APPL_TOP name) : appsnode_new
APPL_TOP name of the target system (new APPL_TOP name) : appsnode2_new
Configuring snapshot information for the original (clone source) node...
Executing command:
sqlplus /nolog @/u01/app/oracle/visr12/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adadmrat.sql APPS apps visr12 visr12 appsnode2_new appsnode_new /u01/app/oracle/visr12/inst/apps/visr12_appsnode2_new/temp/adadmat_sql.spool
APPL_TOP Names in AD_APPL_TOPS:
*PRESEEDED*
GLOBAL
ap6003bld
ap6004bld
ap6009bld
appsnode2_new
appsnode_new
7 rows selected.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Done
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Completed snapshot configuration on target node.
Set Up DB Load Balancing On Apps Tier -
Now its time to implement load balancing for the Oracle Applications database connections...
Run the Context Editor (through the Oracle Applications Manager interface) and set the value of "Tools OH TWO_TASK" (s_tools_two_task), "iAS OH TWO_TASK"(s_weboh_twotask) and "Apps JDBC Connect Alias" (s_apps_jdbc_connect_alias).
To load balance the forms based applications database connections, set the value of "Tools OH TWO_TASK" to point to the <database_name>_balance alias generated in the tnsnames.ora file.
To load balance the self-service applications database connections, set the value of "iAS OH TWO_TASK" and "Apps JDBC Connect Alias" to point to the <database_name>_balance alias generated in the tnsnames.ora file.
Execute AutoConfig by running the command
[oracle@appsnode_new appl]$ adautocfg.sh
Restart the Applications processes, using the new scripts generated by AutoConfig.
Ensure that value of the profile option "Application Database ID" is set to dbc file name generated in $FND_SECURE.
Once you have added the node successfully, however you can only use only one node and there is no Active-Active load balancing in place, coz one need Load Ba-lancer for that.
Next you have to configure the Load Balancing with multiple apps tier and PCP [parallel con-current processing], which will be part of my coming post... Stay tuned...
Ref Note - Using Load-Balancers with Oracle E-Business Suite Release 12 [ID 380489.1]
No comments:
Post a Comment