Sorry I did forget to include that I am working with 1.27. I checked the oci.def and OCIPing is in it. I am very perplexed as this same install worked fine on another node.
From: John Scoles [mailto:byter...@hotmail.com] Sent: Wednesday, May 25, 2011 4:57 PM To: Williams, Stephen; dbi-usin...@perl.org Subject: RE: AIX 5.3 DBD::Oracle issues Like the error message says "OCIPing" is not present in you Oracle.so file. Can be cured a number of ways. 1) check and see if OCIPing is in the OCI.def file of the version of DBD::Oracel you have installed. 2) If it is not there add it and reinstall If the above does not work try a version of DBD::Oracle lower than 1.25 or a newer version like 1.27+ You did not say which version of DBD::oracle you were using. cheers John > From: stephen.willi...@twcable.com > To: dbi-usin...@perl.org<mailto:dbi-usin...@perl.org> > Date: Wed, 25 May 2011 16:04:37 -0400 > Subject: AIX 5.3 DBD::Oracle issues > > Afternoon all! I have installed a standalone install of Perl and > DBI/DBD::Oracle on my AIX 5.3 TL9 SP7 I have this working fine on two boxes > but on one I keep getting the below error when I try a simple test > connection. Has anyone seen this or know what may be wrong? I have been > searching for an answer but have yet to turn anything up. > > ./foo > install_driver(Oracle) failed: Can't load > '/product/cvc/perl5.12.3_64bit/lib/site_perl/5.12.3/aix-thread-multi-64all/auto/DBD/Oracle/Oracle.so' > for module DBD::Oracle: rtld: 0712-001 Symbol OCIPing was referenced > from module > /product/cvc/perl5.12.3_64bit/lib/site_perl/5.12.3/aix-thread-multi-64all/auto/DBD/Oracle/Oracle.so(), > but a runtime definition > of the symbol was not found. > rtld: 0712-002 fatal error: exiting. at > /product/cvc/perl5.12.3_64bit/lib/5.12.3/aix-thread-multi-64all/DynaLoader.pm > line 200. > 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 ./foo line 10 > > Perl configuration > > /product/cvc/perl/bin/perl -V > Summary of my perl5 (revision 5 version 12 subversion 3) configuration: > > Platform: > osname=aix, osvers=5.3.0.0, archname=aix-thread-multi-64all > uname='aix cvcpstg01 3 5 00c510fc4c00 ' > config_args='-d -Dcc=gcc -Duseshrplib -Dusethreads -Duse64bitall > -Dprefix=/product/cvc/perl5.12.3_64bit -s' > hint=recommended, useposix=true, d_sigaction=define > useithreads=define, usemultiplicity=define > useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef > use64bitint=define, use64bitall=define, uselongdouble=undef > usemymalloc=n, bincompat5005=undef > Compiler: > cc='gcc -maix64', ccflags ='-D_THREAD_SAFE -D_ALL_SOURCE -D_ANSI_C_SOURCE > -D_POSIX_SOURCE -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -fno-strict-aliasing > -pipe -maix64 -DUSE_64_BIT_ALL', > optimize='-O', > cppflags='-D_THREAD_SAFE -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE > -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -fno-strict-aliasing -pipe' > ccversion='', gccversion='4.2.0', gccosandvers='' > intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8 > ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', > lseeksize=8 > alignbytes=8, prototype=define > Linker and Libraries: > ld='gcc -maix64', ldflags =' -Wl,-brtl -Wl,-bdynamic -L/usr/local/lib > -Wl,-b64' > libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib > libs=-lbind -lnsl -ldbm -ldl -lld -lm -lcrypt -lpthreads -lc > perllibs=-lbind -lnsl -ldl -lld -lm -lcrypt -lpthreads -lc > libc=/lib/libc.a, so=a, useshrplib=true, libperl=libperl.a > gnulibc_version='' > Dynamic Linking: > dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Xlinker > -bE:/product/cvc/perl5.12.3_64bit/lib/5.12.3/aix-thread-multi-64all/CORE/perl.exp' > cccdlflags=' ', lddlflags=' -Wl,-b64 -Wl,-bhalt:4 -Wl,-G > -Wl,-bI:$(PERL_INC)/perl.exp -Wl,-bE:$(BASEEXT).exp -Wl,-bnoentry -lpthreads > -lc -lm -L/usr/local/lib' > > > Characteristics of this binary (from libperl): > Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV > PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_64_BIT_ALL > USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES > USE_PERLIO USE_PERL_ATOF USE_REENTRANT_API > Built under aix > Compiled at May 25 2011 15:17:56 > @INC: > /product/cvc/perl5.12.3_64bit/lib/site_perl/5.12.3/aix-thread-multi-64all > /product/cvc/perl5.12.3_64bit/lib/site_perl/5.12.3 > /product/cvc/perl5.12.3_64bit/lib/5.12.3/aix-thread-multi-64all > /product/cvc/perl5.12.3_64bit/lib/5.12.3 > > Thanks, > -Stephen > > ________________________________ > This E-mail and any of its attachments may contain Time Warner Cable > proprietary information, which is privileged, confidential, or subject to > copyright belonging to Time Warner Cable. This E-mail is intended solely for > the use of the individual or entity to which it is addressed. If you are not > the intended recipient of this E-mail, you are hereby notified that any > dissemination, distribution, copying, or action taken in relation to the > contents of and attachments to this E-mail is strictly prohibited and may be > unlawful. If you have received this E-mail in error, please notify the sender > immediately and permanently delete the original and any copy of this E-mail > and any printout.