这个perl脚本的设置:
$ENV{"PATH"} = "/home/oracle/bin:/data/oracle/product/10.2.0/db1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/j2sdk/bin:/home/oracle/bin:/opt/PostgreSQL/8.4/bin";
$ENV{"POSTGRES_HOME"} = "/opt/PostgreSQL/8.4";
$ENV{"LD_LIBRARY_PATH"} = "/data/oracle/product/10.2.0/db1/lib:/lib:/usr/lib:/opt/PostgreSQL/8.4/lib";
$ENV{"PGDATA"} = "/opt/PostgreSQL/8.4/data";
$ENV{"MANPATH"} = "/opt/PostgreSQL/8.4/man";
$ENV{"ORACLE_HOME"} = "/data/oracle/product/10.2.0/db1";
$ENV{"ORACLE_SID"} = "orcl";
错误(同时访问postgresql也会出现类似问题)
install_driver(Oracle) failed: Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /home/oracle/pis/pis.pl line 30