Re: ora2pg perl module error - Mailing list pgsql-admin
| From | Pepe TD Vo |
|---|---|
| Subject | Re: ora2pg perl module error |
| Date | |
| Msg-id | 1459468182.2329140.1548252977768@mail.yahoo.com Whole thread Raw |
| In response to | Re: ora2pg perl module error (Shreeyansh Dba <shreeyansh2014@gmail.com>) |
| Responses |
Re: ora2pg perl module error
|
| List | pgsql-admin |
i am using oracle database server. the LD_LIBRARY_PATH already declared as $ORACLE_HOME/lib before running ora2pg
do I need to set it on ora2pg.conf ?
thank you expert.
v/r,
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.
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
On Wednesday, January 23, 2019 9:09 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
It seems that, DBD:: Oracle can't find the Oracle client libraries because they're not in your library path. 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/led. so. conf and running ldconfig as root, or by setting the LD_LIBRARY_PATH environment variable.
On Wed, Jan 23, 2019 at 7:10 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
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
pgsql-admin by date: