ããä¸ãä¸è½½å®è£
å
ããhttp //www unixodbc.org/
ããä¸è½½æ件ï¼unixODBC-2.3.4.tar.gz
ããOracle ODBC Driver
ããhttp //www oracle.com/technetwork/topics/linuxx86-64soft-092277.html
ããï¼æ ¹æ®ç³»ç»éæ±è¿oracleå®ç½ä¸è½½ç¸åºçæ¬ï¼
ããä¸è½½æ件ï¼
ããoracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
ããoracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
ããoracle-instantclient12.1-odbc-12.1.0.2.0-1.x86_64.rpm
ããoracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
ããäºã å®è£
ãã1ã å®è£
unixODBC
ãã以rootç身份è¿è¡ï¼
ããtar âzxvf unixODBC-2.3.4.tar.gz
ããcd unixODBC-2.3.4
ãã./configure --prefix=/usr/local/unixODBC-2.3.4 --includedir=/usr/include --libdir=/usr/lib --bindir=/usr/bin --sysconfdir=/etc
ããmake
ããmake install
ããå®è£
æååï¼unixODBCæéç头æ件é½è¢«å®è£
å°äº/usr/inlucdeä¸ï¼ç¼è¯å¥½çåºæ件å®è£
å°äº/usr/libä¸ï¼ä¸unixODBCç¸å
³çå¯æ§è¡æ件å®è£
å°äº/usr/binä¸ï¼é
ç½®æ件æ¾å°äº/etcä¸ã
ãã2ã å®è£
æ°æ®åºODBC驱å¨
ããå¨ubuntuä¸ç¨alienï¼å¨centosä¸ç¨rpmå®è£
oracleçå个å
ã
ããè¿å
¥oracleçå®è£
ç®å½ï¼/usr/lib/x64/oracle/ï¼
ããchmod 775 odbc_update_ini.sh
ãã./odbc_update_ini.sh /etc(没ææ示表示å®è£
æå)
ããå
¶ä¸ï¼odbc_update_ini.shåæ°è¯´æï¼
ããåæ°1ï¼unixODBCå®è£
è·¯å¾ã
ããåæ°2ï¼é©±å¨å®è£
çç»å¯¹è·¯å¾ï¼å¯éï¼ã
ããé»è®¤ä¸ºè¿è¡èæ¬çè·¯å¾ã
ããåæ°3ï¼é©±å¨åï¼å¯éï¼ï¼é»è®¤ä¸ºOracle 11g ODBC driverã
ããåæ°4ï¼æ°æ®æºå称ï¼å¯éï¼ã
ããè¿è¡å®æåå°æ·»å ä¸ä¸ªDNSæ¡ç®å°$HOME/.odbc.ini ,/etc/odbcinst.ini,å称为ï¼OracleODBC-11g
ããä¸ã 设置ç¯å¢åé
ããexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/x64/oracle/instantclient_11_2:/usr/local/lib
ããPATH=$PATH:/usr/local/bin
ããTNS_ADMIN(å¦æå®è£
æoracle软件é£ä¹å¯¹åºçå°±æ¯$ORACLE_HOME/network/admin/ç®å½ï¼å¦æ没æå®è£
ç¸åºoracle软件ï¼éè¦æå®tnsnames.oraæå¨çç®å½ï¼å¯é)
ããNLS_LANG(设å®åéçå符éï¼å¯é)
ããLANG(ç³»ç»å符ç¼ç ï¼å¯é)
ãã/etc/profile (注æåé¢çè±æå¥å·ï¼ç¹å·åé¢æç©ºæ ¼) å°ç¯å¢åé注å.
ããä¸è¬æ¥è¯´ï¼å¨centoséé¢ä½ å¯ä»¥éè¿å¨/etc/ld.so.conf.d/ç®å½ä¸å»ºä¸ä¸ªæ°æ件æ¥å®ç°
ããæ件çååæ¯xxxx.confï¼æ¯å¦oracleinstantclient.conf
ããéé¢çå
容就æ¯ç®å½ï¼æ¯å¦/usr/local/libï¼å¯åèå
¶ä»æ件
ãã建好åï¼è¿è¡ldconfigï¼å°±å¯ä»¥ældæ°é
ç½®è£
è½½è¿ç³»ç»äº
ããåã é
ç½®æ¬å°æå¡åï¼tnsnames.oraï¼
ããæç¯å¢åéä¸TNS_ADMINç设置ç®å½ï¼æ·»å æ¬å°æå¡åï¼$TNS_ADMIN/tnsnames.oraæ$ORACLE_HOME/network/admin/tnsnames.ora
ããä¾å¦ï¼TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = test) ) )
ãã注ï¼æ¤å¤HOST为æè¿æ¥çipå°åï¼PORT为端å£å·
ããäºã æ£æ¥é©±å¨é
ç½®
ããvi /etc/odbcinst.ini å¨å
¶ä¸æ·»å oracle驱å¨ï¼å¦
ãã[Oracle 11g ODBC driver]
ããDescription = Oracle ODBC driver for Oracle 11g
ããDriver = /root/instantclient_11_2/libsqora.so.10.1
ããSetup =File
ããUsage =
ããCPTimeout =
ããCPReuse =
ããå
ã æ·»å oracle odbcé
ç½®(oracleç¨æ·)
ããvi ~/.odbc.ini
ãã[OracleODBC-10g]
ããApplication Attributes = T
ããAttributes = W
ããBatchAutocommitMode = IfAllSuccessful
ããBindAsFLOAT = F
ããCloseCursor = F
ããDisableDPM = F
ããDisableMTS = T
ããDriver = Oracle 11g ODBC driver #对åº/usr/local/etc/odbcinst.iniä¸ç驱å¨é
ç½®å称
ããDSN = OracleODBC-11g
ããEXECSchemaOpt =
ããEXECSyntax = T
ããFailover = T
ããFailoverDelay = 10
ããFailoverRetryCount = 10
ããFetchBufferSize = 64000
ããForceWCHAR = F
ããLobs = T
ããLongs = T
ããMetadataId
ããDefault = F
ããQueryTimeout = T
ããResultSets = T
ããServerName =TEST #对åºtnsnames.oraä¸é
ç½®çæ¬å°æå¡åSQLGetData extensions = F
ããTranslation DLL =
ããTranslation ption = 0
ããDisableRULEHint = T
ããUserID =
ããä¸ã æµè¯
ããç¨å½ä»¤ï¼isql<æ°æ®æºå称> <ç¨æ·å> <å¯ç > -v
ãã[root@dwj~]$ isql OracleODBC-11g system oracle -v+---------------------------------------+|Connected! || ||sql-statement || help[tablename] ||quit || |+---------------------------------------+
温馨提示:内容为网友见解,仅供参考