dbi-users@perl.org

Dear folks,

I have a question for you here. I just installed DBI
and Oracle DBD module. I tried a test script but got
the following errors:

install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.9.0: cannot open
shared object file: No such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm
line 230. 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 lsun.pl line 7

Does anyone know what is wrong? I could login to the
database using sqlplus username/password@sid

Thanks,

Lihong


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: dbi-users@perl.org

From my experience with recent (Java-based) Oracle client installations
on Windows: The Oracle installer does not install all libraries needed
for DBD::Oracle. Oracle's own tools work fine without them, but
DBD::Oracle doesn't. As a crude workaround, I told my co-workers to
install (NOT TO USE!) the Oracle ODBC drivers. As a side effect of that,
the required libraries are installed.

Alexander

Lihong Sun wrote:

>Dear folks,
>
>I have a question for you here. I just installed DBI
>and Oracle DBD module. I tried a test script but got
>the following errors:
>
>install_driver(Oracle) failed: Can't load
>'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/aut o/DBD/Oracle/Oracle.so'
>for module DBD::Oracle: libclntsh.so.9.0: cannot open
>shared object file: No such file or directory at
>/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm
>line 230. 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 lsun.pl line 7
>
>Does anyone know what is wrong? I could login to the
>database using sqlplus username/password@sid
>
>Thanks,
>
>Lihong
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>
>

--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/

RE: dbi-users@perl.org

-----Original Message-----
From: Lihong Sun [mailto:lihong_sun88@yahoo.com]=20
Sent: Monday, June 26, 2006 2:49 PM
To: dbi-users@perl.org
Subject: dbi-users@perl.org
>=20
> Dear folks,=20
>=20
> I have a question for you here. I just installed DBI and Oracle DBD
> module. I tried a test script but got the following errors:
>
> install_driver(Oracle) failed: Can't load
> '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-
> multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:
> libclntsh.so.9.0: cannot open shared object file: No such file or
> directory at /usr/lib/perl5/5.8.5/i386-linux-thread-
> multi/DynaLoader.pm line 230. 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 lsun.pl line 7
>
> Does anyone know what is wrong? I could login to the database using
> sqlplus username/password@sid

Try this before running your script:
export LD_LIBRARY_PATH=3D"$ORACLE_HOME/lib:$LD_LIBRARY_PATH"

That should help it to find the library.

Philip

RE: dbi-users@perl.org

Did you install an Oracle client (at least)? Did you read the README*
files for each module?

-----Original Message-----
From: Lihong Sun [mailto:lihong_sun88@yahoo.com]=20
Sent: Monday, June 26, 2006 12:49 PM
To: dbi-users@perl.org
Subject: dbi-users@perl.org

Dear folks,=20

I have a question for you here. I just installed DBI
and Oracle DBD module. I tried a test script but got
the following errors:

install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto /DBD/Oracle/
Oracle.so'
for module DBD::Oracle: libclntsh.so.9.0: cannot open
shared object file: No such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm
line 230. 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 lsun.pl line 7

Does anyone know what is wrong? I could login to the
database using sqlplus username/password@sid

Thanks,

Lihong=20


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

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.