jdenver47
asked on
Error Loading Perl Module DBD::Oracle
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-thre ad-multi-6 4all/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-threa d-multi-64 all/DynaLo ader.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-threa d-multi-64 all
/usr/opt/perl5/lib64/5.8.2
/usr/opt/perl5/lib64/site_ perl/5.8.2 /aix-threa d-multi-64 all
/usr/opt/perl5/lib64/site_ perl/5.8.2
/usr/opt/perl5/lib64/site_ perl
But still no luck.
randalp@devon24 $ perl -e 'use DBD::Oracle; print $DBD::Oracle::VERSION,"\n"
Can't load '/usr/opt/perl5/lib64/site
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
/usr/opt/perl5/lib64/5.8.2
/usr/opt/perl5/lib64/site_
/usr/opt/perl5/lib64/site_
/usr/opt/perl5/lib64/site_
But still no luck.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have reinstalled the Module but still I have the same issue
ASKER
LIBPATH=:/usr/lib:/usr/loc
LD_LIBRARY_PATH=:/usr/lib:
Here is the path for the user which is not working
LIBPATH=:/usr/lib:/usr/loc
LD_LIBRARY_PATH=:/usr/lib:
ORACLE_HOME=/home/oracle/O