Post Configuration for Oracle RAC Connection

Owned by Kevin Wu
Last updated: May 30, 2024
1 min read

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 the Platform. 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

  3. Restart platform to take effect the changes.