From: Pepe TD Vo <pepevo@yahoo.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: ora2pg perl module error
Date: Wed, 23 Jan 2019 13:40:12 +0000 (UTC)
Message-ID: <1440746250.2295016.1548250812245@mail.yahoo.com> (raw)
References: <1440746250.2295016.1548250812245.ref@mail.yahoo.com>
Good morning Experts,
after install DBD::Oracle and configure ora2pg.conf. I run orag2pg and get an error# cd /etc/ora2pg# cp ora2pg.conf.dist ora2pg.conf# vi ora2pg.conf ---> with modification belowORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1ORACLE_DSN dbi::Oracle:host=hostname;sid=CIDR;port-1521ORACLE_USER systemORACLE_PWD xxxxxTYPE TAPE PACKAGE INSERT COPY VIEW GRANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION QUERY DBLINK SYNONYM LOAD
#ora2pginstall_driver(Oracle) failed: can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:libclntsh.so.12.1: cannot open shared object file:No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 190 at (evel13) line3.compilcation failed in require at (eval13) line 3.Perhaps a required shared library or dll isn't installed where expected at /usr/local/share/perl5/Ora2Pg.pm line 1570.
the /usr/lib64/perl5/DynaLoader.pm existed and at line 190, I found:my $libreg = dl_load_file($file, $module->dl_load_flags) orcroak("Can't load '$file' for module $module: ".dl_error());
what library/module needed?
thank you. Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, pgsql-admin@lists.postgresql.org
Subject: Re: ora2pg perl module error
In-Reply-To: <1440746250.2295016.1548250812245@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox