(Optional) Restore CA GovernanceMinder-Oracle RAC Databases Connection

Scenario Guide › Scenario Overview › Installing CA GovernanceMinder and Oracle Real Application Clusters (RAC) › How to Install CA GovernanceMinder and Oracle RAC › (Optional) Restore CA GovernanceMinder-Oracle RAC Databases Connection

(Optional) Restore CA GovernanceMinder-Oracle RAC Databases Connection

You restore the connection between CA GovernanceMinder and Oracle RAC databases after a failure. Connection failures can occur when you connect to the SQL database through the CA GovernanceMinder server.

Follow these steps:

Edit the tnsnames.ora file for the database cluster from the database server. Do the following:
1. Locate the tnsnames.ora file in the Oracle home directory.
2. Locate the instances that represent your clustered service and verify 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
```
```
   )
```
```
)
```
3. Save and close the file.
  The tnsnames.ora file is edited, and the Oracle client-server connection is restored.
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.
Do the following:
1. Locate the eurekify.properties file in the following folder:
```
gm_install/Program Files/CA\RCM/Server/eurekify-jboss/conf
```
2. Add the following property to define the database host name as the CA GovernanceMinder SDB database:
```
sdb.host=RCMDB1
```
  Note: RCMDB1 is the Oracle RAC database host name.
3. Save and close the file.
  The eurekify.properties file is edited to define the database host name as the CA GovernanceMinder SDB database.
On the CA GovernanceMinder installation computer, open Oracle SQL Developer or similar program for working with SQL in Oracle databases.

Connect to the eurekify_sdb database, and insert the following text:

insert into SAGE_PREFERENCES

(LoginID, PrefGroup, Name, Value)

values

('eurekify.properties', 'eurekify.properties.dynamic', 'sdb.host', 'RCMDB1');

In the Query menu, select Execute to run the SQL query.
The CA GovernanceMinder and Oracle RAC databases connection is restored.