设为首页 加入收藏

TOP

Linux配置unixODBC访问Oracle说明(四)
2014-11-24 08:06:47 来源: 作者: 【 】 浏览:9
Tags:Linux 配置 unixODBC 访问 Oracle 说明
===
==========

Congratulations. You have now completed theinstallation of the Easysoft
ODBC-Oracle Driver.

The full manual is available as a PDF orHTML from:
ftp://ftp.easysoft.com/pub/docs/oracle

and in /usr/local/easysoft/oracle/doc.

The HTML version of the manual is availableonline at:
http://www.easysoft.com/products/data_access/odbc_oracle_driver

NOTE:
If you installed this software as anon-root user you need to:
1. set the EASYSOFT_ROOT environmentvariable to
/usr/local/easysoft.
2. Set up your dynamic linker search pathto include
/usr/local/easysoft/lib
/usr/local/easysoft/unixODBC/lib


切换到oracle 用户,在~/.bashrc中添加如下环境变量:
exportLD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export SHLIB_PATH=/usr/local/easysoft/lib
export LIBPATH=/usr/local/easysoft/lib

--source 使修改生效:
rac1:/home/oracle> source ~/.bashrc


三.配置unixODBC 连接Oracle

3.1 修改/etc/odbcinst.ini 文件

[root@rac1odbc-oracle-3.3.0-linux-x86-64-ul64]# cat /etc/odbcinst.ini
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbc.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbc.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1

[ORACLE]
Description=Easysoft ODBC Oracle Driver
Driver=/usr/local/easysoft/oracle/libesoracle.so
Setup=/usr/local/easysoft/oracle/libesoraclesetup.so
DontDLClose=1
FileUsage=1
UsageCount=2
--最后一部分是我们在安装时配置的。


3.2 修改/etc/odbc.ini文件

[root@rac1odbc-oracle-3.3.0-linux-x86-64-ul64]# cat /etc/odbc.ini
[ORACLE]
Driver=ORACLE
Database=//192.168.3.116:1521/DAVE
User=system
Password=oracle
METADATA_ID=0
ENABLE_USER_CATALOG=1
ENABLE_SYNONYMS=1


--测试:
[root@rac1 ~]# cd /usr/local/easysoft/oracle
[root@rac1 oracle]# ./checksys -d ORACLE
./checksys: error while loading sharedlibraries: libodbcinst.so.1: cannot open shared object file: No such file ordirectory

这里报错,查看一下:
[root@rac1 lib64]# pwd
/usr/lib64
[root@rac1 lib64]# ls libodbcinst.so*
libodbcinst.so libodbcinst.so.2 libodbcinst.so.2.0.0
[root@rac1lib64]# ll libodbcinst.so*
lrwxrwxrwx. 1 root root 20 Mar 4 16:17 libodbcinst.so -> libodbcinst.so.2.0.0
lrwxrwxrwx. 1 root root 20 Mar 4 16:17 libodbcinst.so.2 -> libodbcinst.so.2.0.0
-rwxr-xr-x. 1 root root 68928 Jul 9 2010libodbcinst.so.2.0.0

确实没有,我们手工link一下:
[root@rac1 lib64]# ln -s libodbcinst.so libodbcinst.so.1

--之前是用root用户来检测的,其实正确的应该是用Oracle 的安装用户来验证:
rac1:/usr/local/easysoft/oracle>./checksys -d ORACLE
started on Sun Mar 4 20:11:55 2012
./checksys -d ORACLE Using /home/oracle ashome directory.

Checking ORACLE_HOME....
ORACLE_HOME set to/u02/app/oracle/product/11.2.0/db_1.

Checking LD_LIBRARY_PATH....
LD_LIBRARY_PATH set to/u02/app/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib:/usr/local/lib:/usr/local/lib:/usr/lib64.

Directory"/u02/app/oracle/product/11.2.0/db_1" exists.
Looking for file libeslicshr_r.so in pathsin /etc/ld.so.conf.
File libeslicshr_r.so in a directory in/etc/ld.so.conf.
File /usr/local/easysoft/lib/libeslicshr_r.soexists and is readable.

Looking for file libessupp_r.so in p
首页 上一页 1 2 3 4 下一页 尾页 4/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle通过游标方式删除所有以NO.. 下一篇一套Oracle SQL练习题及答案

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·C 内存管理 | 菜鸟教 (2025-12-26 20:20:37)
·如何在 C 语言函数中 (2025-12-26 20:20:34)
·国际音标 [ç] (2025-12-26 20:20:31)
·微服务 Spring Boot (2025-12-26 18:20:10)
·如何调整 Redis 内存 (2025-12-26 18:20:07)