Setting the Environment Variables for the Oracle Client

To complete the configuration of the Oracle client, you must set the environment variables.

For Linux systems, add the environment variables to the bash_profile file of the user.

Set the following environment variables.

ORACLE_HOME
JAVA_HOME
TNS_ADMIN (to be used if tnsnames.ora is not in the default location of $ORACLE_ HOME/network/admin)
LD_LIBRARY_PATH (or LIBPATH or SHLIB) must include $ORACLE_HOME/lib
NLS_LANG
PATH must include $ORACLE_HOME/bin

For example:

#export PATH
export ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0/client_1/
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export PATH=$ORACLE_HOME/bin:$PATH