Resolution:
Description:
============
Required for making EMS work with a Oracle database store using an OCI driver.

Environment:
===========
All

Resolution:
==========
Under Linux:

1). export ORACLE_HOME = &ltPATH_TO_ORACLE_CLIENT_HOME>

2). If using instant client, set the following environment variable. (If an Oracle full client is installed on the local machine, then this step is unnecessary).

export TNS_ADMIN = &ltPATH_TO_instanceClient_HOME>

3). Create and Edit the tnsnames.ora file.

With instant client, create the tnsnames.ora file in the directory of the instant client. With a full client installation, the tnsnames.ora file is located at $ORACLE_HOME/lib/network/admin directory.

You can include the export variable statements in the shell profile file, (e.g., ~/.bash_profile) so that those variables are automatically defined when you open the terminal session.

Generally, the same steps are follwed for Windows. You will need to define the corresponding environment variables.  (Right click on Computer  -> Advanced system settings -> Advanced tab -> Environment Variables)

What configuration is required to make EMS work with a Oracle database store using an OCI driver.