.pl code errors after oracle upgrade

------_=_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=

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,
line 1.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3, 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=


Regards,
Joseph




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

RE: .pl code errors after oracle upgrade

Arokia Samy Joseph wrote:
> Hi,
>=20
> 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!
>=20
> 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

RE: .pl code errors after oracle upgrade

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@singtel.com]=20
Sent: Thursday, March 08, 2007 2:19 AM
To: dbi-users@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=

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,
line 1.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3, 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=


Regards,
Joseph




This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.

RE: .pl code errors after oracle upgrade

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):=20
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Apr 26 2001 04:07:49
@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
.=20

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

Arokia Samy Joseph wrote:
> Hi,
>=20
> 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=20
> listed. Your suggestion / solution is much appreciated . Thanks!
>=20
> 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

RE: .pl code errors after oracle upgrade

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