Dblink from oracle database to PostgreSQL database

[satish]

Dear erman,

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Dblink-from-oracle-to-PostgreSQL-td9674.html

Where can I download psqlodbc driver for PostgreSQL database.This needs to be installed in oracle server.

Thanks,
SG

[ErmanArslansOracleBlog]

You just install it with yum..

yum install postgresql12-odbc

And yes on Oracle side..

Please review and follow the document below;

https://www.enterprisedb.com/postgres-tutorials/accessing-postgresql-databases-using-psqlodbc-oracle

[satish]

Dear erman,

We are using red hat Linux 7, when I run this command, it throws below message.

System is not registered to red hat subscription management, you can use subscription manager to download the package.
Error: Nothing to do...

Thanks,
SG

[ErmanArslansOracleBlog]

You need to register and subscribe to RHN.
If you are using Redhat, then you have a license.. So you can register;

Check -> https://access.redhat.com/solutions/253273

subscription-manager register ..........