===
==========
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 |