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

Supported Functions

The Oracle database can be used with:

• Audit Profile
• Database Collection/Forwarding Agents
• Event Notifications

Properties

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.

   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:

   $ kubectl cp ojdbc8.jar platform-0:/opt/mz/persistent/3pp -n <namespace>

4. Restart the platform and EC pods.

   $ kubectl delete pod platform-0 -n <namespace>

5. Restart the Desktop.