我无法使用SQL Developer获得与Oracle WebLogic 12c的连接 . 这是我点击连接时收到的错误:
An error was encountered performing the requested operation:
/usr/lib/java/libocijdbc11.dylib: dlopen(/usr/lib/java/libocijdbc11.dylib, 1): Library not loaded: /ade/b/2475221476/oracle/rdbms/lib/libclntsh.dylib.11.1
Referenced from: /usr/lib/java/libocijdbc11.dylib
Reason: image not found
Vendor code 0
当我在SQL Developer的Settings中单击Test时,我得到以下日志:
Testing the Instant Client located at /usr/lib/java
Testing client directory ... OK
Testing loading Oracle JDBC driver ... OK
Testing checking Oracle JDBC driver version ... OK
Driver version: 11.2.0.3.0
Testing testing native OCI library load ... Failed:
Error loading the native OCI library
The native OCI driver could not be loaded. The system propertyjava.library.path
contains the entries from the environment variable DYLD_LIBRARY_PATH.
Check it to verify that the expected native library
directory /usr/lib/java is present and precedes any other client installations.
java.library.path = /Users/gasim/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.
以下是我的设置概述:
-
操作系统:OSX Mavericks(10.9.4具体)
-
Java SE运行时版本:"1.8.0"(build "1.8.0_11-b12")
-
Oracle Instant位于/ usr / lib / java下 . 该目录在SQL Developer中设置(通过数据库>高级)
-
Oracle服务器启动并运行默认参数(localhost:7001),我可以访问Web管理控制台 .
-
Oracle Instant Client版本:11.2.0.4.0
-
java.library.path = / Users / gasim / Library / Java / Extensions:/ Library / Java / Extensions:/ Network / Library / Java / Extensions:/ System / Library / Java / Extensions:/ usr / lib / java: .
/usr/lib/java
的目录列表:
BASIC_README
adrci
genezi
libclntsh.dylib.11.1
libnnz11.dylib
libocci.dylib.11.1
libociei.dylib
libocijdbc11.dylib
ojdbc5.jar
ojdbc6.jar
uidrvci
xstreams.jar
问题是, libocijdbc11.dylib
确实存在于/ usr / lib / java中,该目录位于java的库路径中 . 我只是不明白 . 我在这里错过了什么吗?我还可以尝试解决这个问题或者至少进行更深入的调试?
1 回答
我会告诉你我是如何解决的,最后......
我正在运行OSX 10.9.4,通过
brew
安装了jboss 7.1.1.Final,以及一个env变量JBOSS_HOME=/usr/local/opt/jboss-as/libexec
.我已经在
$JBOSS_HOME/modules/com/oracle/main
,版本11.2.0.3中有ojdbc.jar
,因此我下载了Instant Client版本11.2.0.3 .我评论了任何使用instantclient库填充
java.library.path
的JAVA_OPTS,如下所示:为了舒服,我复制了
instantclient_11_2
在$JBOSS_HOME
内 .这只是一件事:
它现在有效 . 现在我有另一个问题需要解决: