DBD::Oracle 1.19 install on Fedora Core 5

Having problems with the install of DBD::Oracle 1.19 on
a Fedora Core 5 machine.

DBI 1.53 installed and the tests ran ok

I'm using the Oracle XE from the Oracle download
oracle-xe-10.2.0.1-1.0.i386.rpm

The error message from 'make test':


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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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.

I tried setting LD_LIBRARY_PATH and LD_RUN_PATH. That didn't change
anything. Here, see:

[root@w0ep DBD-Oracle-1.19]# env | grep LD
OLDPWD=/usr/local/src
LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0 /server/lib
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ser ver/lib

I tried building my own Perl 5.8.8, reinstalling DBI on that perl
and then trying DBD::Oracle with that perl, but it didn't help,
same error.

I'm doing all of this as root.

perl -V says:

Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=linux, osvers=2.6.9-34.elsmp,
archname=i386-linux-thread-multi
uname='linux hs20-bc2-4.build.redhat.com 2.6.9-34.elsmp #1 smp fri
feb 24 16:56:28 est 2006 i686 i686 i386 gnulinux '
config_args='-des -Doptimize=-O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
--param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic
-fasynchronous-unwind-tables -Dversion=5.8.8 -Dmyhostname=localhost
-Dperladmin=root@localhost -Dcc=gcc -Dcf_by=Red Hat, Inc.
-Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux
-Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads
-Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db
-Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio
-Dinstallusrbinperl=n -Ubincompat5005 -Uversiononly
-Dpager=/usr/bin/less -isr -Dd_gethostent_r_proto -Ud_endhostent_r_proto
-Ud_sethostent_r_proto -Ud_endprotoent_r_proto -Ud_setprotoent_r_proto
-Ud_endservent_r_proto -Ud_setservent_r_proto -Dinc_version_list=5.8.7
5.8.6 5.8.5 5.8.4 5.8.3 -Dscriptdir=/usr/bin'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing
-pipe -Wdeclaration-after-statement -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
optimize='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
-fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386
-mtune=generic -fasynchronous-unwind-tables',
cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -I/usr/include/gdbm'
ccversion='', gccversion='4.1.1 20060525 (Red Hat 4.1.1-1)',
gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lresolv -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread
-lc
perllibs=-lresolv -lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=/lib/libc-2.4.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version='2.4'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
-Wl,-rpath,/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE '
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP USE_ITHREADS USE_LARGE_FILES
USE_PERLIO USE_REENTRANT_API
Built under linux
Compiled at Jun 4 2006 19:34:41
@INC:
/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8
/usr/lib/perl5/site_perl/5.8.7
/usr/lib/perl5/site_perl/5.8.6
/usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8
/usr/lib/perl5/vendor_perl/5.8.7
/usr/lib/perl5/vendor_perl/5.8.6
/usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl
/usr/lib/perl5/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/5.8.8
.

Re: DBD::Oracle 1.19 install on Fedora Core 5

Same problem on another Fedora Core 5 machine.
Same problem with the multi-language version of Oracle XE.
Same problem with DBD::Oracle 1.18a and 1.17.

Could someone please give me a hint?



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.
>
> DBI 1.53 installed and the tests ran ok
>
> I'm using the Oracle XE from the Oracle download
> oracle-xe-10.2.0.1-1.0.i386.rpm
>
> The error message from 'make test':
>
>
> 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/Or acle.so' for
> module
> DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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.
>
> I tried setting LD_LIBRARY_PATH and LD_RUN_PATH. That didn't change
> anything. Here, see:
>
> [root@w0ep DBD-Oracle-1.19]# env | grep LD
> OLDPWD=/usr/local/src
> LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0 /server/lib
> LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ser ver/lib
>
> I tried building my own Perl 5.8.8, reinstalling DBI on that perl
> and then trying DBD::Oracle with that perl, but it didn't help,
> same error.
>
> I'm doing all of this as root.
>
> perl -V says:
>
> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
> Platform:
> osname=linux, osvers=2.6.9-34.elsmp,
> archname=i386-linux-thread-multi
> uname='linux hs20-bc2-4.build.redhat.com 2.6.9-34.elsmp #1 smp fri
> feb 24 16:56:28 est 2006 i686 i686 i386 gnulinux '
> config_args='-des -Doptimize=-O2 -g -pipe -Wall
> -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
> --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic
> -fasynchronous-unwind-tables -Dversion=5.8.8 -Dmyhostname=localhost
> -Dperladmin=root@localhost -Dcc=gcc -Dcf_by=Red Hat, Inc.
> -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux
> -Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads
> -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db
> -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio
> -Dinstallusrbinperl=n -Ubincompat5005 -Uversiononly
> -Dpager=/usr/bin/less -isr -Dd_gethostent_r_proto -Ud_endhostent_r_proto
> -Ud_sethostent_r_proto -Ud_endprotoent_r_proto -Ud_setprotoent_r_proto
> -Ud_endservent_r_proto -Ud_setservent_r_proto -Dinc_version_list=5.8.7
> 5.8.6 5.8.5 5.8.4 5.8.3 -Dscriptdir=/usr/bin'
> hint=recommended, useposix=true, d_sigaction=define
> usethreads=define use5005threads=undef useithreads=define
> usemultiplicity=define
> useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=undef
> usemymalloc=n, bincompat5005=undef
> Compiler:
> cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing
> -pipe -Wdeclaration-after-statement -I/usr/local/include
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
> optimize='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386
> -mtune=generic -fasynchronous-unwind-tables',
> cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe
> -Wdeclaration-after-statement -I/usr/local/include -I/usr/include/gdbm'
> ccversion='', gccversion='4.1.1 20060525 (Red Hat 4.1.1-1)',
> gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksize=8
> alignbytes=4, prototype=define
> Linker and Libraries:
> ld='gcc', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib
> libs=-lresolv -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread
> -lc
> perllibs=-lresolv -lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
> libc=/lib/libc-2.4.so, so=so, useshrplib=true, libperl=libperl.so
> gnulibc_version='2.4'
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
> -Wl,-rpath,/usr/lib/perl5/5.8.8/i386-linux-thread-multi/CORE '
> cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
> PERL_MALLOC_WRAP USE_ITHREADS USE_LARGE_FILES
> USE_PERLIO USE_REENTRANT_API
> Built under linux
> Compiled at Jun 4 2006 19:34:41
> @INC:
> /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.8
> /usr/lib/perl5/site_perl/5.8.7
> /usr/lib/perl5/site_perl/5.8.6
> /usr/lib/perl5/site_perl/5.8.5
> /usr/lib/perl5/site_perl/5.8.4
> /usr/lib/perl5/site_perl/5.8.3
> /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.8
> /usr/lib/perl5/vendor_perl/5.8.7
> /usr/lib/perl5/vendor_perl/5.8.6
> /usr/lib/perl5/vendor_perl/5.8.5
> /usr/lib/perl5/vendor_perl/5.8.4
> /usr/lib/perl5/vendor_perl/5.8.3
> /usr/lib/perl5/vendor_perl
> /usr/lib/perl5/5.8.8/i386-linux-thread-multi
> /usr/lib/perl5/5.8.8
> .
>
>
>
>

