1、官网下载客户端安装文件
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
可下载zip也可下载rpm,我下载的rpm安装
2、依次安装 (命令举例如下:
rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
默认会装在/usr/lib/oracle
路径
3、创建数据连接文件
创建路径/usr/lib/oracle/11.2/client64/network/admin
创建文件tnsnames.ora(listener.ora、sqlnet.ora也可以从已安装ORACLE机器上拷贝过去修改)
映射到本服务的实例名 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 需要连接的数据库服务IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 需要连接的数据库实例名)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
4、配置环境变量
在用户家目录 vi .bash_profile 修改环境变量
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG='simplified chinese_china'.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
export PATH
source .bash_profile使环境变量生效
5、测试连接
sqlplus命令连接成功即可