Linux下远程连接Oracle数据库

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