Thursday, April 23, 2009

ORACLE INSTANT CLIENT for LINUX

1. download instantclient from oracle website;
2. extract downloaded files to a directory. ex. /opt/oracle/
3. open .bash_profile add the following codes to the end

# ORACLE ENVIRONMENT SETTINGS.
ORACLE_HOME=/media/software/java/instantclient_11_1
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
TNS_ADMIN=$ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME

export ORACLE_HOME TNS_ADMIN NLS_LANG LD_LIBRARY_PATH

4. re-login.