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

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 as a user with administrative privileges and full access to the local server drives..
  2. In the Windows search box, type environment variables, and then click Edit system environment variables.
  3. On the Advanced tab, click Environment variables.
  4. In the System Variables pane, click New.
  5. Add the ORACLE_HOME variable, then click OK.

    For example: ORACLE_HOME=C:\app\Administrator\product\19.0.0\client_1

  6. In the System Variables pane, select the PATH variable.
  7. Verify that %ORACLE_HOME%\bin is included in the PATH variable.

    If %ORACLE_HOME%\bin is not listed, click Edit, add %ORACLE_HOME%\bin to the start of the PATH variable, and then click OK.

    By default, the PATH variable includes the path %ORACLE_HOME%\bin after you install the Oracle database server software.