Post Configuration for Oracle RAC Connection

The following steps are applicable when using Oracle RAC:

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)))'

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'
Restart platform to take effect the changes.