Versions Compared

Key

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

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:

...

languagetext
themeEclipse

...

  1. Set

...

  1. up

...

  1. a

...

  1. persistent

...

  1. file

...

  1. system

...

  1. .

...



  1. Download

...

  1. the

...

  1. JDBC

...

  1. driver

...

  1. (ojdbc<version>.jar)

...

  1. for

...

  1. the

...

  1. appropriate

...

  1. Oracle

...

  1. database

...

  1. version.

...

  1. You

...

  1. can

...

  1. find

...

  1. it

...

  1. at

...

  1. Oracle.com.

...

  1. Info
    titleExample

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

...


  1. Copy

...

  1. the

...

  1. JDBC

...

  1. driver

...

  1. to

...

  1. the

...

  1. $MZ_HOME/persistent/3pp

...

  1. folder

...

  1. on

...

  1. the

...

  1. plaform-0

...

  1. pod.

...

  1. Example:

    Info
    titleExample - Copy the JDBC driver to the directory


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

...



  1. Restart the platform and EC pods.

    Info
    titleExample - Restart the platform and EC pods


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

...



  1. Restart

...

  1. the

...

  1. Desktop.