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