ora2pg perl module error - Mailing list pgsql-admin

From Pepe TD Vo
Subject ora2pg perl module error
Date
Msg-id 1440746250.2295016.1548250812245@mail.yahoo.com
Whole thread Raw
Responses Re: ora2pg perl module error  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
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 below
ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1
ORACLE_DSN dbi::Oracle:host=hostname;sid=CIDR;port-1521
ORACLE_USER system
ORACLE_PWD xxxxx
TYPE TAPE PACKAGE INSERT COPY VIEW GRANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION QUERY DBLINK SYNONYM LOAD

#ora2pg
install_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) or
croak("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

pgsql-admin by date:

Previous
From: "S. Bob"
Date:
Subject: OT - Users in Alaska?
Next
From: Shreeyansh Dba
Date:
Subject: Re: ora2pg perl module error