You can use the 11g Database Gateway for ODBC (DG4ODBC) to connect from Oracle 10.2.0.4 to Postgres. We have many customers using that combination.
If you have access to My Oracle Support you should review these notes -
Master Note for Oracle Gateway Products (Doc ID 1083703.1)
How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX Itanium) to Connect to Non-Oracle Databases Post Install (Doc ID 561033.1)
You can download the latest DG4ODBC 220.127.116.11 version as -
Patch 10404530: 18.104.22.168.0 PATCH SET FOR ORACLE DATABASE SERVER
from My Oracle Support and install it standalone in a separate ORACLE_HOME from the 10.2 RDBMS install.
For the gateway software you only need to download -
I have found the information provided very useful, though i have a couple of questions:
- The patch 10404530 is for Oracle 11G (22.214.171.124).
- Is this to be installed as a standalone product? I mean, can i install in an empty directory?.
- Can i download the windows version, to use in my laptop and later, connect to a dabatabse on a Linux system?.
Regards, Luis .
Yes, you should use the 11.2 gateway and install it standalone in a completely different ORACLE_HOME from any existing installs. The 10.2 gateways have been desupported for some time and the 126.96.36.199 gateway is certified with the 10.2.0.4 RDBMS.
And yes, you can download the Windows software and use it to access a database on a Linux system. Obviousy, the laptop needs a network connection to whichever other machines you wish to access.
For Windows 32-bit the download you need is -
The download -
is for all other platforms.
Thanks so much Mike.
I'll give it a try and keep you posted...!
Regards, Luis ...