因為工作需要,需要使用ODBC訪問Oracle,下面是ODBC訪問Oracle的具體配置
1.下載unixODBC和Oracle簡易客戶端軟件包
1.1下載地址:
創(chuàng)新互聯(lián)長期為超過千家客戶提供的網(wǎng)站建設(shè)服務(wù),團隊從業(yè)經(jīng)驗10年,關(guān)注不同地域、不同群體,并針對不同對象提供差異化的產(chǎn)品和服務(wù);打造開放共贏平臺,與合作伙伴共同營造健康的互聯(lián)網(wǎng)生態(tài)環(huán)境。為民勤企業(yè)提供專業(yè)的網(wǎng)站設(shè)計制作、網(wǎng)站設(shè)計,民勤網(wǎng)站改版等技術(shù)服務(wù)。擁有十年豐富建站經(jīng)驗和眾多成功案例,為您定制開發(fā)。
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.zip instantclient-basic-linux.x64-12.2.0.1.0.zip instantclient-sdk-linux.x64-12.2.0.1.0.zip instantclient-jdbc-linux.x64-12.2.0.1.0.zip instantclient-odbc-linux.x64-12.2.0.1.0-2.zip instantclient-basiclite-linux.x64-12.2.0.1.0.zip instantclient-tools-linux.x64-12.2.0.1.0.zip
將這些軟件包上傳到/soft目錄
3.安裝unixODBC(root用戶)
#cd /soft #tar xvf unixODBC-2.3.0.tar.gz #cd /soft/unixODBC-2.3.0 #./configure #make #make install
(默認是被安裝到/usr/local)
4.安裝Oracle ODBC(root用戶)
#cd /soft/ #unzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip #unzip instantclient-basic-linux.x64-12.2.0.1.0.zip #unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip #unzip instantclient-jdbc-linux.x64-12.2.0.1.0.zip #unzip instantclient-odbc-linux.x64-12.2.0.1.0-2.zip #unzip instantclient-basiclite-linux.x64-12.2.0.1.0.zip #unzip instantclient-tools-linux.x64-12.2.0.1.0.zip
[root@dmks instantclient_12_2]# ./odbc_update_ini.sh /usr/local *** ODBCINI environment variable not set,defaulting it to HOME directory!
更新操作完成后,會在/usr/local/etc/odbcinst.ini增加Oracle12C的驅(qū)動描述信息。
[root@dmks etc]# cat odbcinst.ini [DM7 ODBC DRIVER] Description = ODBC DRIVER FOR DM7 Driver = /dm_home/dmdbms/bin/libdodbc.so [Oracle 12c ODBC driver] Description = Oracle ODBC driver for Oracle 12c Driver = /soft/instantclient_12_2/libsqora.so.12.1 Setup = FileUsage = CPTimeout = CPReuse =
并且會在HOME目錄下也就是/root,生成.odbc.ini文件,修改.odbc.ini文件
[root@dmks ~]# cat .odbc.ini [OracleODBC-12c] Application Attributes = T Attributes = W BatchAutocommitMode = IfAllSuccessful BindAsFLOAT = F CloseCursor = F DisableDPM = F DisableMTS = T Driver = Oracle 12c ODBC driver DSN = OracleODBC-12c EXECSchemaOpt = EXECSyntax = T Failover = T FailoverDelay = 10 FailoverRetryCount = 10 FetchBufferSize = 64000 ForceWCHAR = F Lobs = T Longs = T MaxLargeData = 0 MetadataIdDefault = F QueryTimeout = T ResultSets = T ServerName = shardcat 與tnsnames.ora文件中的服務(wù)器一致 SQLGetData extensions = F Translation DLL = Translation Option = 0 DisableRULEHint = T UserID = StatementCache=F CacheBufferSize=20 UseOCIDescribeAny=F SQLTranslateErrors=F MaxTokenSize=8192 AggregateSQLType=FLOAT
5.測試ODBC連接Oracle
[root@dmks ~]# isql OracleODBC-12c system xxzx7817600 -v +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select * from v$version; +---------------------------------------------------------------------------------+-----------------------------------------+ | BANNER | CON_ID | +---------------------------------------------------------------------------------+-----------------------------------------+ | Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production | 0 | | PL/SQL Release 12.2.0.1.0 - Production | 0 | | CORE 12.2.0.1.0 Production | 0 | TNS for Linux: Version 12.2.0.1.0 - Production | 0 | | NLSRTL Version 12.2.0.1.0 - Production | 0 | +---------------------------------------------------------------------------------+-----------------------------------------+
到此使用odbc連接Oracle的操作完成,還是很簡單的。
網(wǎng)站欄目:LinuxUseODBCConnectOracle
網(wǎng)站網(wǎng)址:http://muchs.cn/article20/pisjco.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供靜態(tài)網(wǎng)站、建站公司、關(guān)鍵詞優(yōu)化、網(wǎng)頁設(shè)計公司、電子商務(wù)、軟件開發(fā)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)