Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








  Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 15 - RAC Migration Topics

In Case of Oracle eBusiness Suite

When the Oracle Single Instance supporting the Oracle eBusiness suite is converted and migrated to a RAC database, there are certain considerations to take into account so as to better utilize the RAC database. They are as follows:


Configure the tnsnames.ora file - Change the tnsnames.ora  files on the middle-tier systems (i.e., database clients) to reflect the RAC environment.  For a 2-node cluster system, you should define two separate TNS aliases. Do not use the load_balance option in the tnsnames.ora as this will result in application errors.


Configure Self-Service for RAC - The Self-Service infrastructure (ICX), by default, uses the database instance name as part of the cookie name if the administrator has not explicitly set the cookie name. In the RAC environment, the database instance name can change based on which instance the users are connected. Hence, you should explicitly set the cookie name (session_cookie_name) to a constant value in the icx_parameters table. Update the icx_parameters table from the Apps schema using the following example.


In the example above, the cookie name is set to 'PRODRAC1.'


Next, start up the Application servers. These would include the Forms servers, Report Server, Apache (JServ and Mod PL/SQL), and Concurrent Manager, etc.


Application Partitioning - In order to direct a certain class of users to a particular instance in the RAC cluster, you can use the Oracle Applications profile option 'Database Instance' (i.e., instance_path) to bind users with a particular responsibility to a particular instance. For example, you can bind Purchasing Forms users to instance A, and Order Management Forms users to instance B using the 'Database Instance' profile option.

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle 10g Grid & Real Application Clusters", by Rampant TechPress.  Written by top Oracle experts, Mike Ault and Madhu Tumma, this book has a complete online code depot with ready to use scripts. 

To get the code instantly, click here:

Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.