Versions Compared

Old Version 1

changes.mady.by.user Jenni Wallin

Saved on

compared with

New Version Current

changes.mady.by.user Yeok Hong Ng (Deactivated)

Saved on

Key

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

...

...

...

...

...

...

...

...


Warning

Currently the Oracle Database JDBC drivers 21c and 23c are not supported.

Using ojdbc8.jar/ojdbc11.jar from Oracle Database JDBC 21c or 23c will result in installation errors.

You are required to use the ojdbc8.jar/ojdbc10.jar in Oracle Database JDBC driver 19c or older to avoid any installation errors.


The following steps are applicable when using an Oracle database. For configuration of Oracle RAC, skip to 3.8.3 Oracle RAC Connection.

  1. Go to the Oracle JDBC driver download page: 
    httphttps://www.oracle.com/technetworkdatabase/databasetechnologies/featuresappdev/jdbc/index-091264downloads.html.

  2. Download the JDBC driver (ojdbc<version>.jar) for Oracle database version 12.1. This driver also works with Oracle database version 11.2.that is compatible with the supported JDK version.

  3. Store the JDBC driver in a 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
    languagetext
    themeEclipse
    $ ./setup.sh configure_oracle
    Note
    titleNote!

    The above command will ask 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, such as mz.3pp.dir. For more information, see 3pp Properties.


If you are using Oracle 12, it is recommended that you set the property jvmargs.args to -Djava.security.egd=file:///dev/urandom for all pico instances that are expected to open connections towards Oracle. This is because the  The jdbc driver has changes which have better performance using /dev/urandom.