R12 Cloning - Add new application node to existing environment

Applies To:

Oracle E-Business Suite R12 (12.1.3)

Issue:

I was facing performance issue on Production ERP server. Because of high usage of JAVA processes and frequent OACORE JVM failure users were getting disconnected from the sessions and login page was also not available. To overcome this, i have added additional node to the existing Production environment.

Goal:

You can use Rapid Clone to clone a node and add it to the existing Applications system, a process also known as scale up or scale out. The new node can run the same services as the source node, or different services.

Reference Doc Id: 406982.1

Steps to be done:

Prepare the source system

Prepare the source system application tier for cloning
cd $INST_TOP/admin/scripts

perl adpreclone.pl appsTier

Copy the source system to the target system

Copy the application tier file system

APPL_TOP
COMMON_TOP
Application Technology Stack

OracleAS Tools ORACLE_HOME
OracleAS Web IAS_ORACLE_HOME

Configure the target system

Configure the target system application tier server nodes

cd $COMMON_TOP/clone/bin

perl adcfgclone.pl appsTier

(Now, after cloning finishes successfully we have to add the following node to the production application systems, a process known as scale up or scale out)

After adcfgclone.pl completes, source the Applications environment and run the following commands on the target system:

cd $COMMON_TOP/clone/bin

perl adaddnode.pl

Run autoconfig on all the application server after finishing adaddnode.pl script and then start services.

Comments

Node id does not exist for the current application server id

Issue: After completing cloning procedure, you generally may across the following issue. "Node id does not exist for the current application server id". Solution: First stop the application. Run adgendbc.sh script to configure apps tier dbc file with the correct id from the database instance. Start the application and test your issue. Location of script: 11i: $COMMON_TOP/admin/install/$CONTEXT_NAME R12: $INST_TOP/admin/install [appldev@erptest install]$ sh adgendbc.sh (Note: It will prompt you to give apps username and apps password.)

How to change EBS R12 database and application port number

On Database Tier 1. Logon as oracle database user and source environment for R12 RDBMS ORACLE_HOME 2. Start database instance for which you want to change R12 port 3. Backup contextfile 4. Change as below in contextfile dbport : Change database port from 1521 to 1541 db_ons_localport : 6300 to 6320 db_ons_remoteport : 6400 to 6420 cmanport : 1521 to 1541 5. Run adautocfg.sh On Apps Tier Change Application port from 8000 to 8020 1. Logon as application manager user and source environment for R12 2. Backup contextfile 3. Run adpreclone $ perl ./adpreclone.pl appsTier 4. Run adcfgclone and choose new port pool $ cd $COMMON_TOP/clone/bin $ perl ./adcfgclone.pl appsTier 5. Check new application URL SQL> select home_url from icx_parameters; HOME_URL ----------...

Oracle R12 : You are trying to access a page that is no longer active

Login fails “You are trying to access a page that is no longer active.” The issue can be reproduced at will with the following steps: Issue : After cloning process the login page of Oracle E-Business Suite R12 show the above error. Solution : For this you need to update the new hostname in the icx_parameteres table 1. SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- erp.local.com (This is hostname of Source Application Tier) 2. SQL>update icx_parameters set SESSION_COOKIE_DOMAIN = ‘target.local.com’; 1 row updated. SQL> commit; Commit complete. (This has changed the SESSION_COOKIE_DOMAIN of target application to target hostname.domain_name) 3. SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- target.local.com

Latest Technology Blog

Search This Blog