Re: DBD::Oracle 1.19 install on Fedora Core 5

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/de mo/demo_xe.mk
Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/demo_xe.mk
Looks like Oracle XE
(/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/d emo/demo_xe.mk)
Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/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/se rver/lib' in
environment
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ser ver/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/Dri ver.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/se rver/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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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/Or acle.so' for
module
DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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

Re: DBD::Oracle 1.19 install on Fedora Core 5

Chris Howard wrote:

> 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.
>>
>> DBI 1.53 installed and the tests ran ok
>>
>> I'm using the Oracle XE from the Oracle download
>> oracle-xe-10.2.0.1-1.0.i386.rpm
>>
>> The error message from 'make test':
>>
>>
>> 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/Or acle.so' for
>> module
>> DBD::Oracle: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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.
>>
>> I tried setting LD_LIBRARY_PATH and LD_RUN_PATH. That didn't change
>> anything. Here, see:
>>
>> [root@w0ep DBD-Oracle-1.19]# env | grep LD
>> OLDPWD=/usr/local/src
>> LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0 /server/lib
>> LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ser ver/lib
>>
>> I tried building my own Perl 5.8.8, reinstalling DBI on that perl
>> and then trying DBD::Oracle with that perl, but it didn't help,
>> same error.
>>
>> I'm doing all of this as root.
>>

Are you running SELinux?
i.e. in your /etc/sysconfig/selinux file does it say "SELINUX=enabled".
If so, try changing it to disabled, rebooting and run make test again.
If that fixes it and you still want to use SELinux you'll have to read
up about "chcon" command which I'm not really familiar with, I just saw
the same error with something else when SELinux was enabled.

Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

Re: DBD::Oracle 1.19 install on Fedora Core 5

Martin Evans wrote:
> Chris Howard wrote:
>
>> 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.
>>>
>>> DBI 1.53 installed and the tests ran ok
>>>
>>> I'm using the Oracle XE from the Oracle download
>>> oracle-xe-10.2.0.1-1.0.i386.rpm
>>>
>>> The error message from 'make test':
>>>
>>>
>>> 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/Or acle.so' for
>>> module
>>> DBD::Oracle:
>>> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libn nz10.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.
>>>
>>> I tried setting LD_LIBRARY_PATH and LD_RUN_PATH. That didn't change
>>> anything. Here, see:
>>>
>>> [root@w0ep DBD-Oracle-1.19]# env | grep LD
>>> OLDPWD=/usr/local/src
>>> LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0 /server/lib
>>> LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ser ver/lib
>>>
>>> I tried building my own Perl 5.8.8, reinstalling DBI on that perl
>>> and then trying DBD::Oracle with that perl, but it didn't help,
>>> same error.
>>>
>>> I'm doing all of this as root.
>>>
>
> Are you running SELinux?
> i.e. in your /etc/sysconfig/selinux file does it say "SELINUX=enabled".
> If so, try changing it to disabled, rebooting and run make test again.
> If that fixes it and you still want to use SELinux you'll have to read
> up about "chcon" command which I'm not really familiar with, I just saw
> the same error with something else when SELinux was enabled.
>
> Martin

Oops, the file might be /etc/security/selinux/src/policy on fedora 5. I
just read that as root, you might be able to execute "setenforce 0" to
disable SELinux until next reboot.

Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com