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 1gMc1d-0005bD-Vz for pgsql-admin@arkaria.postgresql.org; Tue, 13 Nov 2018 16:58:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gMc1b-0000HE-PX for pgsql-admin@arkaria.postgresql.org; Tue, 13 Nov 2018 16:58:51 +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 1gMc1a-0000Gr-7n for pgsql-admin@lists.postgresql.org; Tue, 13 Nov 2018 16:58:50 +0000 Received: from sonic301-4.consmr.mail.bf2.yahoo.com ([74.6.129.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMc1W-00011B-Ha for pgsql-admin@postgresql.org; Tue, 13 Nov 2018 16:58:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1542128325; bh=UOgMGEirjgWRVHEZA5xD1r3Z8xKmYk97HAITbgeqr5U=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=ozK1/YQ3P+nbrqV6Z9/LAn7XMWeVeTY/hGol9XxVlumbfPFaGwF0hsRXCM3GZnzJoILhaItI5m0Q+J0mr4Rk0tUieANDE0jCzYTCEz9vmdRibPcbBbbECybg7k24zxX7VXr8Syy+8fLxWtqYwawowXI0TEgzsu+BPMyiIQT80E3aIjPKkKs3tzeQrwgJxcyCX1AABvA8FlXYsRYisQOVbU8qIC6NT4g6nFKvk0DZsntjBGw4XECSHIYyPo477wAOeoPRDvLxeiy1HGzzK2pefi/vs8ibT4coZIcioozTbS4mPQutFGtMOKxQQqpfn0N9sTtn9MaoiR3wwpmuFEvOLQ== X-YMail-OSG: JoDb8XIVM1kBxzjiIpnKQsKX8YnzX33VCk_tQIe3LdQmGkRUVm2jDtniKL9KWRa 7a3CEXXIP9RQxG4lJ817t6.4H1QUQKwwY.hPxuFf5Gy6CiDH0YSxV9EZA2wFKf0zX6FSFeGEOH51 vb9AUp3xuR8JQB2lHNANZYboUH3oHwagL9tJkgbvR3mpLxvWynxhnG9ZZa8ymuK4dfKexQ7mz38z sDy2w8PIBwytAojw02muenYmtavMi0wdmYgWSmomH2092qZ6IM5Ix3lGNQi9s.qo7SfseZIOQ4gm TbA7fEl1VwpCraPcfAsAdlPkUiHEM5CP9AXZdOD.JOoMkmr1uowH75w7XIqqb7UBN9ypfzl1w_U2 W02ol7TQwNdQ5vR_q1cOUIaKruzo7s1jF2aLaLKgUAV593fsXfAPXzK3zPPrKq50HygSiCjSSfQ5 aWP9YswLVeanalop.UEqHkEINeFwRDW8liQ38qlB.LmOtcRZIONBGyLuJ4ge58cW7QwzyjiXm_C1 30UEoRVHKGnu.7fl6a7hhockDAb8tyRHf0_93E.sndxZIN5E.XTAzb0qnU.dBKin73JgH93tr83K KT9fs8O.lZHbfNReSNjhAU93vGikD.dZRV8fi925ElGIHMh3EhQ0KF74gpUrMxXcVmu3wlpW8uUe slrou18XDsQntTzOzBhUCbjv4hO8ACONqy7RqGarItfrMmprZ9wDniI.2Mqijza1y3GcDx1ldbX2 6b1BuI5UxUavVIQYkk5Po9f9U4eRLom9VlcMBowXsWS6v2N3x18bxsgsjGWaFfnBvSX21sPZT04T MZ3o99jRF1lYVMSOsaiTzVaZVPT1EEB4kKvAaqgQ4jh2xkwqLvdepbcNWP2O3j0fiAv_h_bplgwL nLQpAaEFN1CP9So1mQRrOKDjZn68Fn2k51bTQTIrHZKIeSvFPnHUmD6zDOFESCGVDCUZlutZes13 pgiCs0ceYA._vbBh28skOaJItX4XekM6mroClhzSN_Ob0By6nKC1vDCixqzSEGCOBAk6OIf2_F3m s6HDhzgKIEeE- Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.bf2.yahoo.com with HTTP; Tue, 13 Nov 2018 16:58:45 +0000 Date: Tue, 13 Nov 2018 16:58:33 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "soumik.bhattacharjee@kpn.com" , "pgsql-admin@postgresql.org" Message-ID: <1411969476.1678909.1542128314015@mail.yahoo.com> In-Reply-To: <1262128724.1675314.1542127815835@mail.yahoo.com> References: <1152897292.1627397.1542123718889.ref@mail.yahoo.com> <1152897292.1627397.1542123718889@mail.yahoo.com> <2A91BEF8171A5349931391E0C721CC5305D660F4@CPEMS-KPN301.KPNCNL.LOCAL> <1262128724.1675314.1542127815835@mail.yahoo.com> Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1678907_1164978546.1542128313996" 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: 43285 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1678907_1164978546.1542128313996 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable for uninstall orag2pg, just run the uninstaller.sh or remove the whole fold= er. If it's in Window, run uninstaller.exe or choose uninstall program from= control panel.=C2=A0 FYI, I'm researching myself and document and preparing for work.=C2=A0 I ha= ven't tried yet.=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 Tuesday, November 13, 2018 11:50 AM, Pepe TD Vo w= rote: =20 I think you have missing files.=C2=A0 I have researched myself and prepare= to install orapg2 to use and convert=C2=A0 Oracle off to Postgres.=C2=A0 T= ry to follow this link, it might help to make and reconfigure ora2pg step b= y steps.=C2=A0=C2=A0 https://blog.dbi-services.com/migrating-from-oracle-to-postgresql-with-ora2= pg/ =C2=A0 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 Tuesday, November 13, 2018 11:40 AM, "soumik.bhattacharjee@kpn.com" = wrote: =20 #yiv4450925973 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 = 2 2 4;}#yiv4450925973 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv445092597= 3 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv44509259= 73 filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv4450925= 973 p.yiv4450925973MsoNormal, #yiv4450925973 li.yiv4450925973MsoNormal, #yi= v4450925973 div.yiv4450925973MsoNormal {margin:0in;margin-bottom:.0001pt;fo= nt-size:12.0pt;font-family:New serif;}#yiv4450925973 a:link, #yiv4450925973= span.yiv4450925973MsoHyperlink {color:blue;text-decoration:underline;}#yiv= 4450925973 a:visited, #yiv4450925973 span.yiv4450925973MsoHyperlinkFollowed= {color:purple;text-decoration:underline;}#yiv4450925973 p.yiv4450925973mso= normal0, #yiv4450925973 li.yiv4450925973msonormal0, #yiv4450925973 div.yiv4= 450925973msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font= -family:New serif;}#yiv4450925973 span.yiv4450925973sg {}#yiv4450925973 p.y= iv4450925973msonormal, #yiv4450925973 li.yiv4450925973msonormal, #yiv445092= 5973 div.yiv4450925973msonormal {margin-right:0in;margin-left:0in;font-size= :12.0pt;font-family:New serif;}#yiv4450925973 p.yiv4450925973msochpdefault,= #yiv4450925973 li.yiv4450925973msochpdefault, #yiv4450925973 div.yiv445092= 5973msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;font-f= amily:New serif;}#yiv4450925973 span.yiv4450925973msohyperlink {}#yiv445092= 5973 span.yiv4450925973msohyperlinkfollowed {}#yiv4450925973 span.yiv445092= 5973emailstyle17 {}#yiv4450925973 p.yiv4450925973msonormal1, #yiv4450925973= li.yiv4450925973msonormal1, #yiv4450925973 div.yiv4450925973msonormal1 {ma= rgin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yi= v4450925973 span.yiv4450925973msohyperlink1 {color:#0563C1;text-decoration:= underline;}#yiv4450925973 span.yiv4450925973msohyperlinkfollowed1 {color:#9= 54F72;text-decoration:underline;}#yiv4450925973 span.yiv4450925973emailstyl= e171 {font-family:sans-serif;color:windowtext;}#yiv4450925973 p.yiv44509259= 73msochpdefault1, #yiv4450925973 li.yiv4450925973msochpdefault1, #yiv445092= 5973 div.yiv4450925973msochpdefault1 {margin-right:0in;margin-left:0in;font= -size:12.0pt;font-family:sans-serif;}#yiv4450925973 span.yiv4450925973Email= Style29 {font-family:sans-serif;color:#1F497D;}#yiv4450925973 .yiv445092597= 3MsoChpDefault {font-size:10.0pt;}#yiv4450925973 filtered {margin:70.85pt 7= 0.85pt 70.85pt 70.85pt;}#yiv4450925973 div.yiv4450925973WordSection1 {}#yiv= 4450925973 Thanks Pepe and St=C3=A9phane =C2=A0 Now i tried to install thi= s in a different HPUX server usingroot, and below it comes =C2=A0 Also wha= t are the uninstallation steps if anyone knows. =C2=A0 Thanks All. =C2=A0= =C2=A0 # perl Makefile.PL Can't open scripts/ora2pg: No such file or dire= ctory. WARNING: META_MERGE is not a known parameter. WARNING: DESTDIR is no= t a known parameter. WARNING: LICENSE is not a known parameter. 'DESTDIR' i= s not a known MakeMaker parameter name. 'LICENSE' is not a known MakeMaker = parameter name. 'META_MERGE' is not a known MakeMaker parameter name. Writi= ng Makefile for Ora2Pg =C2=A0 Done... ------------------------------------= ------------------------------------------ Please read documentation at htt= p://ora2pg.darold.net/ before asking for help -----------------------------= ------------------------------------------------- Now type: make && make in= stall =C2=A0 # make && make install make: *** No rule to make target `scri= pts/ora2pg', needed by `blib/script/ora2pg'.=C2=A0Stop. =C2=A0 =C2=A0 = =C2=A0 From: Pepe TD Vo Sent: Tuesday, November 13, 2018 4:42 PM To: Bhattacharjee, Soumik ; pgsql-admin@postg= resql.org Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs =C2=A0 co= rrect me if I'm wrong, your ora2pg.conf is under /etc/ora2pg and you pointe= d it on config/ora2pg.conf, that's why it's not found.=C2=A0 =C2=A0 =C2=A0= #pwd /etc/ora2pg # ora2pg -t SHOW_VERSION -cconfig/ora2pg.conf sh: ora2pg:= =C2=A0 not found. =C2=A0 just run ora2pg -version =C2=A0 Also, you have a= network issue and the ora2pg is not promptly installed, should be more fil= es than just a configuration file. =C2=A0 did you modify ora2pg.conf after= copy from ora2pg.config.dist to match what your db information such as ora= cle_sid, oracle_user, etc...? =C2=A0 i would love to know more about ora2p= g for use in a few months.=C2=A0 Please share your knowledge and/or input. = =C2=A0 v/r, =C2=A0 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 cal= l 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)= =20 **Live simply **Love generously **Care deeply **Speak kindly. *** Genuinely= rich *** Faithful talent *** Sharing success =C2=A0 =C2=A0 On Tuesday, N= ovember 13, 2018 5:11 AM, "soumik.bhattacharjee@kpn.com" wrote: =C2=A0 Hello, =C2=A0 I am trying to install ora2pg in = HPUX server and also the DBD::Oracle =C2=A0 Please let me know 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 -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 # 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 a= nd modules installation (v1.61) ReadLine support available (try 'install Bu= ndle::CPAN') =C2=A0 cpan> get DBD::Oracle CPAN: Storable 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 loaded ok Fetching with Ne= t::FTP: =C2=A0ftp://ftp.perl.org/pub/CPAN/authors/01mailrc.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: connect: Network is unreac= hable Not connected. Local directory now /home/root/.cpan/sources/authors N= ot connected. Not connected. Not connected. Not connected. Not connected. N= ot connected. Bad luck... Still failed! Can't access URLftp://ftp.perl.org/= pub/CPAN/authors/01mailrc.txt.gz. =C2=A0 Please check, if the URLs I found = in your configuration file () are valid. The urllist can be edited. E.g. wi= th 'o conf urllist pushftp://myurl/' =C2=A0 Could not fetch authors/01mailr= c.txt.gz LWP not available Fetching with Net::FTP: =C2=A0ftp://ftp.perl.org= /pub/CPAN/modules/02packages.details.txt.gz =C2=A0 =C2=A0=20 =20 =20 ------=_Part_1678907_1164978546.1542128313996 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
for uninstall orag2pg, just run the uninstaller.sh or = remove the whole folder. If it's in Window, run uninstaller.exe or choose u= ninstall program from control panel. 

FYI, I'm researching myself and document an= d preparing for work.  I haven't tried yet.
 
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.
To call him a dog hardly seems to do him justi= ce though in as much as he had four legs, a tail, and barked, I admit he wa= s, to all outward appearances. But to those who knew him well, he was a per= fect gentleman (Hermione Gingold)

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


On= Tuesday, November 13, 2018 11:50 AM, Pepe TD Vo <pepevo@yahoo.com> w= rote:


I think you have missing files.&nb= sp; I have researched myself and prepare to install orapg2 to use and conve= rt  Oracle off to Postgres.  Try to follow this link, it might he= lp to make and reconfigure ora2pg step by steps.  

 
<= font color=3D"#8000ff">
Bach-Nga

No one in this world is pure and perfect.  If you avoid peo= ple for their mistakes you will be alone. So judge less, love and forgive m= ore.
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 outwar= d appearances. But to those who knew him well, he was a perfect gentleman (= Hermione Gingold)

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


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

Tha= nks Pepe and St=C3=A9phane
=20
&n= bsp;
=20
Now i tried to install this in a different HPUX server using root, and below it comes
=20
 
=20
Also what are the uninstallation steps if anyone knows.<= /div>=20
 
=20
Thanks All.
=20
 
=20
 
=20
# perl Makefile.PL
=20
Can't open scripts/ora2pg: No such file or directory.=20
WARNING: META_MERGE is not a known parameter.
=20
WARNING: DESTDIR is not a known parameter.
=20
WARNING: LICENSE is not a known parameter.
=20
'DESTDIR' is not a known MakeMaker parameter name.
= =20
'LICENSE' is not a known MakeMaker parameter name.
= =20
'META_MERGE' is not a known MakeMaker parameter name.=20
Writing Makefile for Ora2Pg
=20
 
=20
Done...
=20
---------------------------------------------------------------= ---------------
=20
Please read documentation at http://ora2pg.darold.net/ before a= sking for help
=20
---------------------------------------------------------------= ---------------
=20
Now type: make && make install
=20
 
=20
# make && make install
=20
make: *** No rule to make target `scripts/ora2pg', needed by `b= lib/script/ora2pg'.  Stop.
=20
&n= bsp;
=20
 
=20
&n= bsp;
=20
From: Pepe TD Vo <pepevo@yahoo.com>
Sent: Tuesday, November 13, 2018 4:42 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; pgsq= l-admin@postgresql.org
Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs
=20
 
=20
correct me if I'm wrong,
=20
your ora2pg.conf is under /etc/ora2pg and you pointed it on config/= ora2pg.conf, that's why it's not found.   
=20
 
=20
# pwd=
=20
/etc/ora2pg=20
# ora2pg -t SHOW_VERSION -c config/ora2pg.= conf
=20
sh: ora2pg:  not found.
=20
 
=20
just run
=20
ora2pg -version
=20
 
=20
Also, you have a network issue and the ora2pg is not promptly insta= lled, should be more files than just a configuration file.
=20
 
=20
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...?
=20
 
=20
i would love to know more about ora2pg for use in a few months.&nbs= p; Please share your knowledge and/or input.
=20
 
=20
v/r,
=20
 
=20
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.
=20
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, he was a perfe= ct gentleman (Hermione Gingold)
= =20

**Live simply **Love generously **Care deeply **Spe= ak kindly.
=20
*** Genuinely rich *** Faithful tal= ent *** Sharing success
=20
 
=20
 
=20
On Tuesday, November 13, 2018 5:11 AM, "soumik.bhattac= harjee@kpn.com" <soumik.bhattacharjee@kpn.com> wrote:
=20
 
=20
Hello,
=20
 
=20
I am trying to install ora2pg in HPUX server and als= o 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         61548 No= v 12 12:30 ora2pg.conf.dist
=20
-rw-r--r--   1 root    = ;   root         61548 No= v 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 be running another CPAN process (pid = 1667).  Contacting...
=20
Other job not responding. Shall I overwrite the lock= file? (Y/N) [y] y
=20
 
=20
cpan shell -- CPAN exploration and modules installat= ion (v1.61)
=20
ReadLine support available (try 'install Bundle::CPA= N')
=20
 
=20
cpan> get DBD::Oracle
=20
CPAN: Storable loaded ok
=20
Going to read /home/root/.cpan/Metadata
=20
Warning: Found only 0 objects in /home/root/.cpan/Me= tadata
=20
LWP not available=20
CPAN: Net::FTP loaded ok
=20
Fetching with Net::FTP:
=20
Issuing "/usr/bin/ftp -n"
=20
ftp: connect to address ::ffff:130.161.131.20: Netwo= rk is unreachable
=20
Trying ::ffff:131.211.31.189...
=20
ftp: connect: Network 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... Still failed!
=20
 
=20
Please check, if the URLs I found in your configurat= ion 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 available=20
Fetching with Net::FTP:
=20
 
=20




------=_Part_1678907_1164978546.1542128313996--