Tags: box, cant, dbd, dbdand, installation, installed, linux, locate, oracle, oraclepm, perl, priorinstalling, programming, suse, version

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

On Programmer » Perl

3,828 words with 2 Comments; publish: Wed, 30 Apr 2008 19:55:00 GMT; (200171.88, « »)

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 .perl.questionfor.info.INC (.perl.questionfor.info.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

All Comments

Leave a comment...

  • 2 Comments
    • >--Original Message--

      >From: Susantio, Herman [mailto:Herman_Susantio.perl.questionfor.info.commerzbank.com.sg]=20

      >Sent: Tuesday, December 25, 2007 9:03 PM

      >To: 'dbi-users.perl.questionfor.info.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 .perl.questionfor.info.INC (.perl.questionfor.info.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 ?

      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

      #1; Wed, 30 Apr 2008 19:56:00 GMT