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 1gmKUA-0003XA-35 for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2019 15:30:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmKU8-0004JS-Tp for pgsql-admin@arkaria.postgresql.org; Wed, 23 Jan 2019 15:30:36 +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 1gmKU8-0004Fc-D6 for pgsql-admin@lists.postgresql.org; Wed, 23 Jan 2019 15:30:36 +0000 Received: from sonic308-3.consmr.mail.bf2.yahoo.com ([74.6.130.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmKU5-0007yr-24 for pgsql-admin@lists.postgresql.org; Wed, 23 Jan 2019 15:30:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548257431; bh=oc8s29rEg9QV4nwcwyVvqeF9RkUYlxoDFgiDJn/ORC0=; h=Date:From:Reply-To:To:Cc:Subject:References:From:Subject; b=E34tRuYMcO3Epq3TgEd/veop0PCyVpCckZULKfyhjjIXqUS5FqGqnt87saOFNjH9/CIb4IYrdAm4mwWF/r2fQmW16mfXplI67JG0bsTlclPMVxFNooSRZJRX1WJ6YGHkC0lUW+9EGT+zMF9sltSGlmzLKmT0MRtQ400hKyZ0CaSKWYpXumDl2Hh3X5JeQtdWEOGFjQ8WLsSqqY115ay2Yna62KUpTcDyt5DHKq3+Tp5TjpGVkvWvLKJvKQHmVzi2fo9I8p8PbE1YxBXZgtIkqvnBVY7jC3u4Z2zFjbzXsA1RH/n+pa3g3Tk3PgRSKiLCaQ3MFIUOA8/fpHd7Tk6EDA== X-YMail-OSG: 2YjIO9IVM1nLVzHxWGgNQKTk0cyCclVN.7GABzQMMhMnCAkr8HJn7nKDQ9xr2SN I_oEXfJQZo5ZlumMP1a4TtnGCx.73m_GHZK3zaz067SACPreeToGtuZQKI86CSjSLfl.rTbWzWc4 1itFEFdAyXAk1eFaAA3WcHAQMd59SYfNv_G3P.a2icO2aNVYl6MNUxOdPdvtNi52CYNs2Aam1W4i PdWwPkSzpUMBnYXZ7vMSrl2gP.p9dqs4VQmBcavgBVyabQLeJUOrGCFyV0EmLn_61snrDj4OagC. Z9xNYSmvSdtUIHjDdztBssjU1Z8HGyHm6Tjavd0PeYe8xQM7Yl_mWAsbh0GEm5kgbjH6Cho170EL QtU5fSy287gBUNUf_totAblIsOWUZH6CG4uSt_iyuG.dcfnuf1pihVvZL1whsH8tfkuS.7E8c.6P xbn1R7sLDJR69eMD7OP2ReQ7VmDASiWJu_dHq1Elm6uZbdQPNwBelt05rbbSOXKzoCVBiHzFx0UY IM_uCMp5cJZ5XWxharPJTS_Ed0JSQDdt9uE2pIdNJAyXso_yRK12p8Mac0s0FAErilqkfiz8IhfT J9xwfTqVC8fiSz8tE1oXOjnMA2MLQ1TohgPW7GdzhdSQBC433gD6.MCW47oVcgBpRuhuWz22jLYi pJX31AKM1dmMvmAyCIVdRK6S.zbZziRiqXL7ZhCSdKTSZ38gR4xUnX6rICMjxXGeelZZGYtJ0AiV HJGxNJmBbSIGJO3NxKphTZTf2Pw25m7qL96PP6_NqMTrw_pl7v_rotUkc2z3fEkImrMg9x9AZYHK B4yDlbwPi58ibApZAqu2vB3FE0fP9rh4U9d.odXVkOj.wKSnBOjAG0XbGgZvKRlRlgP6MuIEblhb oNBwUNrxNKrsqe_.08wtoTIdYQ9doZCxsntMjgXYMap0AA01nagr18RAuvOeha8ajN0PXzm9WAkc Zq7ZbklfCU7MNrltl5HVsbY2hKPOA.lKmObSnpEUkXMNfVfPOVf4xMktA3zLFSdy8Gq.rC.9wQ8D eN_NJkwdAHnVrbNTsi9UegMFFiWhGasVJVxbvT90oiId5CGqBZlMptHNOLOfZ0p2ooaI- Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.bf2.yahoo.com with HTTP; Wed, 23 Jan 2019 15:30:31 +0000 Date: Wed, 23 Jan 2019 15:30:29 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Don Seiler Cc: Shreeyansh Dba , Pgsql-admin Message-ID: <34359708.2383722.1548257429166@mail.yahoo.com> Subject: Re: ora2pg perl module error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2383721_782757238.1548257429164" References: <34359708.2383722.1548257429166.ref@mail.yahoo.com> 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: 8359 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_2383721_782757238.1548257429164 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable echo ORACLE_HOMEORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1/echo LD= _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 ------=_Part_2383721_782757238.1548257429164 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
echo ORACLE_HOME
ORAC= LE_HOME /u01/app/oracle/product/12.2.0/dbhome_1/
echo LD_LIBRARY_PAT= H
LD_LIBRARY_PATH /u01/app/oracle/product/12.2.0/dbhome_1/lib
I even added the library on ora2pg.conf but didn't wo= rk.

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 forgive more= .
<= span class=3D"yiv6720516889sg">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, 201= 9 9:26 AM, Don Seiler <don@seiler.us> wrote:


On Wed, Jan 23, 2019 at 8:16 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
i am using or= acle 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 Oracle database server installed on this hos= t, 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 environment.

Don. 
--
Don Seiler
www.seiler.us


<= /html> ------=_Part_2383721_782757238.1548257429164--