linux（CentOS7.6）安装ORACLE客户端

下载客户端软件

官网下载

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

百度云下载

oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm 提取码：yit2
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm 提取码：evhk
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm 提取码：v7io

上传安装包

[root@mydb_master ~]# rz

安装

[root@mydb_master ~]# rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
[root@mydb_master ~]# rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
[root@mydb_master ~]# rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

默认装到了 /usr/lib/oracle/11.2/client64 下面。

配置用户的环境变量

[root@mydb_master ~]# su - gpadmin
[gpadmin@mydb_master ~]$ vim .bash_profile
export ORACLE_BASE=/usr/lib/oracle
export ORACLE_HOME=$ORACLE_BASE/11.2/client64
export PATH=$ORACLE_HOME/bin:/usr/lib/oracle:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export SQLPATH=/usr/lib/oracle
export TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
[gpadmin@mydb_master admin]$ source ~/.bash_profile

配置tnsnames.ora文件

[gpadmin@mydb_master ~]$ exit
[root@mydb_master ~]# cd /usr/lib/oracle/11.2/client64
[root@mydb_master client64]# mkdir -p network/admin
[root@mydb_master client64]# cd network/admin
[root@mydb_master admin]# touch tnsnames.ora
[root@mydb_master admin]# vim tnsnames.ora
APP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 81.70.208.91)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = app)
    )
  )

配置libs

[root@mydb_master admin]# vi /etc/ld.so.conf
include ld.so.conf.d/*.conf
/usr/lib/oracle/11.2/client64/lib/
[root@mydb_master admin]# ldconfig

切换用户登录远程数据库

[root@mydb_master admin]# su - gpadmin
[gpadmin@mydb_master ~]$ sqlplus64
SQL*Plus: Release 11.2.0.4.0 Production on Thu Feb 25 17:49:08 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter user-name: tool/tool@app

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

参考文章

Linux中安装使用Oracle 11g客户端步骤