CentOS安装Oracle11g客户端
1. 下载客户端rpm
需要有oracle的注册账号即可下载。
下载rpm文件,用root用户安装即可
rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm
不用安装oracle-instantclient11.2-basiclite-11.2.0.4.0-1.x86_64.rpm
,和oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm 冲突。
安装后,在 /usr/lib/oracle/11.2/client64 路径下有lib和bin目录。
2. 环境变量
vim /etc/profile
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export TNS_ADMIN=/usr/lib/oracle/11.2/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
export ORABIN=/usr/lib/oracle/11.2/client64/bin
export PATH=$PATH:$ORABIN
export PATH=$ORACLE_HOME:$PATH
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
编译 :
source /etc/profile
测试一下路径:
# echo $ORACLE_HOME
/usr/lib/oracle/11.2/client64
3. 配置监听TNS
创建监听network路径 ,编辑tns文件
mkdir -p /usr/lib/oracle/11.2/client64/network/admin/
vim /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora
tns文件格式,根据实际调整:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.64)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
Oracle数据库客户端环境安装完毕。
4. 连接数据库
可以看到使用11.2.0.4.0客户端,访问12.2.0.1.0 数据库。
# sqlplus scott/Tiger@orcl
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 24 22:45:48 2024
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>