因为工作需要，需要使用ODBC访问Oracle，下面是ODBC访问Oracle的具体配置
1.下载unixODBC和Oracle简易客户端软件包
1.1下载地址：

http://www.unixodbc.org/

1.1.1下载文件：

unixODBC-2.3.0.tar.gz

2 Oracle ODBC Driver
2.1下载地址：

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

2.1.1下载文件:

instantclient-sqlplus-linux.x64-12.2.0.1.0.zipinstantclient-basic-linux.x64-12.2.0.1.0.zipinstantclient-sdk-linux.x64-12.2.0.1.0.zipinstantclient-jdbc-linux.x64-12.2.0.1.0.zipinstantclient-odbc-linux.x64-12.2.0.1.0-2.zipinstantclient-basiclite-linux.x64-12.2.0.1.0.zipinstantclient-tools-linux.x64-12.2.0.1.0.zip

将这些软件包上传到/soft目录

3.安装unixODBC(root用户)

#cd/soft#tarxvfunixODBC-2.3.0.tar.gz#cd/soft/unixODBC-2.3.0#./configure#make#makeinstall

(默认是被安装到/usr/local)

4.安装Oracle ODBC(root用户)

#cd/soft/#unzipinstantclient-sqlplus-linux.x64-12.2.0.1.0.zip#unzipinstantclient-basic-linux.x64-12.2.0.1.0.zip#unzipinstantclient-sdk-linux.x64-12.2.0.1.0.zip#unzipinstantclient-jdbc-linux.x64-12.2.0.1.0.zip#unzipinstantclient-odbc-linux.x64-12.2.0.1.0-2.zip#unzipinstantclient-basiclite-linux.x64-12.2.0.1.0.zip#unzipinstantclient-tools-linux.x64-12.2.0.1.0.zip

[root@dmksinstantclient_12_2]#./odbc_update_ini.sh/usr/local***ODBCINIenvironmentvariablenotset,defaultingittoHOMEdirectory!

更新操作完成后，会在/usr/local/etc/odbcinst.ini增加Oracle12C的驱动描述信息。

[root@dmksetc]#catodbcinst.ini[DM7ODBCDRIVER]Description=ODBCDRIVERFORDM7Driver=/dm_home/dmdbms/bin/libdodbc.so[Oracle12cODBCdriver]Description=OracleODBCdriverforOracle12cDriver=/soft/instantclient_12_2/libsqora.so.12.1Setup=FileUsage=CPTimeout=CPReuse=

并且会在HOME目录下也就是/root，生成.odbc.ini文件，修改.odbc.ini文件

[root@dmks~]#cat.odbc.ini[OracleODBC-12c]ApplicationAttributes=TAttributes=WBatchAutocommitMode=IfAllSuccessfulBindAsFLOAT=FCloseCursor=FDisableDPM=FDisableMTS=TDriver=Oracle12cODBCdriverDSN=OracleODBC-12cEXECSchemaOpt=EXECSyntax=TFailover=TFailoverDelay=10FailoverRetryCount=10FetchBufferSize=64000ForceWCHAR=FLobs=TLongs=TMaxLargeData=0MetadataIdDefault=FQueryTimeout=TResultSets=TServerName=shardcat与tnsnames.ora文件中的服务器一致SQLGetDataextensions=FTranslationDLL=TranslationOption=0DisableRULEHint=TUserID=StatementCache=FCacheBufferSize=20UseOCIDescribeAny=FSQLTranslateErrors=FMaxTokenSize=8192AggregateSQLType=FLOAT

5.测试ODBC连接Oracle

[root@dmks~]#isqlOracleODBC-12csystemxxzx7817600-v+---------------------------------------+|Connected!||||sql-statement||help[tablename]||quit|||+---------------------------------------+SQL>select*fromv$version;+---------------------------------------------------------------------------------+-----------------------------------------+|BANNER|CON_ID|+---------------------------------------------------------------------------------+-----------------------------------------+|OracleDatabase12cEnterpriseEditionRelease12.2.0.1.0-64bitProduction|0||PL/SQLRelease12.2.0.1.0-Production|0||CORE12.2.0.1.0Production|0|TNSforLinux:Version12.2.0.1.0-Production|0||NLSRTLVersion12.2.0.1.0-Production|0|+---------------------------------------------------------------------------------+-----------------------------------------+

到此使用odbc连接Oracle的操作完成，还是很简单的。