Linux下远程连接Oracle数据库

2014-11-24 18:14:24 · 作者: · 浏览: 0

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 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