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…..in

   We don't have a way to export this inline extension.
   . 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.