Solved

Error Loading Perl Module DBD::Oracle

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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
help pulling data string using Awk 9 90
Oracle Finace 3 104
mobaxterm not able to change directory 28 377
leap year shell script 10 54
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
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…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

751 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