Problem with DBLINK from Oracle to Postgresql

From: Яковлева Наталья Вадимовна <nyakovleva(at)megacom(dot)kg>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Cc: Липатов Евгений Александрович <elipatov(at)megacom(dot)kg>
Subject: Problem with DBLINK from Oracle to Postgresql
Date: 2019-07-19 10:14:39
Message-ID: 8c79f920c0bc4d89b569c0d78e8f4690@btc-vsrv-ex1.megacom.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Good day,

We have problem with dblink from oracle to postgres
Oracle database 12.2 ptalform HP-UX Itanium
Oracle error
Error : ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
could not get socket error status: Invalid argument
{08001,NativeErr = 101}
ORA-02063: preceding 3 lines from PG1
I attached trace file from oracle

We use unixodbc 2.3.7 and psqlodbc.09.06.0500 (we tried to install almost all drivers with major version 9).
Also we have postgresql 9.4.8 installed on hpux for libpq. The remote postgresql is also 9.4.8.
All libs are built in 64 bit mode:

ldd /usr/local/psqlodbc2/lib/psqlodbca.so
/usr/local/psqlodbc2/lib/psqlodbca.so:
libpq.so.5 => /usr/local/unixodbc/lib/libpq.so.5
libodbcinst.so.2 => /usr/local/unixodbc/lib/libodbcinst.so.2
/usr/local/lib/hpux64/libltdl.so => /usr/local/lib/hpux64/libltdl.so
libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1
libc.so.1 => /usr/lib/hpux64/libc.so.1
/usr/local/lib/hpux64/libltdl.so => /usr/local/lib/hpux64/libltdl.so
libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1
libc.so.1 => /usr/lib/hpux64/libc.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1

file /usr/local/psqlodbc2/lib/psqlodbca.so
/usr/local/psqlodbc2/lib/psqlodbca.so: ELF-64 shared object file - IA64

ldd /usr/local/unixodbc/lib/libodbc.so
/usr/local/unixodbc/lib/libodbc.so:
/usr/local/lib/hpux64/libltdl.so => /usr/local/lib/hpux64/libltdl.so
/usr/local/lib/hpux64/libiconv.so => /usr/local/lib/hpux64/libiconv.so
libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1
libc.so.1 => /usr/lib/hpux64/libc.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1

ldd /usr/local/unixodbc/lib/libodbcinst.so
/usr/local/unixodbc/lib/libodbcinst.so:
/usr/local/lib/hpux64/libltdl.so => /usr/local/lib/hpux64/libltdl.so
libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1
libc.so.1 => /usr/lib/hpux64/libc.so.1
libdl.so.1 => /usr/lib/hpux64/libdl.so.1

file /usr/local/unixodbc/lib/libodbcinst.so
/usr/local/unixodbc/lib/libodbcinst.so: ELF-64 shared object file - IA64

file /usr/local/unixodbc/lib/libodbc.so
/usr/local/unixodbc/lib/libodbc.so: ELF-64 shared object file - IA64

UnixODBC and psqlodbc logs are in attachment

Any help is appreciated. Thank you in advance.

With best regards,
Natalia

Attachment Content-Type Size
log2.txt text/plain 2.9 KB
log1.txt text/plain 179 bytes
oracle_log.trc application/octet-stream 13.8 KB

Browse pgsql-odbc by date

  From Date Subject
Next Message Marco Gaiarin 2019-07-22 10:19:53 ODBC Driver 9->11, troubles with dates/NULL...
Previous Message michael.riksman 2019-07-18 09:18:54 Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'