java - oracle sql developer连接错误

Question

我无法使用 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 的设置中单击测试时，我得到以下日志:

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”(构建“1.8.0_11-b12”)
• Oracle Instant 位于/usr/lib/java 下。该目录在 SQL Developer 中设置(通过 Database > Advanced)
• Oracle 服务器已启动并使用默认参数 (localhost:7001) 运行，我可以访问 Web 管理控制台。
• Oracle 即时客户端版本: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 的库路径中。我只是不明白。我在这里错过了什么吗？我还能尝试什么来解决这个问题或至少进行更深入的调试？

Answer 1

我会告诉你我是如何解决的，最后...

我正在运行 OSX 10.9.4，通过 brew 安装了 jboss 7.1.1.Final，还有一个环境变量 JBOSS_HOME=/usr/local/opt/jboss-as/libexec.

我已经在 $JBOSS_HOME/modules/com/oracle/main 中有一个 ojdbc.jar，版本 11.2.0.3，所以我下载了 Instant Client 版本 11.2.0.3 .

我评论了任何使用即时客户端库填充 java.library.path 的 JAVA_OPTS，如下所示:

#JAVA_OPTS="$JAVA_OPTS -Djava.library.path=$JBOSS_HOME/instantclient_11_2"

为了方便起见，我在 $JBOSS_HOME 中复制了 instantclient_11_2。

这只是一个做的问题:

export DYLD_LIBRARY_PATH=$JBOSS_HOME/instantclient_11_2
$JBOSS_HOME/bin/standalone.sh

现在可以了。现在我有另一个问题要解决:

Native Library /usr/local/Cellar/jboss-as/7.1.1.Final/libexec/instantclient_11_2/libocijdbc11.dylib already loaded in another classloader