Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmJKR-0008S8-BG for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2019 14:16:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmJKP-0007kC-1y for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2019 14:16:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmJKN-0007k5-Uq for pgsql-admin@lists.postgresql.org; Wed, 23 Jan 2019 14:16:28 +0000 Received: from sonic310-14.consmr.mail.bf2.yahoo.com ([74.6.135.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmJKJ-0006Ov-VV for pgsql-admin@lists.postgresql.org; Wed, 23 Jan 2019 14:16:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548252981; bh=2/pnSTRlTOddwLPn7ibRzxy44/rQj3krJpIDODvIPtE=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=Jt2tWqOX+XF7csUVMAtB3+jniQmyxYThyKCckJBhhgkXoo+fFkNrtalzSn5dz+V3YsJYFeQyaFmFWHVulSBdzaHjnr9vryTlbV7j8jkNtVuGtyqHw/4EvcinuF8opYAO8IpW6V2NCBs6121ST2vlPbaD/UYdeAn0TGjZAcRIiccuBLJ279ZsLmfIJRxFiYDnnd8y3g/ehQycIniyuHKJAGa6ZZ4qkfxVyF7qCYg1SEP1PRe8s52YNS4Rr5exGOJs1gks9Fjcy10d44bcfRj6IRPuPf7uPcrHVc3zXnqSEkYkwnln3SmtpO4UAnTQxOXQ5lRntpOxkjjjXJchaaP9Aw== X-YMail-OSG: GEUTwgcVM1mPonls.x6DDgBXgaeSuH2SbzJ.N_D4pMXyiGLnLO7tobhCZ21mQvS gNryzhQu9EY5q_WoxQxL3qFYVikALe4O_97.djQ5Z9IdkCdecW0z_HxjXRI.fAT1BFZcnzhf9H.U eMs3POadxU66MqHlFSVxpjxM2_CF.WHtw6wc3No.OZcQMr_vAWx__b8fVKHq1cDZpr8fJzldaRmH Vj7bmnt77ftdmjOCc7I1a4ImUeJ_Vv.bwnlvVqjaOxuyfNLVlb6CF3gPwp_FY_hIIeJnruiPcJ4w kbLXAeQUGSbYjxWZe9H3QHqe0gz9PqSdDmPMeBkYImUezfCVafF1gVL15Qioxav4Mx0vgSj2ve0O C3MjevfQdE7yo6_Tf64Bczqzqc4bt1MrBLP5d37RE83FRKZzQkMilzQnMnsPLRqgn_Q9yN4RAuep mdBk1etnM0a4kcQVQKz9ac0S1WvgXyJ9VfTZwsKCY0eNtShssMyTJI1M8XNI2MOC4kwlq3I028uQ 4JdqqnMSpIIE3TxiBEORH_te76Noamew8Iop313VCF8FnMda6Z4db6jHg4Qmw78bKl5.O4HnoZco GHMQ4EtTkgSeKTKv0oIDo4eeDCegTm.60JXaFzgG8iwAzFR9JCc0sRZW0e8uNMzrjpPtMzXgkpHK poCqyygeTupvEuwHLK6s98MSuX5VPcy3QRuyA20RClStdwtx27CURbh4nJ0B1LvzsoKmvOQfCHuG anhGOmQlZtEHjDkHmluJcuAq904WxChZ2rj1DXcZE_meZuHbH3lb0_w_8Cz6hJ5OAQEyjxcz1HVX ter2iklZLgH2kExal1RShzJToTdmDdgP9OC79K2Yc3N43Y5Z7gN2YzJkXVF9cszIblFFDaHO2XKo sXZx7iAfCZkmfUaAmGdxZF2uA8pr2wi48lPAkK1Li1__gSiFcUshUL09HCRu_R0loekyHNynuUh1 sS5fRwCkntRDL1pYQsG_Rf7hx5apM0nTnrkY.3v.jt0bzB2R9DeJdQ9sASsFjdu0TkDgBF7SpxSN h3p8Sy42vw.dZZrNCMIjaauhrHE7jwwtBeBHHECMk0oYxBXwC_EYtoVhPtk0pmzjrIyI- Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.bf2.yahoo.com with HTTP; Wed, 23 Jan 2019 14:16:21 +0000 Date: Wed, 23 Jan 2019 14:16:17 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Shreeyansh Dba Cc: Pgsql-admin Message-ID: <1459468182.2329140.1548252977768@mail.yahoo.com> In-Reply-To: References: <1440746250.2295016.1548250812245.ref@mail.yahoo.com> <1440746250.2295016.1548250812245@mail.yahoo.com> Subject: Re: ora2pg perl module error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2329139_1753465025.1548252977764" X-Mailer: WebService/1.1.13016 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 17438 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_2329139_1753465025.1548252977764 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable i am using oracle database server.=C2=A0 the LD_LIBRARY_PATH already declar= ed as=C2=A0 $ORACLE_HOME/lib=C2=A0=C2=A0before running ora2pg do I need to set it on ora2pg.conf ? thank you expert. v/r,=C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir 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 t= o 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=20 On Wednesday, January 23, 2019 9:09 AM, Shreeyansh Dba wrote: =20 It seems that, DBD:: Oracle can't find the Oracle client libraries beca= use they're not in your library path. You need to add its lib directory (so= mething like=C2=A0 /usr/lib/oracle/instantclient/lib or /opt/ora/instantcli= ent10_1/lib) to your library path -- either by adding a line to /etc/led. s= o. conf and running ldconfig as root, or by setting the LD_LIBRARY_PATH env= ironment variable.Thanks & Regards, Shreeyansh DBA Team www.shreeyansh.com On Wed, Jan 23, 2019 at 7:10 PM Pepe TD Vo wrote: Good morning Experts, after install DBD::Oracle and configure ora2pg.conf.=C2=A0 I run orag2pg an= d get an error# cd /etc/ora2pg# cp ora2pg.conf.dist ora2pg.conf# vi ora2pg.= conf=C2=A0 =C2=A0---> with modification belowORACLE_HOME /u01/app/oracle/pr= oduct/12.2.0/dbhome_1ORACLE_DSN dbi::Oracle:host=3Dhostname;sid=3DCIDR;port= -1521ORACLE_USER systemORACLE_PWD xxxxxTYPE TAPE PACKAGE INSERT COPY VIEW G= RANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION QUERY DB= LINK SYNONYM LOAD #ora2pginstall_driver(Oracle) failed: can't load '/usr/local/lib64/perl5/au= to/DBD/Oracle/Oracle.so' for module DBD::Oracle:libclntsh.so.12.1: cannot o= pen shared object file:No such file or directory at /usr/lib64/perl5/DynaLo= ader.pm line 190 at (evel13) line3.compilcation failed in require at (eval1= 3) line 3.Perhaps a required shared library or dll isn't installed where ex= pected at /usr/local/share/perl5/Ora2Pg.pm line 1570. the /usr/lib64/perl5/DynaLoader.pm existed and at line 190, I found:my $lib= reg =3D dl_load_file($file, $module->dl_load_flags) orcroak("Can't load '$f= ile' for module $module: ".dl_error()); what library/module needed? thank you.=C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir 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 t= o 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 =20 ------=_Part_2329139_1753465025.1548252977764 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
i am using oracle database server.  the LD_LIBRAR= Y_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.
=
T= o 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 Gingo= ld)

**Live simply **L= ove 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:
<= /div>

It seems that, DBD:: Oracle can't find the Oracle client libraries because they're not in your=20 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 -- eit= her by adding a line to /etc/led. so. conf and running ldconfig = as root, or by setting the LD_LIBRARY_PATH environment variable.
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com
=


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 below
ORACLE_HOME /u01/app/ora= cle/product/12.2.0/dbhome_1
ORACLE_DSN dbi::Oracle:host=3Dhostname;sid=3DCIDR;port-1521<= /div>
ORACLE_USER system
ORACLE_PWD xxxxx
TYPE TAPE PACKAGE INSERT COPY VIEW GRANT SEQUENCE T= RIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION QUERY DBLINK SYNONYM LO= AD

<= /div>
#ora2pg
ins= tall_driver(Oracle) failed: can't load '/usr/local/lib64/perl5/auto/DBD/Ora= cle/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 li= ne 190 at (evel13) line3.
compilcation fail= ed in require at (eval13) line 3.
Perhaps a= required shared library or dll isn't installed where expected at /usr/loca= l/share/perl5/Ora2Pg.pm line 1570.

the /usr/lib64/perl5/DynaLoader= .pm existed and at line 190, I found:
my $l= ibreg =3D dl_load_file($file, $module->dl_load_flags) or
croak("Can't load '$file' for module $module: ".dl_error= ());

what library/module needed?
<= br clear=3D"none">
thank you.
 
Bach-Nga

No on= e in this world is pure and perfect.  If you avoid people for their mi= stakes you will be alone. So judge less, love and forgive more.
T= o 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 Gingo= ld)

**Live simply **Love generously **Care deeply **Speak = kindly.
**= * Genuinely rich *** Faithful talent *** Sharing success


------=_Part_2329139_1753465025.1548252977764--