Chinaunix

标题: 提示can't load文件，可是文件存在，各位帮忙看看哪里出了问题？ [打印本页]

作者: liwd1977 时间: 2010-08-09 10:58
标题: 提示can't load文件，可是文件存在，各位帮忙看看哪里出了问题？
错误提示：
Connect to DB:nios35 using driver Oracle ...... install_driver(Oracle) failed: Can't load '/opt/dc_perl/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: No such file or directory at /opt/dc_perl/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm line 229, <RF> line 26.
at (eval 11) line 3
Compilation failed in require at (eval 11) line 3, <RF> line 26.
Perhaps a required shared library or dll isn't installed where expected
at /opt/BOCO.Common/DB/lib/MDBI2.pm line 156

环境变量：
mc-nms-v4-/opt/BOCO.NPM/DB> env
HOME=/opt/BOCO.NPM/DB
PATH=/opt/dc_perl/bin:/usr/sbin:/usr/j2se/bin:/usr/bin:/usr/ucb:/usr/ccs/bin:/etc:/usr/local/bin:/opt/informix/bin:/opt/oracle/product/9i/bin:.
LOGNAME=npmuser
HZ=100
TERM=vt100
TZ=PRC
SHELL=/bin/csh
MAIL=/var/mail/npmuser
LANG=zh
_INIT_NET_STRATEGY=none
_INIT_PREV_LEVEL=S
_INIT_RUN_LEVEL=3
_INIT_RUN_NPREV=0
_INIT_UTS_ISA=sparc
_INIT_UTS_MACHINE=sun4u
_INIT_UTS_NODENAME=mc-nms-v4
_INIT_UTS_PLATFORM=SUNW,Sun-Fire-880
_INIT_UTS_RELEASE=5.8
_INIT_UTS_SYSNAME=SunOS
_INIT_UTS_VERSION=Generic_117000-03
PWD=/opt/BOCO.NPM/DB
USER=npmuser
ODBCHOME=/opt/ODBC
ODBCINI=/opt/BOCO.UDPP/DB/.odbc.ini
INFORMIXSERVER=niosserver
INFORMIXDIR=/opt/informix
EDITOR=vi
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/9i
ORACLE_SID=mcnms
NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280
NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
DB_COMMON=/opt/BOCO.Common/DB
DB_PATH=/opt/BOCO.NPM/DB
DB_COMMON_BIN=/opt/BOCO.Common/DB/bin
DB_COMMON_LIB=/opt/BOCO.UDPP/DB/lib
DB_UDPP_LIB=/opt/BOCO.UDPP/BOCO.Common/DB/lib
PERL5LIB=/opt/BOCO.DAL/NPM/common/modules:/opt/BOCO.UDPP/DB/lib:/opt/dc_perl/lib:/opt/dc_perl/lib/site_perl/5.8.3:/opt/dc_perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi:/opt/dc_perl/lib/5.8.3:/opt/dc_perl/lib/5.8.3/sun4-solaris-thread-multi:/opt/BOCO.Common/DB/lib:/opt/BOCO.NPM/DB/lib:/opt/BOCO.UDPP/DB/lib:/opt/BOCO.UDPP/BOCO.Common/DB/lib:/opt/BOCO.NPM/DB/ReportSum/bin/Prj_remain_alarm_pwd
LD_LIBRARY_PATH=/usr/local/lib:/opt/ODBC/lib:/usr/lib:/opt/informix/lib:/opt/dc_perl/lib/5.8.3:/opt/dc_perl/lib/site_perl/5.8.3:/opt/ODBC/lib:/opt/oracle.client/lib32:/opt/oracle.client/lib:/opt/oracle/product/10g/lib32:/opt/mqm/lib:/opt/oracle/product/9i/lib
MQSERVER=CH1/TCP/10.0.2.74(1414)
MQCCSID=1383
LD_RUN_PATH=/opt/oracle/product/9i/lib

数据库连接没有问题：
sqlplus user/pass@sid
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 9 11:00:14 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

文件是存在的：

ls -l /opt/dc_perl/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBD/Oracle/Oracle.so

-rwxrwxrwx 1 root    sys       651920 Sep 17  2009 /opt/dc_perl/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto/DBD/Oracle/Oracle.so

ls -l /opt/dc_perl/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm
-rwxrwxrwx 1 informix sys       26441 Nov 16  2007 /opt/dc_perl/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/DynaLoader.pm

那么请问，我的问题出在哪里呢？

作者: wind_ch 时间: 2010-08-09 11:09
"Compilation failed in require at (eval 11) line 3, <RF> line 26.
Perhaps a required shared library or dll isn't installed where expected
at /opt/BOCO.Common/DB/lib/MDBI2.pm line 156"

懷疑是路徑問題

作者: liwd1977 时间: 2010-08-09 11:12
谢谢，我也怀疑路径有问题，但是尝试了几个路径，没找到哪里有问题，能不能帮忙找找到底哪里出错了

作者: yybmsrs 时间: 2010-08-09 11:16
环境变量是5.8.3，你ls的是5.8.8

作者: liwd1977 时间: 2010-08-09 11:18
重贴一下以下三个环境变量的值
PERL5LIB=/opt/BOCO.Common/DB/lib:/opt/BOCO.NPM/DB/lib:/opt/dc_perl/lib/site_perl/5.8.8:/opt/dc_perl/lib/5.8.8:/opt/dc_perl/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi-LP64
LD_LIBRARY_PATH=LD_LIBRARY_PATH=/usr/openwin/lib:/usr/lib:/usr/local/lib:/usr/platform/SUNW,SPARC-Enterprise/lib/:/opt/SUNWspro/lib:/opt/ODBC/lib:/opt/informix/lib:/opt/informix/lib/csm:/opt/informix/lib:/opt/informix/lib/esql:/opt/informix/lib/cli:/opt/informix/lib/client/csm:/opt/informix/lib/dmi:/opt/informix/lib/c++:/opt/mqm/lib:/opt/BOCO.NPM/DB/msg_sender:/opt/info73sdk/lib:/opt/info73sdk/lib/esql:/opt/oracle/OraHome_1/lib:/opt/oracle/OraHome_1/lib32:/usr/lib:/usr/local/lib:/opt/dc_mysql/lib:/opt/ODBC/lib:/informix/info/lib:/informix/info/lib/esql:/opt/informix/cli/dlls:/opt/oracle/lib:/opt/sybase.client/lib:/opt/info73sdk/cli/sybase/dlls:/opt/dc_perl/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/CORE:/opt/dc_perl/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto
SHLIB_PATH=/opt/oracle/OraHome_1/lib:/opt/oracle/OraHome_1/lib32:/usr/lib:/usr/local/lib:/opt/dc_mysql/lib:/opt/ODBC/lib:/informix/info/lib:/informix/info/lib/esql:/opt/informix/cli/dlls:/opt/oracle/lib:/opt/sybase.client/lib:/opt/info73sdk/cli/sybase/dlls:/opt/dc_perl/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/CORE:/opt/dc_perl/lib/5.8.8/IA64.ARCHREV_0-thread-multi-LP64/auto

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)