From: Pepe TD Vo <pepevo@yahoo.com>
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs
Date: Tue, 13 Nov 2018 15:41:58 +0000 (UTC)
Message-ID: <1152897292.1627397.1542123718889@mail.yahoo.com> (raw)
References: <1152897292.1627397.1542123718889.ref@mail.yahoo.com>
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.bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, soumik.bhattacharjee@kpn.com
Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs
In-Reply-To: <1152897292.1627397.1542123718889@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox