一、Oracle ODBC安装
[root@test01 oracle_soft]# rpm -ivh oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm \ oracle-instantclient12.2-odbc-12.2.0.1.0-2.x86_64.rpm
二、Oracle ODBC配置
1、配置TNS
[root@test01 oracle_soft]# cd /etc/oracle/
[root@test01 oracle]# ls
tnsnames.ora
[root@test01 oracle]# cat tnsnames.ora
PDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.40.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDB1)
)
)
2、配置环境变量
[root@test01 oracle]# vi /etc/profile ## 根据oracle实际情况添加如下环境变量信息
export TNS_ADMIN=/etc/oracle
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export ORCLE_SID=PDB1
export NLS