一、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、配置環(huán)境變量

[root@test01?oracle]#?vi?/etc/profile??##?根據(jù)oracle實(shí)際情況添加如下環(huán)境變量信息

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_LANG=AMERICAN_AMERICA.AL32UTF8??##?與oracle環(huán)境中的變量設(shè)置一致，解決中文亂碼問(wèn)題，不一致可能會(huì)導(dǎo)致中文亂碼

[root@test01?oracle]#?source?/etc/profile

3、配置ODBC文件

[root@test01?oracle]#?cat?/etc/odbcinst.ini??##?添加如下內(nèi)容

[Oracle]

Description?????=?Oracle?ODBC?driver?for?Oracle?12g

Driver??????????=?/usr/lib/oracle/12.2/client64/lib/libsqora.so.12.1

Setup???????????=

FileUsage???????=

CPTimeout???????=

CPReuse?????????=

AppUnicodeType??=?UTF8

ClientCharSet???=?UTF8

[root@test01?oracle]#?cat?/etc/odbc.ini???##?添加如下內(nèi)容

[oracle]

Driver??????=?Oracle

Server??????=?100.102.40.111

Port????????=?1521

ServerName??=?PDB1

AppUnicodeType??????????????=?UTF8

ClientCharSet???????????????=?UTF8

三、驗(yàn)證ODBC連接

[root@test01?oracle]#?isql?oracle?pubuser?123qwe

+---------------------------------------+

|?Connected!????????????????????????????|

|???????????????????????????????????????|

|?sql-statement?????????????????????????|

|?help?[tablename]??????????????????????|

|?quit??????????????????????????????????|

|???????????????????????????????????????|

+---------------------------------------+

SQL>

總結(jié)

以上是生活随笔為你收集整理的设置oracle odbc,Oracle ODBC配置的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。