Can't locate loadable object for module DBD::Oracle (1107 Views)
Reply
Occasional Contributor
Victor  Feng
Posts: 6
Registered: ‎09-03-2010
Message 1 of 6 (1,107 Views)

Can't locate loadable object for module DBD::Oracle


OS is 11iv3, perl is 32bit. I extract 32bit Instantclient(from Oracle) to /opt/perl/instantclient_11_2.
Then install DBD::Oracle as follow.

root> export ORACLE_HOME=/opt/perl/instantclient_11_2
root> export SHLIB_PATH=$ORACLE_HOME
root> perl Makefile.PL
root> make
root> make test
root> make install
root> perl -e 'use DBD::Oracle;'

So it work fine with user root.  Login as a user

user> export ORACLE_HOME=/opt/perl/instantclient_11_2
user> export SHLIB_PATH=$ORACLE_HOME
user> perl -e 'use DBD::Oracle;'
Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /opt/perl_32/lib/5.8.8
/IA64.ARCHREV_0-thread-multi /opt/perl_32/lib/5.8.8 /opt/perl_32/lib/site_perl/5.8.8/IA64.ARCHREV_
0-thread-multi /opt/perl_32/lib/site_perl/5.8.8 /opt/perl_32/lib/site_perl /opt/perl_32/lib/vendor
_perl/5.8.8/IA64.ARCHREV_0-thread-multi /opt/perl_32/lib/vendor_perl/5.8.8 /opt/perl_32/lib/vendor
_perl .) at -e line 1
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.


What could be the cause? Thank you

Victor

Acclaimed Contributor
Dennis Handly
Posts: 25,291
Registered: ‎03-06-2006
Message 2 of 6 (1,099 Views)

Re: Can't locate loadable object for module DBD::Oracle

>So it work fine with user root.  Login as a user

>Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: ...

 

Is there a permission problem with one of these paths?

Occasional Contributor
Victor  Feng
Posts: 6
Registered: ‎09-03-2010
Message 3 of 6 (1,085 Views)

Re: Can't locate loadable object for module DBD::Oracle

Other users do have rx permission on all of them.

 

Victor

Acclaimed Contributor
Dennis Handly
Posts: 25,291
Registered: ‎03-06-2006
Message 4 of 6 (1,081 Views)

Re: Can't locate loadable object for module DBD::Oracle

>Other users do have rx permission on all of them.

 

On all directory paths to those shlibs?

If they are all fine, you'll probably need to use tusc to see where it first goes wrong.

Occasional Contributor
Victor  Feng
Posts: 6
Registered: ‎09-03-2010
Message 5 of 6 (1,070 Views)

Re: Can't locate loadable object for module DBD::Oracle

Fixed.

 

User did not have access to
 /opt/perl_32/lib/site_perl/5.8.8/IA64.ARCHREV_0-thread-multi/auto/DBD/Oracle.
  By changing its permission, now user can use DBD::Oracle.

 

Thanks

Victor

Acclaimed Contributor
Dennis Handly
Posts: 25,291
Registered: ‎03-06-2006
Message 6 of 6 (1,061 Views)

Re: Can't locate loadable object for module DBD::Oracle

>Fixed.  User did not have access to

 

If the answers solved your problem, please click on the Kudos stars.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.