Re: Ora2pg Not Getting Installed- Please Provide Inputs

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
To: "soumik(dot)bhattacharjee(at)kpn(dot)com" <soumik(dot)bhattacharjee(at)kpn(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs
Date: 2018-11-13 16:58:33
Message-ID: 1411969476.1678909.1542128314015@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

for uninstall orag2pg, just run the uninstaller.sh or remove the whole folder. If it's in Window, run uninstaller.exe or choose uninstall program from control panel. 

FYI, I'm researching myself and document and preparing for work.  I haven't tried yet. 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 well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success

On Tuesday, November 13, 2018 11:50 AM, Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:

I think you have missing files.  I have researched 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 reconfigure ora2pg step by steps.  
https://blog.dbi-services.com/migrating-from-oracle-to-postgresql-with-ora2pg/
 
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 well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success

On Tuesday, November 13, 2018 11:40 AM, "soumik(dot)bhattacharjee(at)kpn(dot)com" <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:

#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;}#yiv4450925973 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv4450925973 filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv4450925973 p.yiv4450925973MsoNormal, #yiv4450925973 li.yiv4450925973MsoNormal, #yiv4450925973 div.yiv4450925973MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;}#yiv4450925973 a:link, #yiv4450925973 span.yiv4450925973MsoHyperlink {color:blue;text-decoration:underline;}#yiv4450925973 a:visited, #yiv4450925973 span.yiv4450925973MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv4450925973 p.yiv4450925973msonormal0, #yiv4450925973 li.yiv4450925973msonormal0, #yiv4450925973 div.yiv4450925973msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv4450925973 span.yiv4450925973sg {}#yiv4450925973 p.yiv4450925973msonormal, #yiv4450925973 li.yiv4450925973msonormal, #yiv4450925973 div.yiv4450925973msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv4450925973 p.yiv4450925973msochpdefault, #yiv4450925973 li.yiv4450925973msochpdefault, #yiv4450925973 div.yiv4450925973msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv4450925973 span.yiv4450925973msohyperlink {}#yiv4450925973 span.yiv4450925973msohyperlinkfollowed {}#yiv4450925973 span.yiv4450925973emailstyle17 {}#yiv4450925973 p.yiv4450925973msonormal1, #yiv4450925973 li.yiv4450925973msonormal1, #yiv4450925973 div.yiv4450925973msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv4450925973 span.yiv4450925973msohyperlink1 {color:#0563C1;text-decoration:underline;}#yiv4450925973 span.yiv4450925973msohyperlinkfollowed1 {color:#954F72;text-decoration:underline;}#yiv4450925973 span.yiv4450925973emailstyle171 {font-family:sans-serif;color:windowtext;}#yiv4450925973 p.yiv4450925973msochpdefault1, #yiv4450925973 li.yiv4450925973msochpdefault1, #yiv4450925973 div.yiv4450925973msochpdefault1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:sans-serif;}#yiv4450925973 span.yiv4450925973EmailStyle29 {font-family:sans-serif;color:#1F497D;}#yiv4450925973 .yiv4450925973MsoChpDefault {font-size:10.0pt;}#yiv4450925973 filtered {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv4450925973 div.yiv4450925973WordSection1 {}#yiv4450925973 Thanks Pepe and Stéphane   Now i tried to install this in a different HPUX server usingroot, and below it comes   Also what are the uninstallation steps if anyone knows.   Thanks All.     # perl Makefile.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 MakeMaker parameter name. 'LICENSE' is not a known MakeMaker parameter name. 'META_MERGE' is not a known MakeMaker parameter name. Writing Makefile for Ora2Pg   Done... ------------------------------------------------------------------------------ Please read documentation at http://ora2pg.darold.net/ before asking for help ------------------------------------------------------------------------------ Now type: make && make install   # make && make install make: *** No rule to make target `scripts/ora2pg', needed by `blib/script/ora2pg'. Stop.       From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Sent: Tuesday, November 13, 2018 4:42 PM
To: Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>; pgsql-admin(at)postgresql(dot)org
Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs   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 -cconfig/ora2pg.conf sh: ora2pg:  not found.   just run ora2pg -version   Also, you have a network issue and the ora2pg is not promptly installed, should 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.  Please share your knowledge and/or input.   v/r,   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 well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly. *** Genuinely rich *** Faithful talent *** Sharing success     On Tuesday, November 13, 2018 5:11 AM, "soumik(dot)bhattacharjee(at)kpn(dot)com" <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:   Hello,   I am trying to install ora2pg in HPUX server and also the DBD::Oracle   Please let me know your inputs as to how to go ahead.   # ls -ltr total 256 -rw-r--r--   1 root       root         61548 Nov 12 12:30 ora2pg.conf.dist -rw-r--r--   1 root       root         61548 Nov 12 12:30 ora2pg.conf # pwd /etc/ora2pg # ora2pg -t SHOW_VERSION -c config/ora2pg.conf sh: ora2pg:  not found.   # perl -MCPAN -e shell   There seems to be running another CPAN process (pid 1667).  Contacting... Other job not responding. Shall I overwrite the lockfile? (Y/N) [y] y   cpan shell -- CPAN exploration and modules installation (v1.61) ReadLine support available (try 'install Bundle::CPAN')   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 Net::FTP:  ftp://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 unreachable Not connected. Local directory now /home/root/.cpan/sources/authors Not connected. Not connected. Not connected. Not connected. Not connected. Not connected. Bad luck... Still failed! Can't access URLftp://ftp.perl.org/pub/CPAN/authors/01mailrc.txt.gz.   Please check, if the URLs I found in your configuration file () are valid. The urllist can be edited. E.g. with 'o conf urllist pushftp://myurl/'   Could not fetch authors/01mailrc.txt.gz LWP not available Fetching with Net::FTP:  ftp://ftp.perl.org/pub/CPAN/modules/02packages.details.txt.gz    

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message soumik.bhattacharjee 2018-11-13 17:08:45 RE: Ora2pg Not Getting Installed- Please Provide Inputs
Previous Message Pepe TD Vo 2018-11-13 16:50:15 Re: Ora2pg Not Getting Installed- Please Provide Inputs