Installing the Oracle driver

Last Updated : May 19, 2022 |

To configure the POM database on Oracle, you must download the latest supported Oracle driver file from http://www.oracle.com and install the Oracle driver on the POM system.

Before installing the Oracle driver for POM, you must download and install the Oracle driver for Avaya Experience Portal. For more information about downloading and installing the Oracle driver for Avaya Experience Portal, see the following guides on the Support site at http://support.avaya.com:
  • Implementing Avaya Experience Portal on a single server

  • Implementing Avaya Experience Portal on multiple servers

  • Upgrading to Avaya Experience Portal

For installing the Oracle driver for POM, perform the following procedure:

Note:

If you have a multiple POM server environment, you must install the Oracle drivers on all auxiliary POM servers.

Before you begin

  1. Add at least one user with POM-specific privileges.

  2. Install the Oracle driver to configure the POM database schema on the Oracle database or to use the Oracle database as a contact data source.

Procedure

  1. Download the latest supported Oracle driver file from http://www.oracle.com.
  2. Log in to Linux on the EPM server as a user with root or sroot privileges.
  3. To create a folder ~/POMOracleJDBC, run the following command:

    mkdir —p ~/POMOracleJDBC

  4. Copy the downloaded driver files to the folder ~/POMOracleJDBC.
  5. To install the JDBC driver, type the following:

    bash $POM_HOME/bin/InstallPOMOracleJDBC.sh

    Important:

    Some web browsers change the file name extension of these files to .zip, when you download the files. Then rename the file to .jar.

    Keep the Oracle JDBC driver files in the folder ~/POMOracleJDBC even after installing or upgrading Avaya Experience Portal. You need these files when you install or upgrade POM.