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:

Step-1

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.

Step-2

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.

SQL> update ICX_PARAMETERS
set SESSION_COOKIE_NAME='PRODRAC1';

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

Step-3

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

Step-4

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:

http://www.rampant-books.com/book_2004_1_10g_grid.htm