请教一个关于hp下DBD::Oracle安装的问题

请教一个关于hp下DBD::Oracle安装的问题

请教一个关于hp下DBD::Oracle安装的问题
perl版本:v5.8.3 built for PA-RISC1.1-thread-multi

下载DBD::Oracle版本:DBD-Oracle-1.19

安装过程:
perl Makefile.PL
==============================
Using DBI 1.54 (for perl 5.008003 on PA-RISC1.1-thread-multi) installed in /opt/perl_32/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.008003 on hpux (PA-RISC1.1-thread-multi)

Remember to actually *READ* the README file! Especially if you have any problems.

Using Oracle in /opt/oracle/app/product/9.2.0
DEFINE _SQLPLUS_RELEASE = "902000700" (CHAR)
Oracle version 9.2.0.7 (9.2)
Found /opt/oracle/app/product/9.2.0/rdbms/demo/demo_rdbms.mk
Found /opt/oracle/app/product/9.2.0/precomp/demo/proc/demo_proc.mk
Using /opt/oracle/app/product/9.2.0/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH/SHLIB_PATH env var is set to '/opt/oracle/app/product/9.2.0/lib32:/usr/local/lib:/usr/lib:/usr/dt/lib:.:/opt/oracle/app/product/9.2.0/lib32:/usr/local/lib:/usr/lib:/usr/dt/lib:.'
Reading /opt/oracle/app/product/9.2.0/rdbms/demo/demo_rdbms.mk
Reading /opt/oracle/app/product/9.2.0/rdbms/lib/env_rdbms.mk

