------_=_NextPart_001_01C76162.DD201E88
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

We recently upgraded our oracle database 8.1.7.4 to 9.2.6.0 After
the update we tried to execute a .pl code. The following error is
listed. Your suggestion / solution is much appreciated . Thanks!

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=

install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/ Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.8.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206, <STDIN>
line 1.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3, <STDIN> line 1.
Perhaps a required shared library or dll isn't installed where expected
at /pelican_app/dv41/arbor/bin/replicate_oracle.pl line 686
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=


Regards,
Joseph




------_=_NextPart_001_01C76162.DD201E88--

Arokia Samy Joseph wrote:
> Hi,
>
> We recently upgraded our oracle database 8.1.7.4 to 9.2.6.0 After
> the update we tried to execute a .pl code. The following error is
> listed. Your suggestion / solution is much appreciated . Thanks!
>
> ld.so.1: perl: fatal: libclntsh.so.8.0:
^^^

You need to reinstall DBD::Oracle, because it is linked with the old
version of the Oracle libraries (which have been replaced by version 9).

- Philip

1. Permissions on $ORACLE_HOME/lib
2. Not setting the correct Oracle environment vars before executing the
script
3. Uninstall of 8.1.7.4 Oracle software
4. Did you rebuild DBD::Oracle to use the newly installed Oracle
software?

Impossible to tell since we have nothing but an error message.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Arokia Samy Joseph [mailto:joseph [at] singtel.com]
Sent: Thursday, March 08, 2007 2:19 AM
To: dbi-users [at] perl.org
Subject: .pl code errors after oracle upgrade

Hi,

We recently upgraded our oracle database 8.1.7.4 to 9.2.6.0 After
the update we tried to execute a .pl code. The following error is
listed. Your suggestion / solution is much appreciated . Thanks!

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=

install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/ Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.8.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206, <STDIN>
line 1.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3, <STDIN> line 1.
Perhaps a required shared library or dll isn't installed where expected
at /pelican_app/dv41/arbor/bin/replicate_oracle.pl line 686
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=


Regards,
Joseph




This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended
to be for the use of the individual or entity named above. If you are =
not the
intended recipient, please be aware that any disclosure, copying, =
distribution
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Hi Joseph,

Arokia Samy Joseph wrote:
> The existing Perl, gcc versions we have in our system, are listed
> below. Pls. let us know the steps to " reinstall DBD::Oracle ".

1) Download
http://www.cpan.org/modules/by-module/DBD/DBD-Oracle-1.19.ta r.gz.
2) Unpack it
3) Read the README file very carefully and follow the instructions.

Regards,
Philip

Hi Philip,

The existing Perl, gcc versions we have in our system, are listed below.
Pls. let us know the steps to " reinstall DBD::Oracle ".

Regards,
Joseph


Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=3Dsolaris, osvers=3D2.8, archname=3Dsun4-solaris
uname=3D'sunos solaris 5.8 generic sun4u sparc sunw,ultra-5_10 '
config_args=3D'-Dcc=3Dgcc -de'
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Dundef use5005threads=3Dundef useithreads=3Dundef
usemultiplicity=3Dundef
useperlio=3Dundef d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
use64bitint=3Dundef use64bitall=3Dundef uselongdouble=3Dundef
Compiler:
cc=3D'gcc', ccflags =3D'-fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64',
optimize=3D'-O',
cppflags=3D'-fno-strict-aliasing -I/usr/local/include'
ccversion=3D'', gccversion=3D'2.95.3 20010315 (release)',
gccosandvers=3D'solaris2.8'
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D4321
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D16
ivtype=3D'long', ivsize=3D4, nvtype=3D'double', nvsize=3D8, =
Off_t=3D'off_t',
lseeksize=3D8
alignbytes=3D8, usemymalloc=3Dy, prototype=3Ddefine
Linker and Libraries:
ld=3D'gcc', ldflags =3D' -L/usr/local/lib '
libpth=3D/usr/local/lib /usr/lib /usr/ccs/lib
libs=3D-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc
perllibs=3D-lsocket -lnsl -ldl -lm -lc
libc=3D/lib/libc.so, so=3Dso, useshrplib=3Dfalse, =
libperl=3Dlibperl.a
Dynamic Linking:
dlsrc=3Ddl_dlopen.xs, dlext=3Dso, d_dlsymun=3Dundef, ccdlflags=3D' '
cccdlflags=3D'-fPIC', lddlflags=3D'-G -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Apr 26 2001 04:07:49
[at] INC:
/usr/local/lib/perl5/5.6.1/sun4-solaris
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl
.

-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett [at] manheim.com]
Sent: Thursday, March 08, 2007 10:53 PM
To: Arokia Samy Joseph; dbi-users [at] perl.org
Subject: RE: .pl code errors after oracle upgrade

Arokia Samy Joseph wrote:
> Hi,
>
> We recently upgraded our oracle database 8.1.7.4 to 9.2.6.0 After

> the update we tried to execute a .pl code. The following error is
> listed. Your suggestion / solution is much appreciated . Thanks!
>
> ld.so.1: perl: fatal: libclntsh.so.8.0:
^^^

You need to reinstall DBD::Oracle, because it is linked with the old
version of the Oracle libraries (which have been replaced by version 9).

- Philip