Solved

Error Loading Perl Module DBD::Oracle

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

830 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