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 1gMasp-0001uS-Vl for pgsql-admin@arkaria.postgresql.org; Tue, 13 Nov 2018 15:45:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gMaso-00040M-B1 for pgsql-admin@arkaria.postgresql.org; Tue, 13 Nov 2018 15:45:42 +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 1gMapS-0008Vy-Rh for pgsql-admin@lists.postgresql.org; Tue, 13 Nov 2018 15:42:15 +0000 Received: from sonic303-3.consmr.mail.bf2.yahoo.com ([74.6.131.42]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMapN-00088Y-JL for pgsql-admin@postgresql.org; Tue, 13 Nov 2018 15:42:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1542123727; bh=mmVKZoXHZPzDO4pxLH4fgo6K9oyi0GU5pcJbX9sMdsI=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=pHbgbAUZzFK329p6nmz9snDJzVvuEIP59tiY/waVpJfZBG0yIFY/vujQUuwBtF/E0RvGaSiwHEIcjNCnIeyhp/EqJ9sz+QxxyNHnTLKxtxJFDEsQO8sVd3gn4RybGrXY9fxPEJY6gu9k37Fdg4aehLcL6AE113invCNTkMol1HYGIM6EIZU/AHlMfSNWBO1w5Fqymid6Oe2hZZPtkgWmSKTGN5jDbUVsF+CRreMFzydTdecDb2f/Tar1VqdcU2lSkUAmWWgrQI474Usxr6WxDXl2/SRHWhVEgoeZw6XvEB1BH/fPj0rDpCyPsGjnWrpc3pag5Vk8Ga6Zc4mrG24dwA== X-YMail-OSG: 4afwWDsVM1lRCs6v5I5MrvvGJ_ehiaAQ06lLcXkvI118bjZT.kmF.NW_70dSzcQ EnL._fypE6KNM7aWiwsA_ZW0q1XZRp4zJ3TuW0Qdz0._uaqLs7k.aIyHnL6QmCgHfKEXee11qE_Z BqKSicv2ms0HBD2TCmTgx5ycH2XWu_fb6idPgawozOTuK9waIpzegOPaRCEtAvr.B3LCX7RN2rsz K.E7WVXrlonwO18ZjN.b9mcFQsMOv68kyiuyi4c4kwctVYvVZQscpxEPpRtQgDYaU8sa.KH8z0uN yNFDU1nqBIvnUjw_cP5_80IMdBajo5STcLklEIc2bQJlpfJEXPttPq77PVP6A4HB8DJx6mli2puZ DZHWgBMAMgnRWGpHWkjupOhpcdSCKO2RQSjghUvk2ZxBbRb39QnOJlCuBIuzfMOFWxdUMBW0S1Il arLyVbj_nGt84bFaFvJ7hvX9mXsG6GKGRjm5KvSO.Z25XxW7XGx.z14MZszmBigYMWrE_Le3sx4S SUF8zAvr3T93iG0yB2wlqUrW8nHSTa.Zt7lgCyMHMACuxrksLlIuQ4NP.3BZrEY4PHMMNWFzTfnz 8wg2McvSYWQ.rvhgFufldNC8GSssKNqJZSWTmQBsuGtjRKFiWyUslcysRtgGTBjpr683FQcrnGFL UVDt_.B6LhESXt2J8JnoWVk7P9iFJTXQRiGgjwd7MeYrybH2WlWgWFvyTfUuLiLk147PGPOUwLCx 6CVa6B0DNxSenbRpFaUx3Py6iUsZp5fgKiCsBko.QGdc3d9Cf6_3q1Yrj9Q6oIZZ1EKpGhJ034XV 59JjdNSDT9R6biqSGs8JCxmB_32UwF6RJc_YpuWzBpc4fMs2QnJydKio5UQf8865t32FJisOlmAE KADAzjwtHhnWaJcofktsOYM6BE89Hlko5OFJGLNtyqy.fU.j_9ACln.DH0v.qfsNwBM5GNb2GJ_N .125aLjq.SCXbr.BwQLic1u717MoUPmd.ztW7pwU67iFzLXgsRK4vT3YvTrSuX6iAiDpQab5JmvG V Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.bf2.yahoo.com with HTTP; Tue, 13 Nov 2018 15:42:07 +0000 Date: Tue, 13 Nov 2018 15:41:58 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "soumik.bhattacharjee@kpn.com" , "pgsql-admin@postgresql.org" Message-ID: <1152897292.1627397.1542123718889@mail.yahoo.com> Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1627396_1706068217.1542123718883" References: <1152897292.1627397.1542123718889.ref@mail.yahoo.com> X-Mailer: WebService/1.1.12732 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36 Content-Length: 18208 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1627396_1706068217.1542123718883 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable correct me if I'm wrong,your ora2pg.conf is under /etc/ora2pg and you point= ed it on config/ora2pg.conf, that's why it's not found.=C2=A0 =C2=A0 # pwd/etc/ora2pg# ora2pg -t SHOW_VERSION -c config/ora2pg.confsh: ora2pg:= =C2=A0 not found. just runora2pg -version Also, you have a network issue and the ora2pg is not promptly installed, sh= ould be more files than just a configuration file. did you modify ora2pg.conf after copy from ora2pg.config.dist to match what= your db information such as oracle_sid, oracle_user, etc...? i would love to know more about ora2pg for use in a few months.=C2=A0 Pleas= e share your knowledge and/or 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 =20 On Tuesday, November 13, 2018 5:11 AM, "soumik.bhattacharjee@kpn.com" wrote: =20 #yiv2936877444 #yiv2936877444 -- filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}= #yiv2936877444 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;= }#yiv2936877444 p.yiv2936877444MsoNormal, #yiv2936877444 li.yiv2936877444Ms= oNormal, #yiv2936877444 div.yiv2936877444MsoNormal {margin:0in;margin-botto= m:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv2936877444 a:link, #= yiv2936877444 span.yiv2936877444MsoHyperlink {color:#0563C1;text-decoration= :underline;}#yiv2936877444 a:visited, #yiv2936877444 span.yiv2936877444MsoH= yperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv2936877444 s= pan.yiv2936877444EmailStyle17 {font-family:sans-serif;color:windowtext;}#yi= v2936877444 .yiv2936877444MsoChpDefault {font-family:sans-serif;}#yiv293687= 7444 filtered {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv2936877444 div.y= iv2936877444WordSection1 {}#yiv2936877444 Hello, =C2=A0 I am trying to ins= tall ora2pg in HPUX server and also the DBD::Oracle =C2=A0 Please let me k= now your inputs as to how to go ahead. =C2=A0 # ls -ltr total 256 -rw-r--r= --=C2=A0=C2=A0 1 root=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 root=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 61548 Nov 12 12:30 ora2pg.conf.dist -r= w-r--r--=C2=A0=C2=A0 1 root=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 root=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 61548 Nov 12 12:30 ora2pg.conf #= pwd /etc/ora2pg # ora2pg -t SHOW_VERSION -c config/ora2pg.conf sh: ora2pg:= =C2=A0 not found. =C2=A0 # perl -MCPAN -e shell =C2=A0 There seems to be = running another CPAN process (pid 1667).=C2=A0 Contacting... Other job not = responding. Shall I overwrite the lockfile? (Y/N) [y] y =C2=A0 cpan shell = -- CPAN exploration and modules installation (v1.61) ReadLine support avail= able (try 'install Bundle::CPAN') =C2=A0 cpan> get DBD::Oracle CPAN: Stora= ble loaded ok Going to read /home/root/.cpan/Metadata Warning: Found only 0= objects in /home/root/.cpan/Metadata LWP not available CPAN: Net::FTP load= ed ok Fetching with Net::FTP: =C2=A0 ftp://ftp.perl.org/pub/CPAN/authors/01= mailrc.txt.gz Issuing "/usr/bin/ftp -n" ftp: connect to address ::ffff:130.= 161.131.20: Network is unreachable Trying ::ffff:131.211.31.189... ftp: con= nect: Network is unreachable Not connected. Local directory now /home/root/= .cpan/sources/authors Not connected. Not connected. Not connected. Not conn= ected. Not connected. Not connected. Bad luck... Still failed! Can't access= URL ftp://ftp.perl.org/pub/CPAN/authors/01mailrc.txt.gz. =C2=A0 Please ch= eck, if the URLs I found in your configuration file () are valid. The urlli= st can be edited. E.g. with 'o conf urllist push ftp://myurl/' =C2=A0 Coul= d not fetch authors/01mailrc.txt.gz LWP not available Fetching with Net::FT= P: =C2=A0 ftp://ftp.perl.org/pub/CPAN/modules/02packages.details.txt.gz = =C2=A0=20 =20 ------=_Part_1627396_1706068217.1542123718883 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
correct me if = I'm wrong,
your ora2pg.conf is under /etc/ora2pg and you pointed it on= config/ora2pg.conf, that's why it's not found.   

# pwd
/etc/ora2pg
# ora2pg -t SHOW_VERSION -c config/ora2pg.conf
sh: ora2pg: = not found.

just run
ora2pg -version

Also, you have a network issue and the ora2pg is not promp= tly installed, should be more files than just a configuration file.
did you modify ora2pg.conf after copy from ora2pg.config.dist to ma= tch what your db information such as oracle_sid, oracle_user, etc...?
=
=
i would love to know more about ora2pg for use in a few months.&n= bsp; Please share your knowledge and/or input.

v/r,
=
Bach-Nga

No one in t= his 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 d= og 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 **Lo= ve generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing s= uccess
=

<= div class=3D"qtdSeparateBR">

On Tuesday, November 13, 2018 5:11 AM, "soumik.bhattacharjee@k= pn.com" <soumik.bhattacharjee@kpn.com> wrote:


=20 =20
Hello,=20
 =20
I am trying to i= nstall ora2pg in HPUX server and also the DBD::Oracle
=20
 =20
Please let me know your inputs as to how to go ahead.
=20
 =20
# ls -ltr=
=20
total 256=
=20
-rw-r--r-- =   1 root       root   &nb= sp;     61548 Nov 12 12:30 ora2pg.conf.dist=20
-rw-r--r-- =   1 root       root   &nb= sp;     61548 Nov 12 12:30 ora2pg.conf
=20
# pwd=20
/etc/ora2pg
=20
# ora2pg -t SHOW= _VERSION -c config/ora2pg.conf
=20
sh: ora2pg: = ; not found.
=20
 
=20
# perl -MCPAN -e= shell
=20
 =20
There seems to b= e running another CPAN process (pid 1667).  Contacting...
= =20
Other job not re= sponding. Shall I overwrite the lockfile? (Y/N) [y] y
=20
 =20
cpan shell -- CP= AN exploration and modules installation (v1.61)
=20
ReadLine support= available (try 'install Bundle::CPAN')
=20
 =20
cpan> get DBD= ::Oracle
=20
CPAN: Storable l= oaded ok
=20
Going to read /h= ome/root/.cpan/Metadata
=20
Warning: Found o= nly 0 objects in /home/root/.cpan/Metadata
=20
LWP not availabl= e
=20
CPAN: Net::FTP l= oaded ok
=20
Fetching with Ne= t::FTP:
=20
  ftp://ftp= .perl.org/pub/CPAN/authors/01mailrc.txt.gz
=20
Issuing "/usr/bi= n/ftp -n"
=20
ftp: connect to = address ::ffff:130.161.131.20: Network is unreachable
=20
Trying ::ffff:13= 1.211.31.189...
=20
ftp: connect: Ne= twork is unreachable
=20
Not connected.
=20
Local directory = now /home/root/.cpan/sources/authors
=20
Not connected.
=20
Not connected.
=20
Not connected.
=20
Not connected.
=20
Not connected.
=20
Not connected.
=20
Bad luck... Stil= l failed!
=20
Can't access URL= ftp://ftp.perl.org/pub/CPAN/authors/01mailrc.txt.gz.
=20
 =20
Please check, if= the URLs I found in your configuration file () are valid.
=20
The urllist can = be edited. E.g. with 'o conf urllist push ftp://myurl/'
=20
 =20
Could not fetch = authors/01mailrc.txt.gz
=20
LWP not availabl= e
=20
Fetching with Ne= t::FTP:
=20
  ftp://ftp= .perl.org/pub/CPAN/modules/02packages.details.txt.gz
=20
 =20


------=_Part_1627396_1706068217.1542123718883--