Attempting to discover Oracle OCI build rules
cc -O -c DBD_ORA_OBJ.c
by executing: [make -f /opt/oracle/app/product/9.2.0/rdbms/demo/demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
[ true -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o build -L/opt/oracle/app/product/9.2.0/rdbms/lib/ -L/opt/oracle/app/product/9.2.0/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat /opt/oracle/app/product/9.2.0/lib/ldflags` `cat /opt/oracle/app/product/9.2.0/lib/sysliblist` -lm ]

WARNING: Stripped `cat /opt/oracle/app/product/9.2.0/lib32/sysliblist`
from link command, because it contains libraries not
compiled with +z or +Z (PIC) causing link to fail.
Furthermore, we should have already grabbed these libraries
Found header files in /opt/oracle/app/product/9.2.0/rdbms/public /opt/oracle/app/product/9.2.0/rdbms/demo.
WARNING: If you have trouble, see README.hpux.txt...
you may have to build your own perl, or go hunting for libraries
WARNING: If you have trouble, try perl Makefile.PL -l

Checking for functioning wait.ph


System: perl5.008003 hp-ux bertha b.11.00 u 9000800 136901587 unlimited-user license
Compiler: cc -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0 -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED +Z -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -lrt -lpthread -l:libnss_dns.1
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) $(OPTIMIZE) $(CDEBUG) +DA2.0W +DS2.0 -DSS_64BIT_SERVER -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/plsql/public -I/opt/oracle/app/product/9.2.0/network/public $(SPFLAGS) $(LPFLAGS) $(SHARED_CFLAG) $(USRFLAGS)]
LDFLAGS: -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o $@ -L$(PRODLIBHOME) -L$(LIBHOME)
[-Wl,+s -Wl,+n +DA2.0W +DS2.0 -o $@ -L/opt/oracle/app/product/9.2.0/rdbms/lib/ -L$(LIBHOME)]
Linking with OTHERLDFLAGS = -L/opt/oracle/app/product/9.2.0/rdbms/lib32/ -L/opt/oracle/app/product/9.2.0/lib32/ -lclntsh `cat /opt/oracle/app/product/9.2.0/lib32/ldflags` -lm [from 'build' rule]

Checking if your kit is complete...
Looks good
LD_RUN_PATH=/opt/oracle/app/product/9.2.0/lib32:/opt/oracle/app/product/9.2.0/rdbms/lib32
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.54 (for perl 5.008003 on PA-RISC1.1-thread-multi) installed in /opt/perl_32/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI/
Writing Makefile for DBD::Oracle
=================================
make
make
=================================
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /opt/perl_32/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /opt/perl_32/lib/5.8.3/ExtUtils/xsubpp -typemap /opt/perl_32/lib/5.8.3/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/plsql/public -I/opt/oracle/app/product/9.2.0/network/public -I/opt/perl_32/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED +Z -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0 -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" +Z "-I/opt/perl_32/lib/5.8.3/PA-RISC1.1-thread-multi/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.7\" Oracle.c
cc -c -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/plsql/public -I/opt/oracle/app/product/9.2.0/network/public -I/opt/perl_32/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED +Z -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0 -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" +Z "-I/opt/perl_32/lib/5.8.3/PA-RISC1.1-thread-multi/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.7\" dbdimp.c
cc -c -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/plsql/public -I/opt/oracle/app/product/9.2.0/network/public -I/opt/perl_32/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED +Z -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0 -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" +Z "-I/opt/perl_32/lib/5.8.3/PA-RISC1.1-thread-multi/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.7\" oci8.c
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
/usr/bin/ld +b "/opt/oracle/app/product/9.2.0/lib32:/opt/oracle/app/product/9.2.0/rdbms/lib32" -b +vnocompatwarnings Oracle.o dbdimp.o oci8.o -L/opt/oracle/app/product/9.2.0/rdbms/lib32/ -L/opt/oracle/app/product/9.2.0/lib32/ -lclntsh `cat /opt/oracle/app/product/9.2.0/lib32/ldflags` -lm -o blib/arch/auto/DBD/Oracle/Oracle.sl
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man3/DBD::Oraperl.3
====================================
make test
/usr/bin/perl /opt/perl_32/lib/5.8.3/ExtUtils/xsubpp -typemap /opt/perl_32/lib/5.8.3/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/demo -I/opt/oracle/app/product/9.2.0/rdbms/public -I/opt/oracle/app/product/9.2.0/plsql/public -I/opt/oracle/app/product/9.2.0/network/public -I/opt/perl_32/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI -D_POSIX_C_SOURCE=199506L -D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -DNO_HASH_SEED +Z -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fast +Onolimit +Opromote_indirect_calls +DAportable +DS2.0 -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" +Z "-I/opt/perl_32/lib/5.8.3/PA-RISC1.1-thread-multi/CORE" -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.7\" Oracle.c
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
/usr/bin/ld +b "/opt/oracle/app/product/9.2.0/lib32:/opt/oracle/app/product/9.2.0/rdbms/lib32" -b +vnocompatwarnings Oracle.o dbdimp.o oci8.o -L/opt/oracle/app/product/9.2.0/rdbms/lib32/ -L/opt/oracle/app/product/9.2.0/lib32/ -lclntsh `cat /opt/oracle/app/product/9.2.0/lib32/ldflags` -lm -o blib/arch/auto/DBD/Oracle/Oracle.sl
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.sl
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/10general.t line 18
Undefined subroutine &main::BAILOUT called at t/10general.t line 21.
# Looks like your test died before it could output anything.
t/10general.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-33
Failed 33/33 tests, 0.00% okay
t/15nls.................DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/15nls.t line 19
t/15nls.................ok
9/9 skipped: Unable to connect to Oracle (ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach))
t/20select..............Unable to connect to Oracle (ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach))
Tests skiped.
skipped
all skipped: no reason given
t/21nchar...............DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/22nchar_al32utf8......DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/22nchar_utf8..........DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db.............DBI connect('','scott/tiger',...) failed: ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db_8bit........DBI connect('','scott/tiger',...) failed: ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db_al32utf8....DBI connect('','scott/tiger',...) failed: ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/24implicit_utf8.......DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/25plsql...............Unable to connect to Oracle (ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach))
Tests skiped.
skipped
all skipped: no reason given
t/26exe_array...........ok 1/14DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/26exe_array.t line 28
# Looks like you planned 14 tests but only ran 1.
# Looks like your test died just after 1.
t/26exe_array...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-14
Failed 13/14 tests, 7.14% okay
t/30long................DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
Can't connect to database: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach)
# Looks like your test died before it could output anything.
t/30long................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-470
Failed 470/470 tests, 0.00% okay
t/31lob.................DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
You tried to plan twice! Second plan at t/31lob.t line 16
# Looks like your test died before it could output anything.
t/31lob.................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............DBI connect('','scott/tiger',...) failed: ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach) at t/40ph_type.t line 29
Unable to connect to Oracle (ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/50cursor..............Unable to connect to Oracle as scott/tiger (ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/55nested..............Unable to connect to Oracle as scott/tiger (ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................Unable to connect to Oracle as scott/tiger (ORA-12545: 因目标主机或对象不存在,连接失败 (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
Failed Test Stat Wstat Total Fail Failed List of Failed
-----------------------------------------------------------------------------------------------------------------------------------
t/10general.t 255 65280 33 66 200.00% 1-33
t/26exe_array.t 255 65280 14 26 185.71% 2-14
t/30long.t 255 65280 470 940 200.00% 1-470
t/31lob.t 255 65280 9 18 200.00% 1-9
14 tests and 9 subtests skipped.
Failed 4/20 test scripts, 80.00% okay. 525/540 subtests failed, 2.78% okay.
*** Error exit code 2

Stop.
===========================================
问一下这个test失败,问题在什么地方?怎么解决?
麻烦了!我的环境变量设置:
export ORACLE_BASE=/opt/oracle/app
export ORACLE_HOME=/opt/oracle/app/product/9.2.0
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=/usr/local/lib:/usr/lib:/usr/dt/lib:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
export SHLIB_PATH=/usr/local/lib:/usr/lib:/usr/dt/lib:.
export SHLIB_PATH=$ORACLE_HOME/lib32:$SHLIB_PATH
问题解决了
我用root安装,没有赋予目录别的用户的读写权限




   

也想知道,怎么没有人回复.
也想知道,怎么没有人回复。