Can"t locate DBD/Oracle.pm after DBD Oracle 1.19 installation

Hi all,

we just installed DBD Oracle 1.19 on Linux suse.
oracle 10.1.0.3 full version has been installed on the same box prior
installing DBD
and the db instance is accessible.

after the DBD Oracle installation, when we run the perl script, we hit the
following error :

xxxx>./test.pl
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC
contains: /u01/app/testl /usr/lib/perl5/5.8.3/x86_64-linux-thread-multi
/usr/lib/perl5/5.8.3
/usr/lib/perl5/site_perl/5.8.3/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.3/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl .) at (eval 5)
line 3.

we actually could find Oracle.pm under
/usr/lib/perl5/site_perl/5.8.3/x86_64-linux-thread-multi/DBD

could someone able to advise on this ?


Thank you

RE: Can"t locate DBD/Oracle.pm after DBD Oracle 1.19 installation

>-----Original Message-----
>From: Susantio, Herman [mailto:Herman_Susantio@commerzbank.com.sg]=20
>Sent: Tuesday, December 25, 2007 9:03 PM
>To: 'dbi-users@perl.org'
>Subject: Can't locate DBD/Oracle.pm after DBD Oracle 1.19 installation
>
>we just installed DBD Oracle 1.19 on Linux suse.
>oracle 10.1.0.3 full version has been installed on the same box prior
>installing DBD and the db instance is accessible.
>after the DBD Oracle installation, when we run the perl script, we hit
the
>following error :
>xxxx>./test.pl
>install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC
>contains: /u01/app/testl /usr/lib/perl5/5.8.3/x86_64-linux-thread-multi
>/usr/lib/perl5/5.8.3
>/usr/lib/perl5/site_perl/5.8.3/x86_64-linux-thread-multi
>/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl
>/usr/lib/perl5/vendor_perl/5.8.3/x86_64-linux-thread-multi
>/usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl .) at (eval
5)
>line 3.
>
>we actually could find Oracle.pm under
>/usr/lib/perl5/site_perl/5.8.3/x86_64-linux-thread-multi/DB D
>could someone able to advise on this ?

It *could* be a permissions issue; I say *could* because we did not get
the same error you are getting when installing on HP/UX. =20
Our error:
install_driver(Oracle) failed: Can't load
'/opt/perl_32/lib/site_perl/5.8.8/PA-R
ISC1.1-thread-multi/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle:
No such f
ile or directory at
/opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/DynaLoader.pm
line 230.
at (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./OraConn3.pl line 68

Regardless, last April, the DBD-Oracle install tests ran fine but user=20
scripts didn't. When we ran those same scripts as root they worked. =20
In our case, the issue was tracked to permissions on the Oracle client=20
directories and the tnsnames.ora file.
You might want to check the perms where the Oracle.pm file resides too.
Hope this helps,=20
Paula