Oracle(3.2)

Owned by Jenni Wallin
Last updated: Jul 28, 2023 by Yeok Hong Ng (Deactivated)
1 min read

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:

    Example - Copy the JDBC driver to the directory

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

  4. Restart the platform and EC pods.

    Example - Restart the platform and EC pods

    $ kubectl delete pod platform-0 -n <namespace>
  5. Restart the Desktop.