Linux下遠端連線Oracle資料庫

1.安裝instantclient的相關包：

instantclient-basic-linux-x86-64-11.2.0.2.0.zip 基礎包

instantclient-sdk-linux-x86-64-11.2.0.2.0.zip 使用c或perl串連db

  instantclient-sqlplus-linux-x86-64-11.2.0.2.0.zip sqlplus

2.設定環境變數

export PATH=/home/loganalysis/perlM/instantclient/instantclient_11_2:$PATH

export Oracle_HOME=/home/loganalysis/perlM/instantclient/instantclient_11_2

export  LD_LIBRARY_PATH=/home/loganalysis/perlM/instantclient/instantclient_11_2

export  SQLPATH=/home/loganalysis/perlM/instantclient/instantclient_11_2:${SQLPATH}

export  TNS_ADMIN=/home/loganalysis/perlM/instantclient/instantclient_11_2:${TNS_ADMIN}

3.複製tnsnames.ora至/home/loganalysis/perlM/instantclient/instantclient_11_2