Installing the Oracle Instant Client (Linux®)

Applies to:

You can use the Oracle Instant Client.

Before you begin

Review the following topic to verify the requirements based on your installation path: Oracle Instant Client.

Ensure that the required users and groups are created. See Creating the user and group for application servers that use Oracle (Linux).

The libaio package is required. For more information, see the Oracle documentation.

Procedure

Log on to the application server.
Download the 64-bit Instant Client Basic Package, SQL*Plus Package, and the Tools Package.
For example:
- instantclient-basic-linux.64-19.9.0.0.0dbru.zip
- instantclient-sqlplus-linux.64-19.9.0.0.0dbru.zip
- instantclient-tools-linux.64-19.9.0.0.0dbru.zip
As the oracle user, create a new directory for the Oracle client home directory, ORACLE_HOME.
For example:
```
mkdir /home/oracle
```
The following steps use /home/oracle. If you are using a different path, replace /home/oracle with your directory.

Copy the Instant Client package files into the directory that you created in step 3, and then expand the files.

cd /home/oracle
unzip instantclient-basic-linux.x64-19.9.0.0.0dbru.zip    
unzip instantclient-sqlplus-linux.x64-19.9.0.0.0dbru.zip
unzip instantclient-tools-linux.x64-19.9.0.0.0dbru.zip

You now have a /home/oracle/instantclient_19_9 directory.

As opuser, set the following environment variables in the current shell and in the login profile.

ORACLE_BASE=/home/oracle/instantclient_19_9/
ORACLE_HOME=/home/oracle/instantclient_19_9/
LD_LIBRARY_PATH=$ORACLE_HOME
JAVA_HOME=<path_to_java_home>
PATH=$PATH:$ORACLE_HOME:$JAVA_HOME/bin
export ORACLE_BASE ORACLE_HOME PATH LD_LIBRARY_PATH JAVA_HOME

Important: Use the syntax and delimiters that are appropriate for the shell that you are using.

Create a /network/admin directory.

mkdir -p /home/oracle/instantclient_19_9/network/admin

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.
Create an sqlnet.ora file, if needed.
Update property files with the new Oracle client directory, /home/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 5, set the environment variables by using the steps in Setting database environment variables for the reporting server on Linux operating systems.

What to do next

See the following topic to determine your next task: Oracle Instant Client.