Post Configuration for Oracle RAC Connection

The following steps are applicable when using Oracle RAC: 

1. Set the  JDBC URL property mz.jdbc.url.

   mzsh topo set topo://container:<platform container name>/pico:platform/val:config.properties.mz.jdbc.url \
   "<jdbc connection string>"

   Example - JDBC connection string

   $ mzsh topo set topo://container:main1/pico:platform/val:config.properties.mz.jdbc.url \
   'jdbc:oracle:thin:@
   (description=(address_list=
   (address=(host=10.0.0.111)(protocol=tcp)(port=1521))
   (address=(host=10.0.0.112)(protocol=tcp)(port=1521))
   (load_balance=no))(connect_data=(service_name= orcl)))'

2. In order for Fast Connection Failover, FCF, to work, the ONS must be configured in the database as well as in . This is done by setting the property mz.jdbc.oracle.ons in the platform configuration properties. This property should contain the information found in the ONS configuration file ORACLE_HOME/opmn/conf/ons.config.

   The ONS string in the property must at least specify the node's ONS configuration attribute, that is, the host:port pairs preceded by the text "node=" and separated by a comma (,). The hosts and ports denote the remote ONS daemons available on the Oracle RAC nodes.
    

   mzsh topo set topo://container:<platform container name>/pico:platform/val:config.properties.mz.jdbc.oracle.ons \
   "<node list>"

   Example - Setting mz.jdbc.oracle.ons

   $ mzsh topo set topo://container:main1/pico:platform/val:config.properties.mz.jdbc.oracle.ons \
   'nodes=10.0.0.85:6300,10.0.0.86:6300'

3. Restart platform to take effect the changes.