Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

On Solaris running our own, not system perl 5.18.2 I have the following problem. Perl was build on one server and copied to a bunch of others. All but one have full oracle installed, the problem is with the server running "instant client". The error is.
\tError executing run mode 'Search': install_driver(Oracle) failed: Can't load '/app/perl/lib/site_perl/5.18.2/sun4-solaris-thread-multi- +64/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.11.1: open failed: No such file or directory at /app/perl/lib/5.18.2/sun4-s +olaris-thread-multi-64/DynaLoader.pm line 190.

Instant client:
appuser@> ls -al total 372588 drwxr-xr-x 3 root root 29 Mar 30 14:03 . drwxr-xr-x 6 appuser appuser 11 Mar 31 14:14 .. -rwxrwxr-x 1 root root 23792 Aug 22 2013 adrci -rw-rw-r-- 1 root root 414 Aug 22 2013 BASIC_README -rwxrwxr-x 1 root root 41464 Aug 22 2013 genezi -r-xr-xr-x 1 root root 368 Aug 22 2013 glogin.sql -rw-rw-r-- 1 root root 412 Aug 22 2013 JDBC_README -rwxrwxr-x 1 root root 50268448 Aug 22 2013 libclntsh.so.11 +.1 -r-xr-xr-x 1 root root 15848 Aug 22 2013 libheteroxa11.so + -r-xr-xr-x 1 root root 8653320 Aug 22 2013 libnnz11.so -rwxrwxr-x 1 root root 1545008 Aug 22 2013 libocci.so.11.1 -rwxrwxr-x 1 root root 118735824 Aug 22 2013 libociei.so -r-xr-xr-x 1 root root 121800 Aug 22 2013 libocijdbc11.so -r-xr-xr-x 1 root root 1385072 Aug 22 2013 libsqlplus.so -r-xr-xr-x 1 root root 1502288 Aug 22 2013 libsqlplusic.so -rwxrwxr-x 1 root root 756232 Aug 22 2013 libsqora.so.11.1 + drwxr-xr-x 3 root root 3 Mar 30 14:03 network -r-xr-xr-x 1 root root 19217 Aug 22 2013 ODBC_IC_Readme_U +nix.html -r-xr-xr-x 1 root root 3732 Aug 22 2013 odbc_update_ini. +sh -r-xr-xr-x 1 root root 91881 Aug 22 2013 ODBCRelnotesJA.h +tm -r-xr-xr-x 1 root root 44091 Aug 22 2013 ODBCRelnotesUS.h +tm -r--r--r-- 1 root root 2091135 Aug 22 2013 ojdbc5.jar -r--r--r-- 1 root root 2739616 Aug 22 2013 ojdbc6.jar -r--r--r-- 1 root root 82856 Aug 22 2013 orai18n-mapping. +jar -r--r--r-- 1 root root 1655734 Aug 22 2013 orai18n.jar -r-xr-xr-x 1 root root 8960 Aug 22 2013 sqlplus -rw-rw-r-- 1 root root 418 Aug 22 2013 SQLPLUS_README -rwxrwxr-x 1 root root 177680 Aug 22 2013 uidrvci -rw-rw-r-- 1 root root 66779 Aug 22 2013 xstreams.jar appuser@> ldd libclntsh.so.11.1 libnnz11.so => ./libnnz11.so libkstat.so.1 => /lib/64/libkstat.so.1 libnsl.so.1 => /lib/64/libnsl.so.1 libsocket.so.1 => /lib/64/libsocket.so.1 libresolv.so.2 => /lib/64/libresolv.so.2 libgen.so.1 => /lib/64/libgen.so.1 libdl.so.1 => /lib/64/libdl.so.1 libsched.so.1 => /usr/lib/64/libsched.so.1 librt.so.1 => /lib/64/librt.so.1 libc.so.1 => /lib/64/libc.so.1 libaio.so.1 => /lib/64/libaio.so.1 libpool.so.1 => /usr/lib/64/libpool.so.1 libadm.so.1 => /lib/64/libadm.so.1 libefi.so.1 => /lib/64/libefi.so.1 libm.so.2 => /lib/64/libm.so.2 libmp.so.2 => /lib/64/libmp.so.2 libmd.so.1 => /lib/64/libmd.so.1 libscf.so.1 => /lib/64/libscf.so.1 libnvpair.so.1 => /lib/64/libnvpair.so.1 libexacct.so.1 => /usr/lib/64/libexacct.so.1 libxml2.so.2 => /usr/lib/64/libxml2.so.2 libuuid.so.1 => /lib/64/libuuid.so.1 libdoor.so.1 => /lib/64/libdoor.so.1 libuutil.so.1 => /lib/64/libuutil.so.1 libpthread.so.1 => /lib/64/libpthread.so.1 libz.so.1 => /usr/lib/64/libz.so.1 /platform/sun4v/lib/sparcv9/libc_psr.so.1 /lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2 /platform/sun4v/lib/sparcv9/libmd_psr.so.1

I can see the ORACLE_HOME and LD_LIBRARY_PATH env variables, but have searched here and set the following in my code taken from another thread here
BEGIN { $ENV{'ORACLE_HOME'} = '/app/cdms/instantclient_11_2'; $ENV{'LD_LIBRARY_PATH'} = '/app/cdms/instantclient_11_2'; }
What do I have to do to get this working?

Replies are listed 'Best First'.
Re: DBD::Oracle - Instant client problems
by chacham (Prior) on Aug 11, 2015 at 17:20 UTC