Error Loading Perl Module DBD::Oracle

Posted on 2008-09-29

Perl
Unix OS

1 solution

Medium Priority

878 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

3 Comments

LVL 5

Accepted Solution

by:SmartIntel

SmartIntel earned 1500 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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment Already a member? Login.

How to use multiple files efficiently in vim editor

Article by: Sanjeev

Many time we need to work with multiple files all together. If its windows system then we can use some GUI based editor to accomplish our task. But what if you are on putty or have only CLI(Command Line Interface) as an option to edit your files. I…

Perl

Using Perl to preview in a Web Page and convert a JSON document into an Excel workbook

Article by: arober11

In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…

Perl

Linux/ Unix Bash Shell: Getting Help

Video by: Dototot

Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

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…