Setting the ORACLE_HOME environment variable on the OpenPages application servers (Linux®)

Applies to: On premises

Set up the ORACLE_HOME environment variable to point to the directory where the Oracle database client software is installed. Set the variable on the admin application server and each non-admin application server.

Procedure

  1. Log on to the application server. Log on as a non-root user, such as the opuser user that you created for the IBM OpenPages® installation.
  2. Open the user profile.
    For example:
    /home/<user>/.bash_profile

    Where <user> is the person who logs in to the operating system and creates the OpenPages installation, for example opuser.

  3. Set the ORACLE_HOME environment variable to point to the Oracle Admin Client installation directory.
    Important: Use the syntax and delimiters that are appropriate for the shell that you are using.

    For example:

    export ORACLE_HOME=/home/oracle/app/oracle/product/19.3.0/client_1
  4. Append the location of ORACLE_HOME/bin to the PATH environment variable.

    For example:

    export PATH=$ORACLE_HOME/bin:$PATH
  5. Refresh the profile.

    For example:

    . /home/opuser/.bash_profile