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