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

 
 Home
 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
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

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

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 

 

BRTOOLS

Oracle RAC Cluster Tips by Burleson Consulting

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 reorganization tasks.

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:

* SAPDBA

* BRCONNECT

* BRRESTORE

* BRBACKUP

* BRARCHIVE

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 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, 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.

SQL> update ICX_PARAMETERS
set SESSION_COOKIE_NAME=?PRODRAC1?;

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 instance_path.

 


This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters, Rampant TechPress, by Mike Ault and Madhu Tumma.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

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


 

 
��  
 
 
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 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational