Linux平台配置OracleODBCDSN的方法.docx

) ) Linux 平台配置 Oracle ODBC DSN 的方法 1 DSN配置方法(Oracle) 1.1 编辑配置文件 一． OS RHEL5 X86 ( Oracle Database 11g software, version 11.1.0.7.0 二． UnixODBC unixODBC-2.3.0 三． Oracle oracle-instantclient11.2-basic-11.2.0.1.0-1.i386.rpm oracle-instantclient11.2-odbc-11.2.0.1.0-1.i386.rpm 安装路径： /usr/lib/oracle/11.2/client/lib/ 四.DSN配置 [Oracle_Driver]DescriptionDriverSetup [Oracle_Driver] Description Driver Setup FileUsage = odbc for Oracle = /usr/lib/libsqora.so.11.1 = /usr/lib/liboraodbcS.so -2 . /etc/odbc.ini [dsn_ora] = Oracle_Driver = Oracle_Driver = 192.168.11.209 = 1521 = ORCL = usr1 =-3 .创建TNS文件 #mkdir - p /usr/lib/oracle/11.2/network/admin #cd /usr/lib/oracle/11.2/network/admin #touch tnsnames.ora ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.11.209) (PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) -4 .环境变量 #export TNS_ADMIN=/usr/lib/oracle/11.2/network/admin -5 .测试连接 # isql dsn_ora - v [root@vmdbsrv02 share]# isql dsn_ora -v TOC \o 1-5 \h \z + + | Conn ected! | | | | sql-stateme nt | | help [table name] | | quit | | | + + SQL 图形化配置参考  rootKmdbsr^02 qt2]U cat /etc/odbcinst- ini .oracii 巴」 De^:nipt ion Dr iver Driver64 Set up Setup64 Llsa^eC cunt OPT i rrfedu^ CPReLEe =oracle driver =/usr/l b/oracle/11.2/cl ient/ll ib/l ibeqora.so.11. 3 /usr/lib =/usi / 1 ib/l iboraodbdS.sc =/usr/l ib [wl 击 rv「] Dcscrii pt ion Driver Driver64 Setur* Set叮趣4 Usa^eOcunt CPTimeout CPReuce _ sqlserver driver -Zusr/1ocalysq1seryer/eas =/usr/l ib =/us 1 oca 11rr?ea￡ysof t/sq1eerr/1 i b/1 i besec1s rvS.so -/usr/lib 二 [root8vm(fcsrv02 qt2]# | /etc/odbci nst. ini L root Svmcbs rv02 qt2]lt cat /tooini [myoraele] Descri pt i on 二 orac le Driver =oracle DB 二 dbl USER 二 rool PASSWORD 二 roct 0RACLE.H0ME 二 TNS_ADMIN - [root@\4ndbsrv02 qt2]R odbc.i ni