Problem with DBLINK from Oracle to Postgresql

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Problem with DBLINK from Oracle to Postgresql

Яковлева Наталья Вадимовна

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

 


log2.txt (3K) Download Attachment
log1.txt (248 bytes) Download Attachment
oracle_log.trc (18K) Download Attachment