Well in that case bounce back to 1.25 which does not use OCIPing and you should
be ok.
Also check which oracle client versions are on both boxes Credits to Navy Beans
that they are different.
Cheers
John
> From: stephen.willi...@twcable.com
> To: dbi-users@perl.org
> Date: Wed, 25 May 2011 17:05:19 -0400
> Subject: RE: AIX 5.3 DBD::Oracle issues
>
> 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.
