0 Replies Latest reply on Sep 11, 2018 8:30 AM by 2758769

    Problems with connection to postgresql via dblink

    2758769

      We have a server with installed Oracle Linux and Oracle 12c. I configured odbc.ini in system to connect to postgresql database.

      Also created the file in the HS folder. Then configured listener and tnsnames.

      The problem is that, when you type the isql -v odbcname command, the system connects and the requests are executed.

      But when I try to make select through oracle itself, I get an error

      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

      ORA-02063: previous line from ODBCNAME

      What could be the problem? tnsnames and listener rechecked, everything is fine