RE: question for DBD-Oracle driver

>On March 28, Icheng said:
>After I try the command you provide, I got the following error
>Can't load
'/opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Or acle.sl'=20
>for module DBD::Oracle: No such file or directory at
>/opt/perl5/lib/5.8.0/PA-RISC2.0/DynaLoader.pm line 229.
> at test_dbd_ver.pl line 5

This looks like the DBD-Oracle module is installed dynamically. Use the
HP chatr
command to find out what libs it needs and make them available via your=20
environment variables. Specifically, issue
chatr /opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Ora cle.sl
This will show you what libraries need to be available to satisfy the=20
dynamic requirements of this module. =20
Example for the following output:
sl:
shared library
shared library dynamic path search:
SHLIB_PATH disabled second
embedded path enabled first /usr/oracle/client/10.2/lib32:
/usr/oracle/client/10.2/rdbms/lib32
shared library list:
dynamic /usr/oracle/client/10.2/lib32//libclntsh.sl.10.1
dynamic /usr/lib/libm.2
shared vtable support disabled
explicit unloading enabled
static branch prediction disabled
executable from stack: D (default)
kernel assisted branch prediction enabled
lazy swap allocation disabled
text segment locking disabled
data segment locking disabled
third quadrant private data space disabled
fourth quadrant private data space disabled
third quadrant global data space disabled
data page size: D (default)
instruction page size: D (default)
nulptr references disabled
shared library private mapping disabled

You would need to export the following environment variables:
export ORACLE_HOME=3D/usr/oracle/client/10.2
export TNS_ADMIN=3D??? (where your tnsnames.ora file is)
export PATH=3D/usr/oracle/client/10.2/bin:$PATH

I hope this helps.
Paula=20



=20
=20