Issues with DBD::Oracle(1.23/22) on Red Hat Enterprise Linux AS release 3 (Taroon Update 8)

[email protected] (Shibi NS) Thu, 1 Jul 2010 11:35:29 +0530

Newsgroups	perl.dbi.users
Message-ID	<[email protected]>

I am getting following error

while using DBB::Oracle

httpd: symbol lookup error: /nfs/private/user/sns/tech-stack/
10.06.28.03/linux/lib/perl5/site_perl/5.8.8/i686-linux-64int/auto/DBD/Oracle/Oracle.so:
undefined symbol: ora_sql_error
httpd: symbol lookup error: /nfs/private/user/sns/tech-stack/
10.06.28.03/linux/lib/perl5/site_perl/5.8.8/i686-linux-64int/auto/DBD/Oracle/Oracle.so:
undefined symbol: ora_db_commit

The OS is

% cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 8)


But the same works on machine with following Red Hat release

Red Hat Enterprise Linux AS release 3 (Taroon Update 8)

Server version: Apache/2.2.9 (Unix)

 perl is v5.8.8 built for i686-linux-64int

 mod_perl is 2.0.4

Oracle client and Server : 10.2.0.4.0

I have rebuilt Oracle Home/perl(with and without thread
enabled)/Apache/Mod_Perl

And it seems to be working from stand alone process and when called from
Apache child process we are getting undefined symbol error

I have attached log files of build , also perl Makefile.PL -s ora_db_commit
doesn't return me anything interesting

--Shibi Ns--

perl-V.txt (text/plain, 3 KB)

% perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
  Platform:
    osname=linux, osvers=2.4.21-47.0.1.6.2.elhugemem, archname=i686-linux-64int
    uname='linux ap6415isd 2.4.21-47.0.1.6.2.elhugemem #1 smp fri may 11 15:02:46 pdt 2007 i686 i686 i386 gnulinux '
    config_args='-de -Dprefix=/arudev/tech-stack/10.06.26.04/linux -Dmake=/usr/bin/make -Dotherlibdirs=/arudev/tech-stack/10.06.26.04/portable/lib/perl5 -Dbin=/arudev/tech-stack/10.06.26.04/linux/bin/ -Uinstallusrbinperl -Duse64bitint -Duselargefiles -Dstartperl=#!/arudev/tech-stack/dev/linux/bin/perl5.8.8 -Dinc_version_list=none -Dscriptdir=/arudev/tech-stack/10.06.26.04/linux/bin -Dsitebin=/arudev/tech-stack/10.06.26.04/linux/bin -Accflags=-DNO_HASH_SEED'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=define use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-DNO_HASH_SEED -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
    optimize='-O2',
    cppflags='-DNO_HASH_SEED -fno-strict-aliasing -pipe -I/usr/local/include -I/usr/include/gdbm'
    ccversion='', gccversion='2.96 20000731 (Red Hat Linux 7.3 2.96-128)', gccosandvers='linux7'
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=4, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib
    libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc
    perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
    libc=/lib/libc-2.3.2.so, so=so, useshrplib=false, libperl=libperl.a
    gnulibc_version='2.3.2'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
    cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Compile-time options: PERL_MALLOC_WRAP USE_64_BIT_INT USE_LARGE_FILES
                        USE_PERLIO
  Built under linux
  Compiled at May 20 2010 08:59:22
  %ENV:
    PERL5LIB="/m/isd/pm"
  @INC:
    /m/isd/pm
    /arudev/tech-stack/10.06.26.04/linux/lib/perl5/5.8.8/i686-linux-64int
    /arudev/tech-stack/10.06.26.04/linux/lib/perl5/5.8.8
    /arudev/tech-stack/10.06.26.04/linux/lib/perl5/site_perl/5.8.8/i686-linux-64int
    /arudev/tech-stack/10.06.26.04/linux/lib/perl5/site_perl/5.8.8
    /arudev/tech-stack/10.06.26.04/linux/lib/perl5/site_perl
    /arudev/tech-stack/10.06.26.04/portable/lib/perl5
    .
{ap6415isd:sns:sns_9840831_badfilename:ursdev01:10.2.0.4.0} /m/isd/log/isd_tech_stack_build.2010-06-30.12:43:04                                                                  %

DBD-Oracle.zip (application/zip, 4.6 KB) - not displayed