C Installing Real Application Clusters (RAC)

Oracle Life Sciences Data Hub (Oracle LSH) Release 2.1.4 is certified for use with Oracle Real Application Clusters (RAC).

Required Setup

1. Complete all instructions in this installation guide.

2. Create a cluster according to your requirements as described in Section 3.1.1 of My Oracle Support article 823586.1, Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 11i.

Installing RAC

Instructions for installing RAC are in My Oracle Support article 823586.1, Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 11i . The following notes supplement article 823586.1. The section numbers below refer to sections in article 823586.1.

1. Read Section 1.1 to understand RAC terminology.

2. Follow instructions in Section 1.2, Configuration Prerequisites, Step 3, to apply Oracle Applications patches. Note that 11i.ATG_PF.H RUP6, patch 5903765, is not required because you have already installed RUP7 according to the instructions in the Oracle Life Sciences Data Hub Installation Guide. However, the other patches are required.

3. Follow instructions in Section 3.1, Install Oracle Clusterware 11g R2. This is a critical step; follow all the steps in this section carefully. For detailed installation requirements refer to the Oracle Grid Infrastructure Installation Guide for your operating system at http://www.oracle.com/pls/db112/lookup?id=CWGEN.

   Be sure to verify that the cluster is set up correctly as described in Section 3.1.7, Step 3. The grid infrastructure should now be running on all nodes.

4. Follow instructions in Section 3.2 to install Oracle Database 11gR2 on each additional node of your cluster. Make sure that:

   • the path to the 11gR2 Oracle Home is identical on each node

   • all database patches that have been applied to your primary Oracle Home are applied on every other Oracle Home

5. Follow instructions in Section 3.3 to configure the listener for Oracle Database 11gR2.

6. Follow instructions in Section 3.4 to configure your preferred type of shared storage.

7. Follow instructions in Section 3.5 to convert the 11gR2 database to RAC. There are three options for the RAC conversion. Oracle LSH was tested with the 'rconfig' option. The following instructions are intended to clarify the instructions provided after Step 5 of this section on creating the spfile:

   1. Move the spfile to a shared location so that all nodes can access the spfile.

   2. Back up the existing init.ora file.

   3. Open the init.ora file and add a new parameter:

      spfile= '<Path of spfile on shared disk>/spfile<ORACLE_SID>.ora'
      

   4. Start up the database using the new init.ora file.

   5. Continue with Step 9 to run rconfig and complete this section. After successfully running rconfig, the database instances and listener services should be running on all the database nodes.

8. Follow instructions in Section 3.7 to enable AutoConfig. Follow all steps carefully. Do not proceed further until you have successfully run AutoConfig on every node.

9. Follow instructions in Section 3.8 to configure the Applications environment for 11gR2 RAC on all application tier nodes.

10. Follow instructions in Section 3.9 to configure Parallel Concurrent Processing.