On Wed, 2007-02-21 at 07:57 -0700, Chris Howard wrote:
> Having problems with the install of DBD::Oracle 1.19 on
> a Fedora Core 5 machine.
sqlplus works fine
I really don't know where to go next.
I've got a project that is being held up while
I'm trying to get this to work.
Here is the output of
perl Makefile.PL
make
make test
------------------------------------------------------------------
Using DBI 1.53 (for perl 5.008008 on i686-linux) installed
in /usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on linux (i686-linux)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Looks like Oracle XE
(/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk)
Reading
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib'
Checking for functioning wait.ph
System: perl5.008008 linux w0ep.yipyap.com 2.6.17-1.2174_fc5 #1 tue aug
8 15:30:55 edt 2006 i686 i686 i386 gnulinux
Compiler: cc -O2 -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
Linker: /usr/bin/ld
Sysliblist: -ldl -lm -lpthread -lnsl -lirc
Oracle makefiles would have used these definitions but we override them:
CC: /usr/bin/g++296
LDFLAGS: -g
[-g]
Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/
-lclntsh -lpthread
WARNING: If you have problems you may need to rebuild perl with
threading enabled.
Checking if your kit is complete...
Looks good
Ignoring
LD_RUN_PATH='/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib' in
environment
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.53 (for perl 5.008008 on i686-linux) installed
in /usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help.txt
files.
(Of course, you have read README by now anyway, haven't you?)
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/local/bin/perl -p -e
"s/~DRIVER~/Oracle/g"
/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI/Driver.xst > Oracle.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp
-typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap
Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/
-DLINUX -D_GNU_SOURCE -D_REENTRANT -g -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=\"1.19\"
-DXS_VERSION=\"1.19\" -fpic
"-I/usr/local/lib/perl5/5.8.8/i686-linux/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
cc -c -I/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/
-DLINUX -D_GNU_SOURCE -D_REENTRANT -g -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=\"1.19\"
-DXS_VERSION=\"1.19\" -fpic
"-I/usr/local/lib/perl5/5.8.8/i686-linux/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c
dbdimp.c: In function ‘dbd_rebind_ph_char’:
dbdimp.c:1110: warning: value computed is not used
dbdimp.c: In function ‘ora_st_execute_array’:
dbdimp.c:1985: warning: value computed is not used
cc -c -I/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/
-DLINUX -D_GNU_SOURCE -D_REENTRANT -g -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=\"1.19\"
-DXS_VERSION=\"1.19\" -fpic
"-I/usr/local/lib/perl5/5.8.8/i686-linux/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
oci8.c: In function ‘fetch_func_rset’:
oci8.c:652: warning: value computed is not used
oci8.c: In function ‘dbd_rebind_ph_lob’:
oci8.c:748: warning: value computed is not used
oci8.c:779: warning: value computed is not used
oci8.c: In function ‘post_execute_lobs’:
oci8.c:2246: warning: value computed is not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib" cc
-shared -L/usr/local/lib Oracle.o dbdimp.o oci8.o -o
blib/arch/auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/ -lclntsh
-lpthread \
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/local/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/local/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
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................Failed to load Oracle extension and/or shared
libraries:
install_driver(Oracle) failed: Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/01base.t line 19
The remaining tests will probably also fail with the same error.
*** Please read the README and README.help.txt files for help. ***
FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/10general.............install_driver(Oracle) failed: Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/src/DBD-Oracle-1.19/blib/lib/Oraperl.pm line 55
Compilation failed in require at t/10general.t line 6.
BEGIN failed--compilation aborted at t/10general.t line 6.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/15nls.................Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/nchar_test_lib.pl line 6
Compilation failed in require at t/nchar_test_lib.pl line 6.
BEGIN failed--compilation aborted at t/nchar_test_lib.pl line 6.
Compilation failed in require at t/15nls.t line 9.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/20select..............Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/20select.t line 4
Compilation failed in require at t/20select.t line 4.
BEGIN failed--compilation aborted at t/20select.t line 4.
dubious
Test returned status 2 (wstat 512, 0x200)
t/21nchar...............Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/21nchar.t line 12
Compilation failed in require at t/21nchar.t line 12.
BEGIN failed--compilation aborted at t/21nchar.t line 12.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/22nchar_al32utf8......Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/22nchar_al32utf8.t line 9
Compilation failed in require at t/22nchar_al32utf8.t line 9.
BEGIN failed--compilation aborted at t/22nchar_al32utf8.t line 9.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/22nchar_utf8..........Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/22nchar_utf8.t line 9
Compilation failed in require at t/22nchar_utf8.t line 9.
BEGIN failed--compilation aborted at t/22nchar_utf8.t line 9.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/23wide_db.............Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/23wide_db.t line 9
Compilation failed in require at t/23wide_db.t line 9.
BEGIN failed--compilation aborted at t/23wide_db.t line 9.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/23wide_db_8bit........Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/23wide_db_8bit.t line 9
Compilation failed in require at t/23wide_db_8bit.t line 9.
BEGIN failed--compilation aborted at t/23wide_db_8bit.t line 9.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/23wide_db_al32utf8....Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/23wide_db_al32utf8.t line 9
Compilation failed in require at t/23wide_db_al32utf8.t line 9.
BEGIN failed--compilation aborted at t/23wide_db_al32utf8.t line 9.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/24implicit_utf8.......Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/24implicit_utf8.t line 12
Compilation failed in require at t/24implicit_utf8.t line 12.
BEGIN failed--compilation aborted at t/24implicit_utf8.t line 12.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/25plsql...............Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/25plsql.t line 17
Compilation failed in require at t/25plsql.t line 17.
BEGIN failed--compilation aborted at t/25plsql.t line 17.
dubious
Test returned status 2 (wstat 512, 0x200)
t/26exe_array...........Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/26exe_array.t line 4
Compilation failed in require at t/26exe_array.t line 4.
BEGIN failed--compilation aborted at t/26exe_array.t line 4.
dubious
Test returned status 2 (wstat 512, 0x200)
t/30long................Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/30long.t line 5
Compilation failed in require at t/30long.t line 5.
BEGIN failed--compilation aborted at t/30long.t line 5.
dubious
Test returned status 2 (wstat 512, 0x200)
t/31lob.................Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/31lob.t line 5
Compilation failed in require at t/31lob.t line 5.
BEGIN failed--compilation aborted at t/31lob.t line 5.
# Looks like your test died before it could output anything.
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/40ph_type.t line 18
Compilation failed in require at t/40ph_type.t line 18.
BEGIN failed--compilation aborted at t/40ph_type.t line 18.
dubious
Test returned status 2 (wstat 512, 0x200)
t/50cursor..............Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/50cursor.t line 18
Compilation failed in require at t/50cursor.t line 18.
BEGIN failed--compilation aborted at t/50cursor.t line 18.
dubious
Test returned status 2 (wstat 512, 0x200)
t/55nested..............Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/55nested.t line 17
Compilation failed in require at t/55nested.t line 17.
BEGIN failed--compilation aborted at t/55nested.t line 17.
dubious
Test returned status 2 (wstat 512, 0x200)
t/60reauth..............Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/nchar_test_lib.pl line 6
Compilation failed in require at t/nchar_test_lib.pl line 6.
BEGIN failed--compilation aborted at t/nchar_test_lib.pl line 6.
Compilation failed in require at t/60reauth.t line 18.
dubious
Test returned status 2 (wstat 512, 0x200)
t/70meta................Can't load
'/usr/local/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for
module
DBD::Oracle:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot
restore segment prot after reloc: Permission denied at
/usr/local/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.
at t/nchar_test_lib.pl line 6
Compilation failed in require at t/nchar_test_lib.pl line 6.
BEGIN failed--compilation aborted at t/nchar_test_lib.pl line 6.
Compilation failed in require at t/70meta.t line 21.
dubious
Test returned status 2 (wstat 512, 0x200)
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/01base.t 5 2 40.00% 4-5
t/10general.t 255 65280 ?? ?? % ??
t/15nls.t 255 65280 ?? ?? % ??
t/20select.t 2 512 ?? ?? % ??
t/21nchar.t 255 65280 ?? ?? % ??
t/22nchar_al32utf8.t 255 65280 ?? ?? % ??
t/22nchar_utf8.t 255 65280 ?? ?? % ??
t/23wide_db.t 255 65280 ?? ?? % ??
t/23wide_db_8bit.t 255 65280 ?? ?? % ??
t/23wide_db_al32utf8.t 255 65280 ?? ?? % ??
t/24implicit_utf8.t 255 65280 ?? ?? % ??
t/25plsql.t 2 512 ?? ?? % ??
t/26exe_array.t 2 512 ?? ?? % ??
t/30long.t 2 512 ?? ?? % ??
t/31lob.t 255 65280 9 18 200.00% 1-9
t/40ph_type.t 2 512 ?? ?? % ??
t/50cursor.t 2 512 ?? ?? % ??
t/55nested.t 2 512 ?? ?? % ??
t/60reauth.t 2 512 ?? ?? % ??
t/70meta.t 2 512 ?? ?? % ??
Failed 20/20 test scripts, 0.00% okay. 11/14 subtests failed, 21.43%
okay.
make: *** [test_dynamic] Error 2
