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 1gMbtT-0005Et-M9 for pgsql-admin@arkaria.postgresql.org; Tue, 13 Nov 2018 16:50:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gMbtQ-0002N2-50 for pgsql-admin@arkaria.postgresql.org; Tue, 13 Nov 2018 16:50: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 1gMbtP-0002Lq-DQ for pgsql-admin@lists.postgresql.org; Tue, 13 Nov 2018 16:50:23 +0000 Received: from sonic307-3.consmr.mail.bf2.yahoo.com ([74.6.134.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMbtL-0000p3-8b for pgsql-admin@postgresql.org; Tue, 13 Nov 2018 16:50:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1542127817; bh=RIOERIAzUuiZPoIUtOXR7HOcFfWuUrhLKyJUB72aBrM=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=sMu6I9jKtBwtQ9hbmd3dYsDTMr7IAfmKdBVrdrk25s0CstKWyNkP7d0MX2w4RiC9phLXzzUPW9aGMWjQl740aL8qiYHKoNzzQC4KWFzSFE2E4xukx+nMJ/EfpnpMelr2wbuUymjn04+qGX+9dEthUQ0L0vlcdc+k3WkplpLHQLaJGjvTXsNDFHP5zGc7xFf1/XHTMQHj6/jDn198Bb9NkEIiJl7KW46FcshxN9NSaRvV9otV6aRnCEVY0AuZ5AYt6E5kr41e+73gQzaiOkB6uE9wfo9VEij53OuIOnZpWOpcqjah5KFwoEcrz+bYgTuP5Rx87JTlZppy95l+BeJuaA== X-YMail-OSG: hI2XMGsVM1nNxnE5vYJOXBFSWTWRK2wLTzzHyVeAXFH0PU6Z2kshBR3VdwIwr2a meUOddnfhsSQg7eIQnMoa4PW8CQU3glndPq_QK9lXodTyB3.c1ueqlhuWLHfGRmTxPWXte3gfbfA Upa3gp4AJ1VvbaY3pWJNt0sM.CwO9tWTGv2ZEknqpNMeSzhdiabXfHcf6AH43.0ffzKS.b0_QEpI 0D.gdw0A_5Kqx4RGEdvCBydsjxhQGDumdWlk07TnZn73ubT8rzdZ5TdUhDGGDSi5AHkT.FwJhrC1 00IiA8tGNCGNG2fNhh0xoin2FyPtYfzQ2ucFOXmjovN_B3LSC9QuWFWi2ndZbeUiEpEVMfQCbu5K Ub1PozA4.GeTqniFBoBc3r0JTx9je0Hsys9mEcA9_kFtBqdvFXBjCTjIjfvuIjiofhKs7Ho3yPDB exFtfL.FmYTtZ.hgraYH4sXdLU1zYwxOk_bDM9jyMXn3Y2WFWSsRsea0LELF4M1yEid_xf4LUmh4 pA.b0CJvI181HzidWxVCGvEWboNnqMyldbeTAYItG62FADmhXauEBF7mobtyRxdaBXdTcT_iI9eg 28DzCrkr9yQgoEjND7lX5IOOsOGDWL37jocNm_wr3xepkDQM_ZMSwPJDFRcBXqeMiqvi5X2f5A8A CzsPUz.PJn5IUstGu0RF0KHD5lS.CyfbIi2GADZvb1TxgWinNPNKNIy5pO.oJlekI3UdmaBeM4pj c4P7GNbuOsEQX_0NmOLvdirx0UyNnioNPK6tjaRsXIYFbPCf0akAqIV3ShdqG_4Q2fffCZoIntVJ X.s1KloYcJsyAXCF7A70nE4ZswjMtvvm3xJMixZcnzIWqF5weCNM80_.AfZV6SiRioMQF9sZbmex oG3HryPJynov6lQt1q1yjHHxPsGj83vIpLd1jf07x5B_cRewK_lr_S_OtfBl5NIzvop3qyvOUpps kWNm5eoEe2N5SsqSqdoOQMi6YWmKXQA5vlLab.e3rfGarDELYEB.f6IDnSVwS_rjQd3s9ZhXZZ4j N7wm38Ps74zhddA8RGkGDhaPUpWgJvgZz5lFfl0qj1RhJ8R7f9D4g.sTwOPi.iZqxP7s0a5oRDOG u Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.bf2.yahoo.com with HTTP; Tue, 13 Nov 2018 16:50:17 +0000 Date: Tue, 13 Nov 2018 16:50:15 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "soumik.bhattacharjee@kpn.com" , "pgsql-admin@postgresql.org" Message-ID: <1262128724.1675314.1542127815835@mail.yahoo.com> In-Reply-To: <2A91BEF8171A5349931391E0C721CC5305D660F4@CPEMS-KPN301.KPNCNL.LOCAL> References: <1152897292.1627397.1542123718889.ref@mail.yahoo.com> <1152897292.1627397.1542123718889@mail.yahoo.com> <2A91BEF8171A5349931391E0C721CC5305D660F4@CPEMS-KPN301.KPNCNL.LOCAL> Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1675313_185687783.1542127815823" 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: 38709 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1675313_185687783.1542127815823 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 Tr= y to follow this link, it might help to make and reconfigure ora2pg step by= 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 #yiv6108423227 #yiv6108423227 -- _filtered #yiv6108423227 {font-family:Hel= vetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv6108423227 {panose-1:2= 4 5 3 5 4 6 3 2 4;} _filtered #yiv6108423227 {font-family:Calibri;panose-1= :2 15 5 2 2 2 4 3 2 4;} _filtered #yiv6108423227 {font-family:Verdana;panos= e-1:2 11 6 4 3 5 4 4 2 4;}#yiv6108423227 #yiv6108423227 p.yiv6108423227MsoN= ormal, #yiv6108423227 li.yiv6108423227MsoNormal, #yiv6108423227 div.yiv6108= 423227MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-fam= ily:New serif;}#yiv6108423227 a:link, #yiv6108423227 span.yiv6108423227MsoH= yperlink {color:blue;text-decoration:underline;}#yiv6108423227 a:visited, #= yiv6108423227 span.yiv6108423227MsoHyperlinkFollowed {color:purple;text-dec= oration:underline;}#yiv6108423227 p.yiv6108423227msonormal0, #yiv6108423227= li.yiv6108423227msonormal0, #yiv6108423227 div.yiv6108423227msonormal0 {ma= rgin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv= 6108423227 span.yiv6108423227sg {}#yiv6108423227 p.yiv6108423227msonormal, = #yiv6108423227 li.yiv6108423227msonormal, #yiv6108423227 div.yiv6108423227m= sonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New= serif;}#yiv6108423227 p.yiv6108423227msochpdefault, #yiv6108423227 li.yiv6= 108423227msochpdefault, #yiv6108423227 div.yiv6108423227msochpdefault {marg= in-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv61= 08423227 span.yiv6108423227msohyperlink {}#yiv6108423227 span.yiv6108423227= msohyperlinkfollowed {}#yiv6108423227 span.yiv6108423227emailstyle17 {}#yiv= 6108423227 p.yiv6108423227msonormal1, #yiv6108423227 li.yiv6108423227msonor= mal1, #yiv6108423227 div.yiv6108423227msonormal1 {margin:0in;margin-bottom:= .0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv6108423227 span.yiv610= 8423227msohyperlink1 {color:#0563C1;text-decoration:underline;}#yiv61084232= 27 span.yiv6108423227msohyperlinkfollowed1 {color:#954F72;text-decoration:u= nderline;}#yiv6108423227 span.yiv6108423227emailstyle171 {font-family:sans-= serif;color:windowtext;}#yiv6108423227 p.yiv6108423227msochpdefault1, #yiv6= 108423227 li.yiv6108423227msochpdefault1, #yiv6108423227 div.yiv6108423227m= sochpdefault1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-famil= y:sans-serif;}#yiv6108423227 span.yiv6108423227EmailStyle29 {font-family:sa= ns-serif;color:#1F497D;}#yiv6108423227 .yiv6108423227MsoChpDefault {font-si= ze:10.0pt;} _filtered #yiv6108423227 {margin:70.85pt 70.85pt 70.85pt 70.85p= t;}#yiv6108423227 div.yiv6108423227WordSection1 {}#yiv6108423227 Thanks Pep= e and St=C3=A9phane =C2=A0 Now i tried to install this in a different HPUX= server usingroot, and below it comes =C2=A0 Also what are the uninstallat= ion steps if anyone knows. =C2=A0 Thanks All. =C2=A0 =C2=A0 # perl Makef= ile.PL Can't open scripts/ora2pg: No such file or directory. WARNING: META_= MERGE is not a known parameter. WARNING: DESTDIR is not a known parameter. = WARNING: LICENSE is not a known parameter. 'DESTDIR' is not a known MakeMak= er parameter name. 'LICENSE' is not a known MakeMaker parameter name. 'META= _MERGE' is not a known MakeMaker parameter name. Writing Makefile for Ora2P= g =C2=A0 Done... ---------------------------------------------------------= --------------------- Please read documentation at http://ora2pg.darold.net= / before asking for help --------------------------------------------------= ---------------------------- Now type: make && make install =C2=A0 # make = && make install make: *** No rule to make target `scripts/ora2pg', needed b= y `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 ------=_Part_1675313_185687783.1542127815823 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I think you have missing files.  I have researche= d myself and prepare to install orapg2 to use and convert  Oracle off = to Postgres.  Try to follow this link, it might help to make and recon= figure ora2pg step by steps.  

 
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.
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 wel= l, he was a perfect gentleman (Hermione Gingold)
=
**Live simply **Love generously **Care deeply *= *Speak kindly.
*** Genuinely rich *** Faithful talent *** Sh= aring success

On Tuesday, November 13, 2018 11:40 AM, "soumik.bhattacharje= e@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_1675313_185687783.1542127815823--