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 1gmja8-0001TA-Cn for pgsql-admin@arkaria.postgresql.org; Thu, 24 Jan 2019 18:18:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmja5-0005zY-41 for pgsql-admin@arkaria.postgresql.org; Thu, 24 Jan 2019 18:18:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmja4-0005zR-Er for pgsql-admin@lists.postgresql.org; Thu, 24 Jan 2019 18:18:24 +0000 Received: from sonic307-3.consmr.mail.bf2.yahoo.com ([74.6.134.42]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmja1-0003h0-BM for pgsql-admin@lists.postgresql.org; Thu, 24 Jan 2019 18:18:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548353897; bh=NYYa08ZtUt7igcG38aWOQNXN0bAdq4EDpqa1CvUhNSQ=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=L6kObi98w4fmVXe23/6hTCPDJH8Oe4/iYGNjVppWaJSo/VXUw6IwZDultFIe1p8p35y7cVDnfc/rS//y6lF5VxR6fTcl7MhewZF4j//yCqMcTixLC3gB7fA0xxHkr8Bu7zemh89Zp/4qB59i48DTTZrjJs/xSWzmZcfrXo5t/iBsE3eG2koql57hb2Mv3Dl0ka++jIGbGv/sSNyRg1WDkdUBTgG0gK6S/kaaIjJHDh2gAED6F8GZpcbFjeUo3hRHzmUKMmysAXj8Iklpw/HDxJobGGlGZiQWYpe3UHqaPfstuLoSvZyENnfDroG636wd7bkLfNYFGLh7tKl0Dtvy+w== X-YMail-OSG: 82h5hNwVM1m0tfNYRB15p.kiT2IY.CgPaI9mgu2VmX.W1NBuifokkWe9SX4bRy1 BC4kXKkfKOGS9qR9IKF7JKNcVk5c0F0e6iQYOmn.JYKOLaDCGIXvB6pusJ.BqAZ4v8OymaEpR32A pZ3jXOtwSf856mnqOzD6pHcttvZDm0bhJPoR3DstUT8Hko9MMHxsbNbU9c8scxM._Oad.HaaM1IT wOfnk_XO42Es5Jky1iOE86ueWFuWtlyaBZVU2ZqUOkxtU6Z7YW.I.YVTi__W2Mxhavol74AcOT3r Pe5Ho49PwWSEHHSAVPVFtNJNawaZJj5Ng7F0MVVt_HkjlEnUKYF2g.SlyPbZB47hm_tByG61RM2U BjrGCmO7YhQlTIYpX7jiVySEMQMU7LTXbOYArV.IJ5UpY.7Z7D42IrecUxXyC2pcwbZr8kuKaiAN yX2T6lxUPGfdViTzKJ..jrGxDP5cwJIdvToAuy9vE40BqwKd3NuFpen9DFyTBFP3F3i6MI_GikXF .2Jk9hRVoYQMVpXA9Ca_0ZAxF1QmQukis10veikRZ0BlUMxcNbq0RcdB9LJ7LoLZg8lELxQAAKVu IZPqvKaEGiQPIq2iwDQI2S38EYALAh1ykOPiMT4giFcDsENa8rwks4h77f0VdGM86NW42r4YRofe S8fDm80tSyxjoOCwxUYGas3zEyJ1E4U5Up8xlGWob7T3oH8Ys7vXP9VroIIIsSd34M2pYY7ip.e1 ArCN2BrlCG1c.xoGu6_xhwEh4UBZqTQp4.VIF3wD1bB4683x_6BCGApdTlMrPcZq35rgMgonPUAs zuJlDYJWZWyYQEmsEMQnnvCBBTI7bWFEOAatLv6aOSodGNumSWtpzLAKIhlH405V7BOMn9Me7rx9 BOPLBelEHhibBwONZcuypwxYno1g3LEQFeiNLAtJdXYtbYXSYSwhuzSasZO8CKtkRxXROSFQgRjJ 95j2lTVQtcfTnGUFkOgnPWvbF8.9UjfKjG.Y8nE.o65PsHLF1AHwJ1LAMtWYB_0go3ZI7kQUQv7t T5IgHeWFPXSTe37koCn8PQOL2afWUKZN4iN6r86.NRbJxDWmj3Ls85pNoq57P6NUyOTBN Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.bf2.yahoo.com with HTTP; Thu, 24 Jan 2019 18:18:17 +0000 Date: Thu, 24 Jan 2019 18:18:15 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Don Seiler Cc: Shreeyansh Dba , Pgsql-admin Message-ID: <2134930529.547389.1548353895875@mail.yahoo.com> In-Reply-To: <1924376145.2429322.1548263832913@mail.yahoo.com> References: <34359708.2383722.1548257429166.ref@mail.yahoo.com> <34359708.2383722.1548257429166@mail.yahoo.com> <1924376145.2429322.1548263832913@mail.yahoo.com> Subject: Re: ora2pg perl module error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_547388_1500087067.1548353895872" X-Mailer: WebService/1.1.13027 YMailNorrin 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: 19884 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_547388_1500087067.1548353895872 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I reset all and rerun ora2pg with nohup.out.=C2=A0 I found out the output.s= ql didn't locate on the output directory (/u02) I specified in the ora2pg.c= onf.=C2=A0 Turned out it stop the process via fill up all root partition.= =C2=A0 why the output is not on /u02 but root ?=C2=A0 How do I run ora2pg a= nd/or relaunch it? 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, 12:17:37 PM EST, Pepe TD Vo wrote: =20 =20 I reset and the ora2pg run with 65 tables 100% scanning and the server tim= eout. 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_547388_1500087067.1548353895872 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I= reset all and rerun ora2pg with nohup.out.  I found out the output.sq= l didn't locate on the output directory (/u02) I specified in the ora2pg.co= nf.  Turned out it stop the process via fill up all root partition.&nb= sp; why the output is not on /u02 but root ?  How do I run ora2pg and/= or relaunch it?

Bac= h-Nga

No one in this world is pure= and perfect.  If you avoid people for their mistakes you will be alon= e. So judge less, love and forgive more.
To call him a dog hardly seems to d= o 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, h= e was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care d= eeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing succe= ss


=20
=20
On Wednesday, January 23, 2019, 12:17:37 PM EST, Pepe T= D Vo <pepevo@yahoo.com> wrote:


I reset and = the ora2pg run with 65 tables 100% scanning and the server timeout.<= /div>
=
reconnect the server and reset the LD_LIBRARY_PATH a= nd ORACLE_HOME from command prompt and I rerun ora2pg with back= ground I get:

FATAL: can not remove old temporary fil= e /tmp/tmp_ora2pgdhwbrz
install_driver(oracle) failed: Can't load '/usr/= local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libcln= tsh.so.12.1: cannot open shared object file: No suck file or directory at /= usr/lib64/perl5/DynaLoader.pm line 190
at (evel 13) line= 3.
complication failed in require at (eval 13) line 3.
Perhaps a req= uired share library or ddl isn't installed where expected at /usr/local/sha= re/perl5/Ora3Pg.pm line 1570
 

I remov= ed /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,
<= /font>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.<= /div>
To call him a do= g hardly seems to do him justice though in as much as he had four legs, a t= ail, and barked, I admit he was, to all outward appearances. But to those w= ho knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Lov= e generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing su= ccess
<= br clear=3D"none">
=
On Wednesday, January 23,= 2019 10:30 AM, Pepe TD Vo <pepevo@yahoo.com> wrote:


echo ORACLE_HOME
ORACLE_HOME /u01/app/or= acle/product/12.2.0/dbhome_1/
echo LD_LIBRARY_PATH
LD_LIBRARY_PAT= H /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.  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 forgiv= e 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 **L= ove generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing = success


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

On Wed, Jan 23, 2019 at = 8:16 AM Pepe TD Vo <pepev= o@yahoo.com> wrote:
i am using oracle database server.  the LD= _LIBRARY_PATH already declared as  $ORACLE_HOME/lib  = before running ora2pg

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

No, ora2pg will need to see it in your shell session's enviro= nment.

Don. 
--
Don Seiler
www.seiler.us


=


------=_Part_547388_1500087067.1548353895872--