Oracle Connection

Owned by Yeok Hong Ng (Deactivated)
Last updated: May 22, 2024 by Jenni Wallin
1 min read

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

  1. Go to the Oracle JDBC driver download page: 
    https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

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

  3. Store the JDBC driver in a directory that is available on the Platform Container host, 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. The jdbc driver has performance using /dev/urandom. 

Â