Versions Compared

Old Version 6

changes.mady.by.user Manuel Pereira

Saved on

compared with

New Version Current

changes.mady.by.user Kevin Wu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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