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.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.
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@xxxxxxx" <soumik.bhattacharjee@xxxxxxx> 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 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
