This discussion is archived
2 Replies Latest reply: Sep 30, 2012 9:38 PM by kgronau RSS

How to create db link oracle to postgers Or postgres to oracle

Vaibhav Newbie
Currently Being Moderated
hi

i am creating dblink in Oracle 11g (Linux) for postgres database but i facing error
ORA-12547: TNS:lost contact

I did following steps

1 install driver psqlodbc-08.04.0100-2-x86_64.pkg
2 modify tnsnames.ora file for new entry
3 made an entry in etc/hosts/ for ip address of postgresql database
4 create db link

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points