http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm
Configuring SQL*Plus Instant Client on Linux (from Client Media or Zip File) and UNIX
-
Add the name of the directory containing the Instant Client files to the appropriate shared library path LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH. Remove any other Oracle directories.
For example on Solaris in the Bourne or Korn shells:
LD_LIBRARY_PATH=/home/instantclient10_1:${LD_LIBRARY_PATH} export LD_LIBRARY_PATH
-
Add the directory containing the Instant Client files to the PATH environment variable. If it is not set, then an absolute or relative path must be used to start SQL*Plus. Remove any other Oracle directories from PATH. For example:
PATH=/home/instantclient10_1:${PATH} export PATH
-
Set SQLPATH to the directory containing the Instant Client files so glogin.sql can be found. For example:
SQLPATH=/home/instantclient10_1:${SQLPATH} export SQLPATH
-
Set Oracle globalization variables required for your locale. A default locale will be assumed if no variables are set. See the Oracle Database Globalization Support Guide for more information.
For example:
NLS_LANG=AMERICAN_AMERICA.UTF8 export NLS_LANG