Installation Guide › Installing CA GovernanceMinder and Oracle RAC › Configure Java Database Connectivity (JDBC)

Configure Java Database Connectivity (JDBC)

You configure the JDBC to connect to a database and increase default cache settings. JDBC, an API for the Java programming language, defines how a client accesses a database by providing querying methods and updating database data.

Follow these steps:

1. Backup the eurekify-ds.xml and wp-ds.xml files from the following folder:

   gm_install/CA/RCM/Server/eurekify-jboss/server/eurekify/deploy/
   

2. Update JDBC URL values to define Oracle RAC database cluster rac1-vip and rac2-vip. Do the following:
   1. Locate the following elements in both files:

      <connection-url>jdbc:oracle:thin:@rac:1521/RCMDB1</connection-url>
      

   2. Replace with the following text that defines the JDBC URL to Oracle RAC cluster rac1-vip and rac2-vip databases:

      <connection-url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
      

      (ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip.localdomain) (PORT=1521))
      

      (ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip.localdomain) (PORT=1521))
      

      (CONNECT_DATA=(SERVICE_NAME=RCMDB1)))</connection-url>
      

   3. Save and close the files.

      The JDBC URL values define Oracle RAC database cluster rac1-vip and rac2-vip.

3. Reset the CA GovernanceMinder cache limits.

   Do the following:

   1. Locate the cache-sageDal.xml file in the following folder:

      gm_install/Program Files/CA/RCM/Server/eurekify-jboss/server/eurekify/deploy/eurekify.war/WEB-INF/classes
      

   2. Locate the maxElementsInMemory value and set at 900000.

      Example:

      defaultCache maxElementsInMemory="900000" eternal="true"
      

      		overflowToDisk="false" memoryStoreEvictionPolicy="LRU">
      

      		<cacheEventListenerFactory
      

      			class="com.eurekify.dal.SageCacheEventListenerFactory" properties="" />
      

      	</defaultCache>
      

   3. Save and close the file.

      The CA GovernanceMinder cache limits are reset.

      You have configured the JDBC. You now verify a successful CA GovernanceMinder installation.