>>On March 28, Fred Vachon said:
>>I have DBI and DBD::Oracle installed on a Solaris 10 machine. 
>>When I run either of the 2 commands that were posted I error out with:

>>perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;'
>>Can't load
'/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so
' 
>>for module DBD::Oracle: ld.so.1: perl: fatal: .
>> at -e line 0
>>I'm thinking it might be an issue with PATH or LD_LIBRARY_PATH but I
>>haven't been able to find it.

I believe you are correct, and that this is another dynamic install.
Solaris doesn't have the chatr command but you can use ldd to get
similar information.
Specifically, issue: 
ldd
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle/Oracle.so

Although this doesn't show the libraries it shows what parts are
missing. 
Do a 'find' for these parts and once you locate them, add the location
to
your LD_LIBRARY_PATH. 
Example for the following output:
$ ldd
/opt/Perl5/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/Oracle
.so
libclntsh.so.8.0 => (file not found)
libwtc8.so => (file not found)
libnsl.so.1 => /usr/lib/libnsl.so.1
libsocket.so.1 => /usr/lib/libsocket.so.1
libdl.so.1 => /usr/lib/libdl.so.1
libsched.so.1 => /usr/lib/libsched.so.1
libaio.so.1 => /usr/lib/libaio.so.1
libposix4.so.1 => /usr/lib/libposix4.so.1
libkstat.so.1 => /usr/lib/libkstat.so.1
libm.so.1 => /usr/lib/libm.so.1
libthread.so.1 => /usr/lib/libthread.so.1
libc.so.1 => /usr/lib/libc.so.1
libmp.so.2 => /usr/lib/libmp.so.2
/usr/platform/SUNW,Ultra-80/lib/libc_psr.so.1

I did a find for the files not found then added the locations to my
environ vars:

export ORACLE_HOME=/usr/oracle/product/8.1.7
export TNS_ADMIN=??? (location of your tnsnames.ora)
export PATH=/usr/oracle/product/8.1.7/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

I hope this helps.
Paula

Reply via email to