Page Comparison

The following steps are applicable when using Oracle RAC: 

Go to the "Oracle Database Software Downloads" web page: 
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html.
Find the Oracle database version 12 download links for your operating system. Click See All.
On the next page, search for "Oracle Database <version> Client” and click the link to download the zip file.

1. Unzip the file into an installation directory and install it by entering the command: ./runInstall
    
2. During installation, take extra notice to the following parts:
3. In the Available Product Components dialog, select "Oracle JDBC/THIN Interfaces" and "Oracle Connection Manager".
In the Perform Prerequisite Checks dialog, select Ignore All.

4. After a successful installation, go to the installation directory and enter the following commands to find the ons.jar and ojdbc<version>.jar files: 
   $ find . -name ons.jar
$ find . -name ojdbc*.jar 
 
5. Store ons.jar and ojdbc<version>.jar in a directory that is available on the Platform Container host.
   

   Run the the following command to install Oracle drivers and to configure the Oracle connection parameters:

   Code Block
   language text theme Eclipse
   $ ./setup.sh configure_oracle

   Note
   title Note!
   The above command asks for the user to input to the Oracle driver directory. It can also be passed as an argument by running the command as follows: ./setup.sh -Dmz.3pp.dir=/oracle/jdbc/driver/dir configure_oracle

   Set the url property of the standard service storage-dispatcherSet the Image Added JDBC URL property mz.jdbc.url.

   Code Block
   language text theme Eclipse
   mzsh topo set topo://services:standardcontainer:<platform container name>/pico:platform/val:storage-dispatcher.storage-dispatcher1.\ configconfig.properties.mz.jdbc.url \ "<jdbc connection string>"

   
   

   Info
   title Example - JDBC connection string
   Code Block language text theme Eclipse $ mzsh topo set topo://services:standardcontainer:main1/pico:platform/val:storage-dispatcher.storage-dispatcher1.\ config.url ' 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)))'

   
   

6. In order for Fast Connection Failover, FCF, to work, the ONS must be configured in the database as well as in Image Removed Image Added. This is done by setting the property mz.jdbc.oracle.ons in the storage-dispatcher service configurationthe 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
   language text theme Eclipse
   mzsh topo set topo://container:<platform container name>/pico:platform/val:config.properties.mz.jdbc.oracle.ons \ "<node list>"

   
   

   Info
   title Example - Setting mz.jdbc.oracle.ons
   Code Block $ mzsh topo set topo://container:main1/servicespico:standardplatform/val:storage-dispatcher.storage-dispatcher1.config.db-properties.mz.jdbc.oracle.ons \ ' nodes=10.0.0.85:6300,10.0.0.86:6300'

   
   

7. Restart platform to take effect the changes.