Коллеги добрый день,

ошибка
Error : ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from PG1
odbc.ini
[dg4odbc]

Debug = 0
CommLog = 0
ReadOnly = 1
Driver = PostgreSQL
Servername = ip
Username = username
Password = pass
Port = 5432в
Database = sgsn
Trace = 0
TraceFile = /tmp/sql.log

odbcinst.ini
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/local/lib/psqlodbca.so
FileUsage=1
Threading=1
UsageCount=3

listener.ora
LISTENER_dg4odbc=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tstbis1) (PORT = 1530))
)
)
)

SID_LIST_LISTENER_dg4odbc=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc)
(ORACLE_HOME=/oracle11/upgrade_oracle12c/12.2.0)
(ENVS="LD_LIBRARY_PATH=/usr/lib/hpux32:/oracle11/upgrade_oracle12c/12.2.0/bin:/usr/local/lib:/oracle11/upgrade_oracle12c/12.2.0/lib:/usr/local/lib:$LD_LIBRARY_PATH")
(PROGRAM=dg4odbc)

)
tnsnames.ora

dg4odbc =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=10.230.164.107)(PORT=1530))
(CONNECT_DATA=(SID=dg4odbc))
(HS=OK)
)

коннеск проходит

echo "select * from test" | isql -v dg4odbc
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+


в чем может быть проблема?

dmdmdm,
initdg4odbc.ora

HS_FDS_CONNECT_INFO = dg4odbc
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_TRACE_FILE_NAME = /oracle/odbc_trace.trc
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so
HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1
HS_RPC_FETCH_REBLOCKING= OFF
HS_FDS_FETCH_ROWS = 1
set ODBCINI=/usr/local/etc/odbc.ini
set ODBCSYSINI=/usr/local/etc

Лог файл приложила

[root@tstbis1 psqlodbc-09.06.0400]# odbcinst -j
unixODBC 2.3.7
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2
[root@tstbis1 psqlodbc-09.06.0400]# /usr/local/pgsql/bin/pg_config
BINDIR = /usr/local/pgsql/bin
DOCDIR = /usr/local/pgsql/share/doc
HTMLDIR = /usr/local/pgsql/share/doc
INCLUDEDIR = /usr/local/pgsql/include
PKGINCLUDEDIR = /usr/local/pgsql/include
INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
LIBDIR = /usr/local/pgsql/lib/hpux32
PKGLIBDIR = /usr/local/pgsql/lib/hpux32
LOCALEDIR = /usr/local/pgsql/share/locale
MANDIR = /usr/local/pgsql/share/man
SHAREDIR = /usr/local/pgsql/share
SYSCONFDIR = /usr/local/pgsql/etc
PGXS = /usr/local/pgsql/lib/hpux32/pgxs/src/makefiles/pgxs.mk
CONFIGURE = 'CC=cc' 'CFLAGS=-O -N -I/usr/local/include' 'LDFLAGS=-N -Wl,+b -Wl,/usr/local/lib/hpux32:/usr/local/pgsql/lib/hpux32 -L/usr/local/lib/hpux32 -L/usr/local/pgsql/lib/hpux32 /usr/local/lib/hpux32/libtermcap.so -lpthread' 'CPPFLAGS=-O -N -I/usr/local/include'
CC = cc
CPPFLAGS = -DFRONTEND -O -N -I/usr/local/include -D_XOPEN_SOURCE_EXTENDED
CFLAGS = +Olibmerrno -O -N -I/usr/local/include
CFLAGS_SL = +Z
LDFLAGS = -L../../src/common -N -Wl,+b -Wl,/usr/local/lib/hpux32:/usr/local/pgsql/lib/hpux32 -L/usr/local/lib/hpux32 -L/usr/local/pgsql/lib/hpux32 /usr/local/lib/hpux32/libtermcap.so -lpthread -Wl,+b -Wl,'/usr/local/pgsql/lib/hpux32'
LDFLAGS_EX = -Wl,-z
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lxnet /usr/local/lib/hpux32/libz.so /usr/local/lib/hpux32/libreadline.so -lm
VERSION = PostgreSQL 9.6.4
битность 64, что странно коннест то проходит через isql

Библиотеку проверила
[root@tstbis1 psqlodbc-09.06.0400]# ldd /usr/local/lib/libodbc.so

/usr/local/lib/libodbc.so:
libpthread.so.1 => /usr/lib/hpux32/libpthread.so.1
libc.so.1 => /usr/lib/hpux32/libc.so.1
libdl.so.1 => /usr/lib/hpux32/libdl.so.1

а почему тогда isql работает?

пересобрали библиотеки под 64-х битку но новая ошибка

Link : "PG1"
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