Configure CA GovernanceMinder with Oracle RAC Databases

Scenario Guide › Scenario Overview › Installing CA GovernanceMinder and Oracle Real Application Clusters (RAC) › How to Install CA GovernanceMinder and Oracle RAC › Configure CA GovernanceMinder with Oracle RAC Databases

Configure CA GovernanceMinder with Oracle RAC Databases

You configure CA GovernanceMinder with Oracle RAC databases by adding roles, establishing communication, and defining parameters.

Follow these steps:

Create a CA GovernanceMinder database user (schema). This user must have the following permissions and settings:
- Roles: CONNECT, RESOURCE
- System Privileges: ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, SELECT ANY DICTIONARY
The CONNECT role provides the create session permission. The RESOURCE role provides several create system privileges, and provides for previous Oracle database compatibility releases.
Edit the tnsnames.ora file for the database cluster from the database server.
You modify the tnsnames.ora file by adding your cluster address and port. The Oracle client uses the tnsnames.ora file to connect to the Oracle server. Do the following:
1. Locate the tnsnames.ora file in the Oracle home directory. The tnsnames.ora file is located in the following folder:
```
Oracle_home/NETWORK/ADMIN
```
2. Locate the instances that define your clustered service and add your cluster address and port.
  Example:
```
RCMDB1 = 
```
```
   (DESCRIPTION =
```
```
     (ADDRESS = (PROTOCOL = TCP)(HOST = oraclusternode1-vip)(PORT = 1521))
```
```
     (ADDRESS = (PROTOCOL = TCP)(HOST = oraclusternode2-vip)(PORT = 1521))
```
```
     (LOAD_BALANCE = yes)
```
```
     (CONNECT_DATA =
```
```
      (SERVER = DEDICATED)
```
```
      (SERVICE_NAME = RCMDB1
```
```
   )
```
```
)
```
  In this example, your Oracle RAC cluster and port have been defined.
3. Save and close the file.
  The tnsnames.ora file is edited.

Update the hosts file to define current cluster nodes.

You define the IP addresses and the Oracle RAC host names. Do the following:

Locate the hosts file in the following folder:
```
gm_install/Windows/System32/drivers/etc
```
Define the IP addresses and the Oracle RAC host names.

Save and close the file.

You have updated the hosts file to define the current cluster nodes.

Example: In this example, in the # RAC VIRTUAL INTERFACES section, IP address 10.0.0.82 is defined as rac1-vip.localdomain, and IP address 10.0.0.83 is defined as rac2-vip.localdomain.

###########################################

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1       localhost.localdomain localhost

10.0.0.39       ca_gm_linux46.localdomain   ca_gm_linux46

# RAC VIRTUAL INTERFACES

10.0.0.82       rac1-vip.localdomain    rac1-vip

10.0.0.83       rac2-vip.localdomain    rac2-vip

# RAC PUBLIC INTERFACES

10.0.0.182      rac1.localdomain        rac1

10.0.0.183      rac2.localdomain        rac2

###########################################

Edit the eurekify.properties file to define the database host name as the CA GovernanceMinder SDB database. The SDB contains CA GovernanceMinder Master and Model data.
Important! When you upgrade from CA GovernanceMinder 12.5 SPx with Oracle RAC, edit this property file after the upgrade process completes.
1. Locate the eurekify.properties file in the following folder:
```
gm_install/Program Files/CA/RCM/Server/eurekify-jboss/conf/
```
  Note: gm_install is the CA GovernanceMinder installation directory.
2. Add the following property:
```
sdb.host=RCMDB1
```
  Note: RCMDB1 is the Oracle RAC database service name as defined above.
3. Save and close the file.
  You have edited the eurekify.properties file to define the database host name as the CA GovernanceMinder SDB database.
  
  Note: Update this property file in each node when you configure CA GovernanceMinder to work in a cluster.
Run the CA GovernanceMinder installer, and in the database parameters section, define the following database parameters:
- Oracle Server Host - The IP address of one of the cluster nodes.
- Oracle Service name - Cluster Database service name (not the nodes).
  Example:
```
Specify Oracle SQL Server Information
```
```
Oracle Server Host (DEFAULT: rcmlinux46.localdomain): rac1
```
```
Oracle Service Name (DEFAULT: ORCL): RCMDB1
```
```
Specify Oracle Server port (DEFAULT: 1521):1521
```
Note: For more information, refer to the CA GovernanceMinder Installation Guide.
Increase the database sessions and processes parameters from the default setting to reduce exceptions.
1. Connect to the database with the system account.
2. Run the following commands:
```
alter system set sessions=400 scope=spfile;
```
```
alter system set processes=400 scope=spfile;
```
3. Restart the entire database (all cluster instances).
  Database sessions and process parameters are increased.
You have configured CA GovernanceMinder with Oracle RAC databases. You now configure JDBC connectivity.