Re: DBD::Oracle install

[Anonymous Monk]

What do you get when you run ldd -v libclntsh.so.11.1 or ldd -v Oracle.so?

[rider754]

Interestingly, Oracle.so thinks libclntsh.so.11.1 is not found. How would I go about fixing that?

ldd -v /opt/oracleas/product/11.2.0/client_1/lib/libclntsh.so.11.1
        linux-vdso.so.1 =>  (0x00007fff1d1fd000)
        libnnz11.so => /opt/oracleas/product/11.2.0/client_1/lib/libnn
+z11.so (0x00002b0cdc6cf000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00002b0cdcab1000)
        libm.so.6 => /lib64/libm.so.6 (0x00002b0cdccb5000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b0cdcf38000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00002b0cdd154000)
        libc.so.6 => /lib64/libc.so.6 (0x00002b0cdd36c000)
        libaio.so.1 => /usr/lib64/libaio.so.1 (0x00002b0cdd6c4000)
        /lib64/ld-linux-x86-64.so.2 (0x000000348a800000)

        Version information:
        /opt/oracleas/product/11.2.0/client_1/lib/libclntsh.so.11.1:
                libdl.so.2 (GLIBC_2.3.3) => /lib64/libdl.so.2
                libdl.so.2 (GLIBC_2.2.5) => /lib64/libdl.so.2
                libm.so.6 (GLIBC_2.2.5) => /lib64/libm.so.6
                libaio.so.1 (LIBAIO_0.4) => /usr/lib64/libaio.so.1
                libaio.so.1 (LIBAIO_0.1) => /usr/lib64/libaio.so.1
                libc.so.6 (GLIBC_2.3.2) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.3) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
                libpthread.so.0 (GLIBC_2.3.2) => /lib64/libpthread.so.
+0
                libpthread.so.0 (GLIBC_2.2.5) => /lib64/libpthread.so.
+0
        /opt/oracleas/product/11.2.0/client_1/lib/libnnz11.so:
                libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libdl.so.2:
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linu
+x-x86-64.so.2
                libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libm.so.6:
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libpthread.so.0:
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x8
+6-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux-
+x86-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linu
+x-x86-64.so.2
                libc.so.6 (GLIBC_2.3.2) => /lib64/libc.so.6
                libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libnsl.so.1:
                libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libc.so.6:
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x8
+6-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linu
+x-x86-64.so.2


ldd -v /home/root/.cpan/build/DBD-Oracle-1.58/blib/arch/auto/DBD/Oracl
+e/Oracle.so
        linux-vdso.so.1 =>  (0x00007fffbfbfd000)
        libclntsh.so.11.1 => not found
        libdl.so.2 => /lib64/libdl.so.2 (0x00002b75bac93000)
        libm.so.6 => /lib64/libm.so.6 (0x00002b75bae97000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b75bb11a000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00002b75bb336000)
        libc.so.6 => /lib64/libc.so.6 (0x00002b75bb54e000)
        /lib64/ld-linux-x86-64.so.2 (0x000000348a800000)

        Version information:
        /home/root/.cpan/build/DBD-Oracle-1.58/blib/arch/auto/DBD/Orac
+le/Oracle.so:
                libpthread.so.0 (GLIBC_2.2.5) => /lib64/libpthread.so.
+0
                libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libdl.so.2:
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linu
+x-x86-64.so.2
                libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libm.so.6:
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libpthread.so.0:
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x8
+6-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux-
+x86-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linu
+x-x86-64.so.2
                libc.so.6 (GLIBC_2.3.2) => /lib64/libc.so.6
                libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libnsl.so.1:
                libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
                libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
        /lib64/libc.so.6:
                ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x8
+6-64.so.2
                ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linu
+x-x86-64.so.2

[Anonymous Monk]

How would I go about fixing that?

Um, how did you set LD_LIBRARY_PATH? See adjust your LD_LIBRARY_PATH or use install_name_tool or add -R/instead/of/LD_LIBRARY_PATH to LIBS/CCFLAGS

[rider754]

Simply running as root,

export ORACLE_HOME=/opt/oracleas/product/11.2.0/client_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG=AMERICAN_AMERICA.US7ASCII

cpan

install DBD::Oracle

Since this is not DBD::mysql, I'm not sure how to interpret the linked threads to my case(?) It's not going to use DYLD_LIBRARY_PATH...