Post Configuration for Oracle RAC Connection

Owned by Yeok Hong Ng (Deactivated)
Last updated: Oct 08, 2024 by Jenni Wallin
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 Global variable macro (Development). 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 the platform to make the changes take effect.