This section contains information that is specific to the database type Oracle.

...

When selecting the Oracle database type, you can configure the following properties using the Properties tab in the Database profile:

• oracle.pool.connectionwaittimeout
• oracle.pool.inactivitytimeout
• oracle.pool.maxlimit
• oracle.pool.minlimit
• oracle.pool.propertycheckinterval
• oracle.pool.refreshonsqlerror
• oracle.net.encryption_client
• oracle.net.encryption_types_client
• oracle.net.crypto_checksum_client
• oracle.net.crypto_checksum_types_client
  

Preparations

A database driver is required to connect to an Oracle database. This driver must be stored in the Platform. Follow these if Oracle was not set up during the installation of the Platform:

1. Set up a persistent file system.
   
   

2. Download the JDBC driver (ojdbc<version>.jar) for the appropriate Oracle database version. You can find it at Oracle.com.

   Info
   title Example
   https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

   
   

3. Copy the JDBC driver to the $MZ_HOME/persistent/3pp folder on the plaform-0 pod. Example:

   Info
   title Example - Copy the JDBC driver to the directory
   Code Block $ kubectl cp ojdbc8.jar platform-0:/opt/mz/persistent/3pp -n <namespace>

   
   

4. Restart the platform and EC pods.

   Info
   title Example - Restart the platform and EC pods
   Code Block $ kubectl delete pod platform-0 -n <namespace>

   
   

5. Restart the Desktop.