库文件格式不对的问题，急救!

jeanlove

我在hp-itanium(IA64)平台上面，使用Apache的都是PA-RISC 64的可执行文件，似乎可以无误的运行(完全兼容吗? 因为是客户的机器，必须只能用这种版本的Apache)。但是加上tomcat启动，通过本地的jsp相关代码连Oracle的时候出了问题。

虽然> ldd /appl/ROAM/www/Apache/bin/httpd
ldd: Invalid file type: "/appl/ROAM/www/Apache/bin/httpd". Shared executable or shared library expected.
但是apache/tomcat可以照常使用。

但是连oracle就出错了
。。。 。。。
org.apache.jasper.JasperException: /opt/app/oracle/product/9.2.0.6/lib/libocijdbc9.so: specified file is not a shared library, or a format error was detected.
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)


很奇怪，本地的oracle客户端是9206，有这个动态库文件，file命令显示出来的格式没有错啊，
>file /opt/app/oracle/product/9.2.0.6/lib/libocijdbc9.so
/opt/app/oracle/product/9.2.0.6/lib/libocijdbc9.so:     ELF-64 shared object file - IA64
>uname -a
HP-UX ordhpi27 B.11.23 U ia64 2531948031 unlimited-user license

为什么apache就不认这个库呢? 是不是需要设置什么特殊的环境变量(或者java?)什么的? 谢谢!!!!!!
----------------------------------------------------------------------------------------------
> env|grep ORACLE
ORACLE_SID=XXXXXXX
ORACLE_HOME=/opt/app/oracle/product/9.2.0.6

LD_LIBRARY_PATH=/usr/lib/pa20_64:/opt/app/oracle/product/9.2.0.6/libecho $SHLIB_PATH

CLASSPATH=/opt/java1.4/lib/tools.jar:/www/jakarta-tomcat.4.1.30/common/lib/servlet.jar:/www/jakarta-tomcat.4.1.30/common/lib/commons-fileupload-1.0.jar:/opt/app/oracle/product/9.2.0.6/jdbc/lib/classes12.zip:/opt/app/oracle/product/9.2.0.6/jdbc/lib/nls_charset12.zip

SHLIB_PATH=/opt/app/oracle/product/9.2.0.6/lib32:/usr/lib:/usr/lib/X11R4:/opt/app/oracle/product/9.2.0.6/lib:/usr/local/lib

JAVA_HOME:       /opt/java1.4
tomcat版本 jakarta-tomcat-4.1.30

cling6394

一般这种问题是执行权限导致的。

file命令只需要可读权限，不需要执行权限，不能说明所有问题。
你把liboci相关的库统统加上所有用户的执行权限看看... ...

ziggler

http://www.ibm.com/developerwork ... spa?threadID=142802

ziggler

Hi all:
This is a solved problem but I want to post it because it has produced me a lot of headache. My problem is related with WebSphere Process Server 6.0.2.3 and Oracle 9i. I made an installation with all datasources configured with JDBC Oracle Thin Driver.
In some cases I obtained the following error:
"
[11/16/06 17:04:41:411 CET] 0000000a ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adaptor for resource jdbc/WPSDB. The exception which was received is com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket
"
There is an article in IBM Support Website that helped me to identify the problem:
http://www-1.ibm.com/support/docview.wss?uid=swg21225859
"
Cause
The Oracle 9i 9.2.0.7 JDBC thin client driver has a restriction of a maximum of 4 KB for data, which is insufficient for the dynamic artifact repository.
Solution
Use the Oracle 9i OCI driver or upgrade the Oracle installation to 10g.
"
So I changed to OCI driver in the datasources that caused errors, and I obteined the following error:
"
java.sql.SQLException: java.lang.UnsatisfiedLinkError: /users/oracle

jeanlove

原帖由 ziggler 于 2009-3-24 15:47 发表
http://www.ibm.com/developerwork ... spa?threadID=142802

好像说的不是一个问题呀... ...

jeanlove

原帖由 cling6394 于 2009-3-24 16:42 发表
一般这种问题是执行权限导致的。

file命令只需要可读权限，不需要执行权限，不能说明所有问题。
你把liboci相关的库统统加上所有用户的执行权限看看... ...

解决!

brucewoo

不错,学习一下.