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 15:41:58
Message-ID: 1152897292.1627397.1542123718889@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.confsh: ora2pg:  not found.

just runora2pg -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:

#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.yiv2936877444MsoNormal, #yiv2936877444 div.yiv2936877444MsoNormal {margin:0in;margin-bottom:.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.yiv2936877444MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv2936877444 span.yiv2936877444EmailStyle17 {font-family:sans-serif;color:windowtext;}#yiv2936877444 .yiv2936877444MsoChpDefault {font-family:sans-serif;}#yiv2936877444 filtered {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv2936877444 div.yiv2936877444WordSection1 {}#yiv2936877444 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 URL ftp://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 push ftp://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  

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2018-11-13 15:53:36 Re: hot_standby_feedback parameter doesn't work
Previous Message Rui DeSousa 2018-11-13 15:35:03 Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device"