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 1gmM9V-0007nW-SY for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2019 17:17:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmM9U-0001fh-LH for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2019 17:17:24 +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 1gmM9T-0001fa-Kl for pgsql-admin@lists.postgresql.org; Wed, 23 Jan 2019 17:17:24 +0000 Received: from sonic306-3.consmr.mail.bf2.yahoo.com ([74.6.132.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmM9P-0001xK-Uj for pgsql-admin@lists.postgresql.org; Wed, 23 Jan 2019 17:17:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548263836; bh=5u93b8H3iw4AlsWVo1b7vtLqPK1ZiIqEnI0bUtlM/II=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=twvXDr/kyWzxxkMNt8EosnUVtFyecV/03oX4r83ROKIR+YAnszk5xWRGCt3HWQciXYY3CGyWM7CCYhkmtGVHsnJGtxD5kuR4gj6DEb+HCQX61fqzVDLovL+WtbJEAB62vvSKkTpp0/YKHPLG/yoA2NJXvpKmG0f3ZdorkT9d1qtV93q87OLRCVxYB6X5pfO6Dk9JLsRKQeN3i50SnzD59smes/ag5w1V2/ts8knwteea2F8Kib5xJgB3EF2kZov3pgJJDS6m9GfZXKdfX74Im5AoKmYdXGa2apZFSO9I6Dtr++lLjDXZL3FgnegTyklRqpz4FmG5ZlypVXRLxtX1tw== X-YMail-OSG: eO4azaoVM1mLUUjj0SatB3e45cat9RqnlbKzTpMeO_rhGme0xQeiI2WJvGLOuwj kD1EzuFNFehHPNrUpzTyvrpJaismR3GokENzrsLd5IDjf7r3fdPG0_T_Dvirgwj2myUh.nE7A3dN W4KduDbglaDt3akUv6R0SeZSWwIn16fu2Bz5KgmiKnZot1oRtAh3NJeV64wcCpEr7M7KkMNeprXO 05euOFaThBjy0xNe1EpLGAZug5w_VjBQxzK7RXzqEwwffjhaUmCBWKjFC4.FGNU1EqcZY84m0Swa dQXcjwz99ieZWSyNgofVauPKIuH1SOlMKbXw8ZrQm4Ud3QFYOtETKNxjKupJQqetAPHbzMjiKO3x 2tqlmgQCGJAtwdbzKY7hBrxmj6ii_U7iQaAyg4JZuXBmsLGO1Mj6KhrHLtjH0AimN7xy0GeWkYAe 3FZC7diWcECbmUjqswi.VMkLC.l51YI7_jvNbYY8WzDRPufMa00u4KBnCLzLQBVX.L1VHcOyuBXu xID3eG6uls5LIkL75CQiAJDjz._irDk51Tr0VWCczm1sIWU1oormsHAO_td6T8AIaGHPZR.Ge4cU WzJ9abpd9JQ2.5UkLgB4yPWWMOFf8XE6FOAwOoCBg8f2eiFUrgFpDoaaGK1NEjfyvdiA7K4c4Xgw MYFzvRjjePBskk2zOTrQwJUpn1MEA1mYXv2FfnremXXNZ7CC94YSUIrtZE7PICsBcALpZQouaaFu _pnoaSBmDKQsEkiEfSGZq93ILYptpl.IzpmIt1SiVvszuuuZQxwP3xBlzhB4Y5PDsXuVjrOLfquO k_3GaqWIuyPptwZM50keHBaIRvKjArLvSIE2mcwygxawpFjPmHdI.31OZn8SwIfdxdi9_M3rGMHF XWZoWBr67eA7Abgp3RSk9Abs1ZiQB4hL3AzseM0UgSYBQmuR38cESdZgL.PFlq81GeP_hfQ_xQUa WA31qehsU_jtirZVj7YwHCnUjdwE_fqwnXHJV84u4WVxDjGAA.17WCw5O8OxGD5_J3NqoC_Ue8Cz 2POPj2qSe3CxSZnCADyFhfp1FfM1D0_d6EBcSw.PFMyQXIaWj5UfwzcjQX_YJE6VJiodcEyw77IQ 0R9eYThUSBQl8JlQ- Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.bf2.yahoo.com with HTTP; Wed, 23 Jan 2019 17:17:16 +0000 Date: Wed, 23 Jan 2019 17:17:12 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pepe TD Vo , Don Seiler Cc: Shreeyansh Dba , Pgsql-admin Message-ID: <1924376145.2429322.1548263832913@mail.yahoo.com> In-Reply-To: <34359708.2383722.1548257429166@mail.yahoo.com> References: <34359708.2383722.1548257429166.ref@mail.yahoo.com> <34359708.2383722.1548257429166@mail.yahoo.com> Subject: Re: ora2pg perl module error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2429321_346508525.1548263832910" 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: 15021 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_2429321_346508525.1548263832910 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I reset and the ora2pg run with 65 tables 100% scanning and the server time= out. reconnect the server and reset the LD_LIBRARY_PATH and ORACLE_HOME from com= mand prompt and=C2=A0I rerun ora2pg with background I get: FATAL: can not remove old temporary file /tmp/tmp_ora2pgdhwbrzinstall_drive= r(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 f= ile: No suck file or directory at /usr/lib64/perl5/DynaLoader.pm line 190at= (evel 13) line 3.complication failed in require at (eval 13) line 3.Perhap= s a required share library or ddl isn't installed where expected at /usr/lo= cal/share/perl5/Ora3Pg.pm line 1570=C2=A0 I removed /tmp/tmp_ora2pgdhwbrz and the error is still the same when I run = "ora2pg" what is the error at this time? thank you for your input. v/r,Bach-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 10:30 AM, Pepe TD Vo = wrote: =20 echo ORACLE_HOMEORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1/echo L= D_LIBRARY_PATHLD_LIBRARY_PATH /u01/app/oracle/product/12.2.0/dbhome_1/lib I even added the library on ora2pg.conf but didn't work. when I set both on command prompt and ora2pg is running but no result.=C2= =A0 Hung somewhere????=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:26 AM, Don Seiler wrot= e: =20 On Wed, Jan 23, 2019 at 8:16 AM Pepe TD Vo wrote: 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 Please share what the output of "echo $ORACLE_HOME" and "echo $LD_LIBRARY_P= ATH" is, to confirm that both are properly set. Do you have Oracle database= server installed on this host, or is this using instantclient?=C2=A0=C2=A0 do I need to set it on ora2pg.conf ? No, ora2pg will need to see it in your shell session's environment. Don.=C2=A0--=20 Don Seiler www.seiler.us =20 =20 ------=_Part_2429321_346508525.1548263832910 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I reset and the ora2pg run with 65 tables 100% scanning and the = server timeout.

reconnec= t the server and reset the LD_LIBRARY_PATH and ORACLE_HOME from command pro= mpt and I rerun ora2pg with background I get:

FATAL: can not remove old temporary file /tmp/tmp= _ora2pgdhwbrz
install_d= river(oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Or= acle.so' for module DBD::Oracle: libclntsh.so.12.1: cannot open shared obje= ct file: No suck file or directory at /usr/lib64/perl5/DynaLoader.pm line 1= 90
at (evel 13) line 3.
complication failed in require at (eval 13) line 3.
Perhaps a required share library or ddl= isn't installed where expected at /usr/local/share/perl5/Ora3Pg.pm line 15= 70
 

=
I removed /t= mp/tmp_ora2pgdhwbrz and the error is still the same when I run "ora2pg"

=
what is the = error at this time?

thank you for your input.

v/r,
B= ach-Nga

No one in this world is pu= re and perfect.  If you avoid people for their mistakes you will be al= one. So judge less, love and forgive more.
To c= all him a dog hardly seems to do him justice though in as much as he had fo= ur legs, a tail, and barked, I admit he was, to all outward appearances. Bu= t 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 10= :30 AM, Pepe TD Vo <pepevo@yahoo.com> wrote:

echo ORACLE_HOME
ORACLE_HOME /u= 01/app/oracle/product/12.2.0/dbhome_1/
echo LD_LIBRARY_PATH
LD_LI= BRARY_PATH /u01/app/oracle/product/12.2.0/dbhome_1/lib

I even added the library on ora2pg.conf but didn't work.
when I set both on command prompt and ora2pg is running but no resul= t.  Hung somewhere????
 
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= .
<= span class=3D"yiv4710796244sg">To call him a dog ha= rdly 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 k= new him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love ge= nerously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing succes= s


On Wednesday, January 23, 2019 9:26 AM, Don Seiler <don@seiler.= us> wrote:


On Wed, Jan 23, 2019 at 8:16 A= M Pepe TD Vo <pepevo@yaho= o.com> wrote:
<= div>
i am using oracle database server.  the LD_LIB= RARY_PATH already declared as  $ORACLE_HOME/lib  befo= re running ora2pg

Please share what the output of "echo $ORACLE_HOME" and "echo $LD_L= IBRARY_PATH" is, to confirm that both are properly set. Do you have Oracle = database server installed on this host, or is this using instantclient?&nbs= p;
 
do I need to set it on = ora2pg.conf ?

<= /div>
No, ora2pg will need to see it in your shell session's environmen= t.

Don. 
--
Don Seiler
www.seiler.us


=


------=_Part_2429321_346508525.1548263832910--