Installing the Oracle Instant Client (Windows)

You use the Oracle Instant Client.

1. Log on to the application server as an administrator.
2. Download the 64-bit Instant Client Basic Package, SQL*Plus Package, and the Tools Package.
   For example:

   • instantclient-basic-windows.x64-19.9.0.0.0dbru.zip
   • instantclient-sqlplus-windows.x64-19.9.0.0.0dbru.zip
   • instantclient-tools-windows.x64-19.9.0.0.0dbru.zip
3. Create a new directory for the Oracle client home directory, ORACLE_HOME.
   For example:

   C:\oracle\

   The following steps use C:\oracle\. If you are using a different path, replace C:\oracle\ with your directory.

4. Expand the Instant Client packages into the same directory under C:\oracle\.
   You now have a C:\oracle\instantclient_19_9 directory.
5. Set the following environment variables:

   ORACLE_BASE=C:\oracle\instantclient_19_9
   ORACLE_HOME=C:\oracle\instantclient_19_9
   JAVA_HOME=<path_to_java_home>

   Append the following directory to the PATH environment variable:

   C:\oracle\instantclient_19_9

6. In the C:\oracle\instantclient_19_9 directory, create a \network\admin directory:
   You now have

   C:\oracle\instantclient_19_9\network\admin

7. Copy the tnsnames.ora file from the database server, update it, and then test the database connection.
   For more information, see Testing the connection to the OpenPages database from the Oracle database client.
8. Update property files with the new Oracle client directory, C:\oracle\instantclient_19_9.
   For more information, see Update database client paths in property files.

   Note: If you are doing a fresh installation of OpenPages, skip this step.
9. Repeat these steps on each application server.
10. Repeat these steps on each reporting server, with the following differences:
    • In step 5, set the environment variables by using the steps in Setting database environment variables for reporting servers on Windows operating systems.