Installing the Oracle Instant Client (Windows)

You use the Oracle Instant Client. Fix pack 8.2.0.2 adds support for 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. In C:\oracle\instantclient_19_9, create a \bin directory.
   You now have:

   C:\oracle\instantclient_19_9\bin

6. Copy the contents of C:\oracle\instantclient_19_9 to C:\oracle\instantclient_19_9\bin.
   Ensure that you copy the files. Do not cut and paste them.
7. In C:\oracle\instantclient_19_9, create a \jdbc\lib directory.
   You now have:

   C:\oracle\instantclient_19_9\jdbc\lib

8. Copy C:\oracle\instantclient_19_9\ojdbc8.jar to the C:\oracle\instantclient_19_9\jdbc\lib directory.
9. 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\bin

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

    C:\oracle\instantclient_19_9\network\admin

11. 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.
12. 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.
13. Repeat these steps on each application server.
14. Repeat these steps on each reporting server, with the following differences:
    • In step 2, use the 32-bit client packages.
    • In step 9, set the environment variables by using the steps in Setting database environment variables for reporting servers on Windows operating systems.
    • After step 12, restart the Reporting Framework Generator service. See Starting and stopping the OpenPages with Watson Framework Model Generator service on Windows.