linux下远程连接oracle数据库

  • Post author:
  • Post category:linux


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



版权声明:本文为diana_cherry原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。