LLI Wiki — My Digital Knowledge Base

Oracle: client environment variables on Windows and Linux

Environment variables, clean-up steps and ODBC drivers to check before installing an Oracle Instant Client on Windows, with the Linux equivalent.

Environment variables and clean-up to check before installing an Oracle client (Instant Client or full client) on Windows, with the Linux equivalents.

Windows

Clean up a previous installation

Before a reinstall, check these locations for leftover Oracle components:

Environment variables

Variable Value (example: Instant Client 11.2 installed in C:\Oracle)
PATH Append the client folder: %PATH%;C:\Oracle\instantclient_11_2
ORACLE_HOME C:\Oracle\instantclient_11_2
ORACLE_SID <SID>, the instance you connect to
TNS_ADMIN Folder that contains tnsnames.ora, here C:\Oracle\instantclient_11_2

ODBC drivers

Check the installed ODBC drivers in these registry keys:

Linux

export ORACLE_HOME=/opt${USER}/instantclient_19_14
export LD_LIBRARY_PATH="$ORACLE_HOME":$LD_LIBRARY_PATH
export PATH=$LD_LIBRARY_PATH:$PATH
export TNS_ADMIN=/home/${USER}/instantclient_19_14/network/admin

ORACLE_HOME points to the client folder, LD_LIBRARY_PATH lets the dynamic loader find the client libraries, and TNS_ADMIN points to the folder that contains tnsnames.ora.

Notes

Mastodon LLIMastodon SocialFosstodon