求解~DBD连oracle报错

风铃中の鬼

我的oracle客户端装的是12.1版本，用ldd命令看读的是10.1的版本，所以 libclntsh.so.10.1 => not found：

ldd /usr/opt/dc_perl/lib/site_perl/5.12.4/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so

        linux-vdso.so.1 =>  (0x00007fff60dff000)
        libclntsh.so.10.1 => not found
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f2c77699000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f2c77415000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f2c771f8000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f2c76fde000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f2c76c4a000)
        /lib64/ld-linux-x86-64.so.2 (0x000000369a200000)

然后我在网上搞了个 libclntsh.so.10.1放在对应的目录下ORACLE_HOME/lib，但是ldd之后依然not found。。

我的环境变量应该是没有配错的。。包括ORACLE_HOME,LD_LIBRARY_PATH这两个应该都没问题

想请教该怎么搞？？


另外，我试着装个新的DBD::Oracle，但报如下错误，难道只能重新搞个10.1的客户端？



Using DBI 1.622 (for perl 5.012004 on x86_64-linux-thread-multi) installed in /usr/opt/dc_perl/lib/site_perl/5.12.4/x86_64-linux-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.012004 on linux (x86_64-linux-thread-multi)

Remember to actually *READ* the README file! Especially if you have any problems.

Installing on a linux, Ver#2.6
Using Oracle in /usr/lib/oracle/12.1/client64
DEFINE _SQLPLUS_RELEASE = "1201000200" (CHAR)
Oracle version 12.1.0.2 (12.1)

        Unable to locate an oracle.mk or other suitable *.mk
        file in your Oracle installation.  (I looked in
        /usr/lib/oracle/12.1/client64/rdbms/demo/demo_xe.mk /usr/lib/oracle/12.1/client64/rdbms/lib/oracle.mk /usr/lib/oracle/12.1/client64/rdbms/demo/oracle.mk /usr/lib/oracle/12.1/client64/rdbms/demo/demo_rdbms.mk /usr/lib/oracle/12.1/client64/rdbms/demo/demo_rdbms64.mk /usr/lib/oracle/12.1/client64/rdbms/lib/ins_rdbms.mk /usr/share/oracle/12.1/client64/demo.mk under /usr/lib/oracle/12.1/client64)

        The oracle.mk (or demo_rdbms.mk) file is part of the Oracle
        RDBMS product.  You need to build DBD::Oracle on a
        system which has one of these Oracle components installed.
        (Other *.mk files such as the env_*.mk files will not work.)
        Alternatively you can use Oracle Instant Client.

        In the unlikely event that a suitable *.mk file is installed
        somewhere non-standard you can specify where it is using the -m option:
                perl Makefile.PL -m /path/to/your.mk

        See the appropriate README file for your OS for more information and some alternatives.

     at Makefile.PL line 1187.

laputa73

建议你统一都装oracle的server,因为DBD需要根据里面的mk文件和h文件确定如何编译
而client一般是默认不安装这些的(就是那些demo目录)
或者你从其他机器上复制过来.

nsnake_cu

从 OTN Instant Client 页面下载 Basic 和 SDK Instant Client 程序包。可以使用 zip 文件或 RPM。

以 root 用户身份安装 RPM，例如：

rpm -Uvh oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm
rpm -Uvh oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm

第一个 RPM 将 Oracle 库放在 /usr/lib/oracle/11.2/client64/lib 中，第二个 RPM 在/usr/include/oracle/11.2/client64 中创建头。

如果您使用 ZIP 文件，应该将 SDK 解压缩到 basic 程序包所在的目录中，并手动创建符号链接：

ln -s libclntsh.so.11.1 libclntsh.so

将 Instant Client 目录添加到 /etc/ld.so.conf，或者手动将 LD_LIBRARY_PATH 设置为 /usr/lib/oracle/11.2/client64/lib。您可能还要设置 Oracle 全球化语言环境变量，如 TNS_ADMIN 和 NLS_LANG。如果不设置 NLS_LANG，则采用默认的本地环境。
更新你的ld环境在试吧