aths in/etc/ld.so.conf.
File libessupp_r.so in a directory in/etc/ld.so.conf.
File /usr/local/easysoft/lib/libessupp_r.soexists and is readable.
Looking for file libodbcinst.so in paths in/etc/ld.so.conf.
Looking for file libodbcinst.so in paths in/u02/app/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib:/usr/local/lib:/usr/local/lib:/usr/lib64.
File libodbcinst.so on path/u02/app/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib:/usr/local/lib:/usr/local/lib:/usr/lib64.
File /usr/lib64/libodbcinst.so exists andis readable.
File tnsnames.ora NOT on path/u02/app/oracle/product/11.2.0/db_1/network/admin:/etc.File .tnsnames.ora NOTon path /home/oracle.Could NOT find tnsnames.ora fileCannot continue tests -aborting.
--------------------
--------------------
Summary of findings:
--------------------
--------------------
1 : ERROR : File tnsnames.ora NOT on path/u02/app/oracle/product/11.2.0/db_1/network/admin:/etc.
2 : ERROR : File .tnsnames.ora NOT on path /home/oracle.
3 : ERROR : Could NOT find tnsnames.ora file
Check oracle client installed and configured. Does it work with
sqlplus.
4 : ERROR : Cannot continue tests - aborting.
Fix problems listed above and try again.
--这里的报警信息就是tnsnames.ora 的问题了。 我们用的是直接连接，忽略这个问题。
用isql 命令测试：
rac1:/usr/local/easysoft/oracle> isqlORACLE -v
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
--查询表：
SQL> select * from dave;
+----------------+---------------------+
| ID | NAME |
+----------------+---------------------+
| 1 | dave |
+----------------+---------------------+
SQLRowCount returns -1
1 rows fetched
说明：
Easysoft是收费的，这里只能试用。
在下载的时候选择购买，就可以看到easysoft for oracle driver的价格：一台机器要2800$, 也不便宜啊。
作者 David Dai -- Focus on Oracle
|