Perl Ora2Pg on Ubuntu

Question

I just tried Ora2Pg on my Ubuntu Jaunty Jackalope.

First of all, the installation was hard, but after downloading a few debs & rpms here & there, I was finally managed to install ora2pg via synaptic.

However, when I try to run this command

ora2pg /tmp/ora2pg.conf

I am getting a

install_driver(Oracle) failed: Can't load '/usr/lib/perl5/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/lib/perl/5.10/DynaLoader.pm line 196.

at (eval 14) line 3

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

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

at /usr/share/perl5/Ora2Pg.pm line 566

Any ideas what's wrong and how to fix it?

Note: I don't perl. I just started browsing a bit it because of this.

Thanks, Franz

Answer 1

DBD::Oracle can't find the Oracle client libraries because they're not in your library path. If you don't have the Oracle client libraries and you don't have a sysadmin to provide them for you, then you need to get the "Oracle Instantclient" package from the oracle website and install it. If you already have Instantclient installed, then you need to add its lib directory (something like /usr/lib/oracle/instantclient/lib or /opt/ora/instantclient10_1/lib) to your library path -- either by adding a line to /etc/ld.so.conf and running ldconfig as root, or by setting the LD_LIBRARY_PATH environment variable.