linux sqlplus连接远程数据库,Linux sqlplus远程访问Oracle

2.安装OCI和OCI的SDK

在

;http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

需要下载：

oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm

oracle-instantclient11.2-basiclite-11.2.0.3.0-1.x86_64.rpm

oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm

;oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm

依次安装完成：

然后安装：aio

sudo apt-get install libaio-dev

配置环境变量

export ORACLE_HOME=/usr/lib/oracle/11.2/client64/bin

export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

export PATH=$PATH:$ORACLE_HOME

export TNS_ADMIN=$ORACLE_HOME

export NLS_LANG=american_america.AL32UTF8   //设置语言

在 TNS_ADMIN环境变量的目录下建立 tnsnames.ora文件

内容：

# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

TEST = 登陆的SID

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.21.163)(PORT = 1521)) IP地址和端口号

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl) 要链接数据库名

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

登陆：

sqlplus userShangLian1/shangLian@TEST