Solved

Error Loading Perl Module DBD::Oracle

Posted on 2008-09-29
3
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.

0
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
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
SmartIntel earned 500 total points
ID: 22597181
You need to check the env variable
check your ORACLE_HOME and LD_LIBRARY_PATH are set correctly.
0
 

Author Comment

by:jdenver47
ID: 22597608
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

0
 

Author Comment

by:jdenver47
ID: 22599695
I have reinstalled the Module but still I have the same issue
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

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…
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 …
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…
Six Sigma Control Plans

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question