Installing the Oracle Instant Client (Windows)
You use the Oracle Instant Client. Fix pack 184.108.40.206 adds support for the Oracle Instant Client.
Before you begin
Review the following topic to verify the requirements based on your installation path: Oracle Instant Client.
Download and install the Visual Studio Redistributable from Microsoft. For example, Oracle Instant Client 19 requires the Visual Studio 2017 Redistributable. For more information, see the Oracle documentation.
- Log on to the application server as an administrator.
- Download the 64-bit Instant Client Basic Package, SQL*Plus Package, and the Tools
Package. For example:
- Create a new directory for the Oracle client home directory,
The following steps use C:\oracle\. If you are using a different path, replace C:\oracle\ with your directory.
- Expand the Instant Client packages into the same directory under
C:\oracle\. You now have a C:\oracle\instantclient_19_9 directory.
- In C:\oracle\instantclient_19_9, create a \bin
directory. You now have:
- 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.
- In C:\oracle\instantclient_19_9, create a
\jdbc\lib directory. You now have:
- Copy C:\oracle\instantclient_19_9\ojdbc8.jar to the C:\oracle\instantclient_19_9\jdbc\lib directory.
- 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
- In the C:\oracle\instantclient_19_9 directory, create a
\network\admin directory: You now have
- 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.
- 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.
- Repeat these steps on each application server.
- 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.