perl连接oracle报错,perl 连接oracle

1.运行时报错

db.pl

[root@localhost ~]# db.pl

Name "main::dbh" used only once: possible typo at ./db.pl line 9.

install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: 无法打开共享对象文件: 没有那个文件或目录 at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.

at (eval 3) line 3

Compilation failed in require at (eval 3) line 3.

Perhaps a required shared library or dll isn't installed where expected

at ./db.pl line 9

//表示DBD 尚没安装成功。

2。

[root@localhost DBD-Oracle-1.22]# perl Makefile.PL

Using DBI 1.611 (for perl 5.008008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.008008 on linux (i386-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 /tmp/instantclient_10_2

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

If sqlplus failed due to a linker/symbol/relocation/library error or similar problem

then it's likely that you've not configured your environment correctly.

Specifically, your LD_LIBRARY_PATH environment variable

set to include the directory containing the Oracle libraries.

I'm having trouble finding your Oracle version number... trying harder

WARNING: I could not determine Oracle client version so I'll just

default to version 8.0.0.0. Some features of DBD::Oracle may not work.

Oracle version based logic in Makefile.PL may produce erroneous results.