Hi,

While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows :

Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.0/i586-linux-thread-multi/DynaLoader.pm line 229.

I am confident in the case that the driver DBD::Oracle was installed.

Can anyone suggest,what is happening and why?

With Regards
Dileep Pattayath

Try This

#echo $ORACLE_HOME/lib >> /etc/ld.so.conf
# ldconfig

Thanks for your reply

But i don't have write access to this directory /etc.Can you suggest anything to be done from the user end.

Anyway what the above code will represent?

With Regards
Dileep Pattayath

Dileep,
It seems to me some problem with Perl module that properly not installed or might be the lib path (xxxx.so) files in different location.

So why I asked for
#echo $ORACLE_HOME/lib >> /etc/ld.so.conf

Here it will put all the .so files with in /etc/ld.so.conf files.

# ldconfig

After executing the above command it will get affect mean to say it will read all these .so files location.

One suggestion you can verify whether that files (.pm) is existing or not
"/usr/lib/perl5/5.8.0/i586-linux-thread-multi/DynaLoader.pm "

## find / -name DynaLoader.pm

Then compare the location .. If it is not there that mean Your driver DBD perl module didn't compile properly.

~~~Sanjay~~~

ok,fine.Thank you.

The problem was solved now.I set the environment variable LD_LIBRARY_PATH="$ORACLE_HOME/lib".I think this was the same idea you gaven.Now it's working fine.

Thanks for your time and effort

With Regards
Dileep Pattayath