Solved

Error Loading Perl Module DBD::Oracle

Posted on 2008-09-29

Perl
Unix OS

1 solution

857 Views

Last Modified: 2012-05-05

I have installed DBD::Oracle Perl Module and works file as root. But when I log in as a user and try to run a script that uses the module. Here is the error

randalp@devon24 $ perl -e 'use DBD::Oracle; print $DBD::Oracle::VERSION,"\n";'
Can't load '/usr/opt/perl5/lib64/site_perl/5.8.2/aix-thread-multi-64all/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: The file access permissions do not allow the specified action. at /usr/opt/perl5/lib64/5.8.2/aix-thread-multi-64all/DynaLoader.pm line 229.
at -e line 1
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.

So I thought changing the permission for Oracle.so and DynaLoader.pm to 755 will help me resolve the issue but I am getting the same error. I went ahead and changed the permission where the perl i installed to 755 ,Given below are the files...
/usr/opt/perl5/lib64/5.8.2/aix-thread-multi-64all
/usr/opt/perl5/lib64/5.8.2
/usr/opt/perl5/lib64/site_perl/5.8.2/aix-thread-multi-64all
/usr/opt/perl5/lib64/site_perl/5.8.2
/usr/opt/perl5/lib64/site_perl

But still no luck.

Comment

Question by:jdenver47

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

3 Comments

LVL 5

Accepted Solution

by:SmartIntel

SmartIntel earned 500 total points

ID: 225971812008-09-29

You need to check the env variable
check your ORACLE_HOME and LD_LIBRARY_PATH are set correctly.

Author Comment

by:jdenver47

ID: 225976082008-09-29

Here are the path for root which is working

LIBPATH=:/usr/lib:/usr/local/lib:/sybase/OCS-12_5/lib:/sybase/ASE-12_5/lib:.:
LD_LIBRARY_PATH=:/usr/lib:/usr/local/lib:.:

Here is the path for the user which is not working
LIBPATH=:/usr/lib:/usr/local/lib:/sybase/OCS-12_5/lib:/sybase/ASE-12_5/lib:.:/home/oracle/OraHome_2:
LD_LIBRARY_PATH=:/usr/lib:/usr/local/lib:.:
ORACLE_HOME=/home/oracle/OraHome_2

Author Comment

by:jdenver47

ID: 225996952008-09-29

I have reinstalled the Module but still I have the same issue

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Email validation using Regular Expression in Perl

Article by: Sanjeev

Email validation in proper way is very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…

Perl

Using Perl to convert an Excel Workbook into a MongoDB, with each Worksheet converted into a separate MongoDB collection

Article by: arober11

A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads), installed and started the daemon, and had a console window open. After an hour or two of playing at the command …

Perl

Linux/ Unix Bash Shell: Navigating the File Tree

Video by: Dototot

Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…