This is an excerpt from the bestselling book
Oracle Grid & Real Application Clusters. To get immediate
access to the code depot of working RAC scripts, buy it
directly from the publisher and save more than 30%.
BRTOOLS is the name for the
suite of programs and utilities from SAP to administer the Oracle
database perform backup and recovery, as well as many other
For an Oracle Database 10g RAC
configuration, replace these tools with the latest version shipped
by SAP. The latest version is available on SAP?s service market
place or through OCS.
Along with all the other
executables for a SAP installation, BRTOOLS are located in the
directory /usr/sap/<SID>/exe/run. BRTOOLS consist of the following
set of files:
For more details, Oracle white
paper Configuring SAP R3 4.6D for use with Oracle Database 10g RAC
is an excellent reference.
In Case of Oracle eBusiness
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, two separate TNS aliases should be
defined. The load_balance option in the tnsnames.ora should not be
used as it 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, the cookie name (session_cookie_name)
should be explicitly set 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.
* Step-3: 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, the Oracle Applications
profile option Database Instance, i.e. instance_path, can be used to
bind users with a particular responsibility to a particular
instance. For example, Purchasing Forms users can be bound to
instance A, and Order Management Forms users to instance B using the
Database Instance profile option.
Oracle eBusiness lets users
specify or define Oracle Application Object Library profiles with a
variety of options. Profile Database Instance allows different
responsibilities and users to connect to different nodes of the RAC
database sever. The internal name for this profile option is