Oracle E-Business Suite and Oracle Real Application Clusters

Introduction to Oracle Real Application Clusters

This section gives an overview of the steps required to install Oracle E-Business Suite in an environment that uses Oracle Real Application Clusters (Oracle RAC).

For full details of using Oracle E-Business Suite Release 12.1 with Oracle RAC, see My Oracle Support Knowledge Document 745759.1.1, Oracle E-Business Suite and Oracle Real Application Clusters Documentation Roadmap. This document lists release-specific documentation you should refer to according to the Oracle E-Business Suite and Oracle Database releases you are using.

Prerequisites

Several steps must be followed to prepare your system for utilizing Oracle RAC to support Oracle E-Business Suite. Key steps are as follows:

  1. Install requisite Oracle Clusterware

  2. Install requisite Oracle Database software

  3. Configure TNS listener

  4. Create ASM instances/diskgroups (optional)

  5. Convert Oracle Database to Oracle RAC using rconfig

  6. Perform post-conversion steps

  7. Enable AutoConfig on database tier

  8. Establish Applications environment for Oracle RAC

  9. Configure Parallel Concurrent Processing

Migrating to Oracle RAC

Conversion of an Oracle database to utilize Oracle RAC is accomplished by running the rconfig utility against a sample XML file, ConvertToRAC.xml, which you modify to meet the particular requirements of your system.

In order to validate and test the settings specified for converting to Oracle RAC with rconfig, rconfig should be run in "Verify only" mode prior to running the actual conversion. This will perform a test run, in which rconfig will validate parameter settings, and report any issues that need to be resolved before the actual conversion is undertaken.

Establishing the Oracle E-Business Suite Environment for Oracle RAC

On the Oracle E-Business Suite side, a number of steps are needed to prepare the environment for Oracle RAC. Follow the detailed instructions in the relevant knowledge document under My Oracle Support Knowledge Document Note 745759.1, Oracle E-Business Suite and Oracle Real Application Clusters Documentation Roadmap.

In summary, you need to:

  1. Run AutoConfig on the Applications database tier.

  2. Check the tnsnames.ora and listener.ora files in the $INST_TOP/ora/10.1.2/network/admin and $INST_TOP/ora/10.1.3/network/admin/<context_name>.

  3. Ensure that the correct TNS aliases have been generated for load balance and failover.

  4. Ensure that all the aliases are defined using the virtual hostnames.

  5. Verify the dbc file located at $FND_SECURE. Ensure that the parameter APPS_JDBC_URL is configured with all instances in the environment, and load_balance is set to YES.

Configuring Parallel Concurrent Processing with Oracle RAC

To take full advantage of Parallel Concurrent Processing (PCP), you will need to have more than one Concurrent Processing node in your environment. If you do not have more than one node, refer to My Oracle Support for details of cloning the application tier.

The key steps in configuring concurrent parallel processing are as follows:

  1. Configure PCP on all concurrent processing nodes.

  2. Set up transaction managers.

  3. Set up load balancing on concurrent processing nodes and run AutoConfig.

Related Topics

Overview of Parallel Concurrent Processing

Managing Parallel Concurrent Processing