pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOra2pg Not Getting Installed- Please Provide Inputs
11+ messages / 4 participants
[nested] [flat]
* Ora2pg Not Getting Installed- Please Provide Inputs
@ 2018-11-13 10:10 soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-13 10:10 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Ora2pg Not Getting Installed- Please Provide Inputs
@ 2018-11-13 10:19 soumik.bhattacharjee@kpn.com
2018-11-13 10:31 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Stéphane KANSCHINE <stephane@hexack.fr>
2018-11-13 16:27 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs SAS <sas.postgresql@gmail.com>
0 siblings, 2 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-13 10:19 UTC (permalink / raw)
To: pgsql-admin
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.
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
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/modules
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/modules/02packages.details.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 modules/02packages.details.txt.gz
LWP not available
Fetching with Net::FTP:
ftp://ftp.perl.org/pub/CPAN/modules/03modlist.data.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/modules
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/modules/03modlist.data.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 modules/03modlist.data.gz
Going to write /home/root/.cpan/Metadata
Warning: Cannot get DBD::Oracle, don't know what it is.
Try the command
i /DBD::Oracle/
to find objects with matching identifiers.
cpan>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Ora2pg Not Getting Installed- Please Provide Inputs
2018-11-13 10:19 Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
@ 2018-11-13 10:31 ` Stéphane KANSCHINE <stephane@hexack.fr>
2018-11-13 10:40 ` RE: Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
1 sibling, 1 reply; 11+ messages in thread
From: Stéphane KANSCHINE @ 2018-11-13 10:31 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
Le mar. 13 nov., vers 10:19, soumik.bhattacharjee@kpn.com exprimait :
> Hello,
Hi,
> 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.
[...]
> ftp: connect to address ::ffff:130.161.131.20: Network is unreachable
Unreachable network is neither ora2pg nor DBD::Oracle related. It's a
system configuration related. Maybe your server is in a closed network
and you don't have a local CPAN mirror configured.
Regards,
--
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
＠ stephane@hexack.fr
+33 6 64 31 72 52
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: Ora2pg Not Getting Installed- Please Provide Inputs
2018-11-13 10:19 Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
2018-11-13 10:31 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Stéphane KANSCHINE <stephane@hexack.fr>
@ 2018-11-13 10:40 ` soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-13 10:40 UTC (permalink / raw)
To: stephane@hexack.fr; +Cc: pgsql-admin
Hi Stéphane ,
So what is the way forward, i am not a database guy.
Please share your inputs.
Thanks...
-----Original Message-----
From: Stéphane KANSCHINE <stephane@hexack.fr>
Sent: Tuesday, November 13, 2018 11:32 AM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs
Le mar. 13 nov., vers 10:19, soumik.bhattacharjee@kpn.com exprimait :
> Hello,
Hi,
> 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.
[...]
> ftp: connect to address ::ffff:130.161.131.20: Network is unreachable
Unreachable network is neither ora2pg nor DBD::Oracle related. It's a system configuration related. Maybe your server is in a closed network and you don't have a local CPAN mirror configured.
Regards,
--
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
＠ stephane@hexack.fr
+33 6 64 31 72 52
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Ora2pg Not Getting Installed- Please Provide Inputs
2018-11-13 10:19 Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
@ 2018-11-13 16:27 ` SAS <sas.postgresql@gmail.com>
1 sibling, 0 replies; 11+ messages in thread
From: SAS @ 2018-11-13 16:27 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello,
Le 13/11/2018 à 11:19, soumik.bhattacharjee@kpn.com a écrit :
>
> 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.
>
This message indicates your shell does not know about ora2pg.
Where is the binary installed? How did you install it?
If you know the absolute path, you may launch ora2pg with a command like:
/your/absolute/path/ora2pg ...
or
cd /your/absolute/path ; ./ora2pg ...
--
Dr Stéphane Schildknecht
Contact régional PostgreSQL pour l'Europe francophone
+33 617 11 37 42
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Ora2pg Not Getting Installed- Please Provide Inputs
@ 2018-11-13 15:41 Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:39 ` RE: Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
0 siblings, 1 reply; 11+ messages in thread
From: Pepe TD Vo @ 2018-11-13 15:41 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>; 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.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
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: Ora2pg Not Getting Installed- Please Provide Inputs
2018-11-13 15:41 Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
@ 2018-11-13 16:39 ` soumik.bhattacharjee@kpn.com
2018-11-13 16:50 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 1 reply; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-13 16:39 UTC (permalink / raw)
To: pepevo@yahoo.com; pgsql-admin
Thanks Pepe and Stéphane
Now i tried to install this in a different HPUX server using root, 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@yahoo.com>
Sent: Tuesday, November 13, 2018 4:42 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; pgsql-admin@postgresql.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 -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.
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<mailto:soumik.bhattacharjee@kpn.com>" <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.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 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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Ora2pg Not Getting Installed- Please Provide Inputs
2018-11-13 15:41 Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:39 ` RE: Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
@ 2018-11-13 16:50 ` Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:58 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 1 reply; 11+ messages in thread
From: Pepe TD Vo @ 2018-11-13 16:50 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>; pgsql-admin
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.bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.com> wrote:
#yiv6108423227 #yiv6108423227 -- _filtered #yiv6108423227 {font-family:Helvetica;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;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv6108423227 #yiv6108423227 p.yiv6108423227MsoNormal, #yiv6108423227 li.yiv6108423227MsoNormal, #yiv6108423227 div.yiv6108423227MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;}#yiv6108423227 a:link, #yiv6108423227 span.yiv6108423227MsoHyperlink {color:blue;text-decoration:underline;}#yiv6108423227 a:visited, #yiv6108423227 span.yiv6108423227MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv6108423227 p.yiv6108423227msonormal0, #yiv6108423227 li.yiv6108423227msonormal0, #yiv6108423227 div.yiv6108423227msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv6108423227 span.yiv6108423227sg {}#yiv6108423227 p.yiv6108423227msonormal, #yiv6108423227 li.yiv6108423227msonormal, #yiv6108423227 div.yiv6108423227msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv6108423227 p.yiv6108423227msochpdefault, #yiv6108423227 li.yiv6108423227msochpdefault, #yiv6108423227 div.yiv6108423227msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv6108423227 span.yiv6108423227msohyperlink {}#yiv6108423227 span.yiv6108423227msohyperlinkfollowed {}#yiv6108423227 span.yiv6108423227emailstyle17 {}#yiv6108423227 p.yiv6108423227msonormal1, #yiv6108423227 li.yiv6108423227msonormal1, #yiv6108423227 div.yiv6108423227msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv6108423227 span.yiv6108423227msohyperlink1 {color:#0563C1;text-decoration:underline;}#yiv6108423227 span.yiv6108423227msohyperlinkfollowed1 {color:#954F72;text-decoration:underline;}#yiv6108423227 span.yiv6108423227emailstyle171 {font-family:sans-serif;color:windowtext;}#yiv6108423227 p.yiv6108423227msochpdefault1, #yiv6108423227 li.yiv6108423227msochpdefault1, #yiv6108423227 div.yiv6108423227msochpdefault1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:sans-serif;}#yiv6108423227 span.yiv6108423227EmailStyle29 {font-family:sans-serif;color:#1F497D;}#yiv6108423227 .yiv6108423227MsoChpDefault {font-size:10.0pt;} _filtered #yiv6108423227 {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv6108423227 div.yiv6108423227WordSection1 {}#yiv6108423227 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@yahoo.com>
Sent: Tuesday, November 13, 2018 4:42 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; pgsql-admin@postgresql.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.bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Ora2pg Not Getting Installed- Please Provide Inputs
2018-11-13 15:41 Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:39 ` RE: Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
2018-11-13 16:50 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
@ 2018-11-13 16:58 ` Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 17:08 ` RE: Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
2018-11-19 15:20 ` RE: Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
0 siblings, 2 replies; 11+ messages in thread
From: Pepe TD Vo @ 2018-11-13 16:58 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>; 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@yahoo.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.bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.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@yahoo.com>
Sent: Tuesday, November 13, 2018 4:42 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; pgsql-admin@postgresql.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.bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.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
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: Ora2pg Not Getting Installed- Please Provide Inputs
2018-11-13 15:41 Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:39 ` RE: Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
2018-11-13 16:50 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:58 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
@ 2018-11-13 17:08 ` soumik.bhattacharjee@kpn.com
1 sibling, 0 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-13 17:08 UTC (permalink / raw)
To: pepevo@yahoo.com; pgsql-admin
Thanks will try with the link.
From: Pepe TD Vo <pepevo@yahoo.com>
Sent: Tuesday, November 13, 2018 5:59 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; pgsql-admin@postgresql.org
Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs
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@yahoo.com<mailto:pepevo@yahoo.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.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>" <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> wrote:
Thanks Pepe and Stéphane
Now i tried to install this in a different HPUX server using root, 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@yahoo.com<mailto:pepevo@yahoo.com>>
Sent: Tuesday, November 13, 2018 4:42 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>; pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.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 -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.
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<mailto:soumik.bhattacharjee@kpn.com>" <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.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 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
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: Ora2pg Not Getting Installed- Please Provide Inputs
2018-11-13 15:41 Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:39 ` RE: Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
2018-11-13 16:50 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:58 ` Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
@ 2018-11-19 15:20 ` soumik.bhattacharjee@kpn.com
1 sibling, 0 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-19 15:20 UTC (permalink / raw)
To: pepevo@yahoo.com; pgsql-admin
Thanks,
I upgraded the Perl to 5.8.8 and started the install
But while doing the install of - DBD-Oracle-1.74, got the below error during the end of “make” command.
Please let me know your inputs/thoughts.
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/ora_sw/ora/product/oracle/11.2.0/home_1/lib:/usr/lib/hpux32" /usr/bin/ld -b +vnocompatwarnings -L/usr/lib/hpux32 Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so \
-L/ora_sw/ora/product/oracle/11.2.0/home_1/lib/ -lclntsh -lrt -ldl -lm -lpthread -lnsl -lunwind -ldiskown -ldl -lm -lpthread -lrt -lpthread \
ld: Mismatched ABI for -lclntsh, found /ora_sw/ora/product/oracle/11.2.0/home_1/lib//libclntsh.so
Fatal error.
make: *** [blib/arch/auto/DBD/Oracle/Oracle.so] Error 1
From: Pepe TD Vo <pepevo@yahoo.com>
Sent: Tuesday, November 13, 2018 5:59 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; pgsql-admin@postgresql.org
Subject: Re: Ora2pg Not Getting Installed- Please Provide Inputs
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@yahoo.com<mailto:pepevo@yahoo.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.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>" <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> wrote:
Thanks Pepe and Stéphane
Now i tried to install this in a different HPUX server using root, 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@yahoo.com<mailto:pepevo@yahoo.com>>
Sent: Tuesday, November 13, 2018 4:42 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>; pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.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 -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.
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<mailto:soumik.bhattacharjee@kpn.com>" <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.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 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
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2018-11-19 15:20 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-11-13 10:10 Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
2018-11-13 10:19 Ora2pg Not Getting Installed- Please Provide Inputs soumik.bhattacharjee@kpn.com
2018-11-13 10:31 ` Stéphane KANSCHINE <stephane@hexack.fr>
2018-11-13 10:40 ` soumik.bhattacharjee@kpn.com
2018-11-13 16:27 ` SAS <sas.postgresql@gmail.com>
2018-11-13 15:41 Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:39 ` soumik.bhattacharjee@kpn.com
2018-11-13 16:50 ` Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 16:58 ` Pepe TD Vo <pepevo@yahoo.com>
2018-11-13 17:08 ` soumik.bhattacharjee@kpn.com
2018-11-19 15:20 ` soumik.bhattacharjee@kpn.com
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