Page Comparison

...

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

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

   Example - JDBC connection string

   Code Block
   $ 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

   We don't have a way to export this inline extension.

   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.
    

   Code Block
   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

   Code Block
   $ 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.