Setting the Oracle environment variables for the database server (Windows)

After you install the Oracle database server software, you must set the Oracle environment variables on the OpenPages® database server computer.

Procedure

  1. Log on to the database server as a user with administrative privileges.
  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.

    ORACLE_HOME is the installation location or top-level directory structure for the database installation.

    For example: ORACLE_HOME=C:\app\Administrator\product\19.3.0\dbhome_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.

  8. Click OK.