Коллеги добрый вечер,
На сервере стоит ORACLE gateway for odbc.Создала DB LINK к базе MYSQL. Работает.
Возникла задача создать еще один dblink к БД MYSQL. Все сделала по ману
https://docs.oracle.com/cd/B28359_01/gateways.111/b31043/configodbc.htm#CIHDCHED-Configure the Gateway to Access Multiple ODBC Data Sources,
но DBLINK2 дает ошибку
Error : ORA-28545: Net8 определил ошибку при соединении с агентом
Unable to retrieve text of NETWORK/NCR message 65535

в чем может проблема?
tnsnames.ora

dg4odbc1 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.xx.xx)(PORT=1525))
(CONNECT_DATA=(SID=dg4odbc2))
(HS=OK)
)
создала в папку $ORACLE_HOME/hs/admin файл initdg4odbc2.ora
указала HS_FDS_CONNECT_INFO = db2 mysql
listener.ora
LISTENER_dg4odbc1=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.xx) (PORT = 1525))
)
)
)


SID_LIST_LISTENER_dg4odbc1=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc2)
(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
(ENV="LD_LIBRARY_PATH=/home/nslugina/distr/mysql/lib/:/u01/app/oracle/product/12.1.0/dbhome_1/lib:/u01/app/oracle/product/12.1.0/dbhome_1/dg4odbc/driver/lib")
(PROGRAM=dg4odbc)

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

Вячеслав Любомудров,
Прошу прощения, что ввела вас в заблуждение, я выложила только настройки 2-го линка
вот все настройки 2-x линков

настройки odbc.ini
[clusterdb]
Description = MyUptimeMysqlServer
Driver = MySQL
Database = zabbix
Server = 192.168.x.xxx
User = dbuser
Password = password
Port = 3306
SOCKET =


[logs]
Description = MyUptimeMysqlServer
Driver = MySQL
Database = logs
Server = 192.168.xx.xxx
User = logreader
Password = password
Port = 33307
SOCKET =

listener.ora
LISTENER_dg4odbc=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.xx) (PORT = 1526))
)
)
)


SID_LIST_LISTENER_dg4odbc=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc)
(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
(ENV="LD_LIBRARY_PATH=/home/nslugina/distr/mysql/lib/:/u01/app/oracle/product/12.1.0/dbhome_1/lib:/u01/app/oracle/product/12.1.0/dbhome_1/dg4odbc/driver/lib")
(PROGRAM=dg4odbc)

)
)

LISTENER_dg4odbc1=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.xx) (PORT = 1525))
)
)
)


SID_LIST_LISTENER_dg4odbc1=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc2)
(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
(ENV="LD_LIBRARY_PATH=/home/nslugina/distr/mysql/lib/:/u01/app/oracle/product/12.1.0/dbhome_1/lib:/u01/app/oracle/product/12.1.0/dbhome_1/dg4odbc/driver/lib")
(PROGRAM=dg4odbc)

)
)
tnsnames.ora
dg4odbc =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.x.xx)(PORT=1526))
(CONNECT_DATA=(SID=dg4odbc))
(HS=OK)
)
dg4odbc1 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.x.xx)(PORT=1525))
(CONNECT_DATA=(SID=dg4odbc2))
(HS=OK)
)
и в $ORACLE_HOME/hs/admin 2 файла initdg4odbc.ora и initdg4odbc2.ora
содердание initdg4odbc.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = clusterdb #название источника, описанного в odbc.ini
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_SUPPORT_STATISTICS= FALSE
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15
#HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
#HS_NLS_LENGTH_SEMANTICS = CHAR
#HS_LANGUAGE = AMERICAN_AMERICA.UTF8
#HS_FDS_SQLLEN_INTERPRETATION = 32
HS_NLS_NCHAR = UCS2
HS_FDS_FETCH_ROWS=1
#HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15
#HS_FDS_PROC_IS_FUNC = TRUE
#HS_FDS_RESULTSET_SUPPORT = TRUE
#HS_NLS_NCHAR=UTF8
#HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
HS_FDS_SHAREABLE_NAME = /usr/lib64/libmyodbc5.so
#HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
set ODBCINI=/usr/local/etc/odbc.ini
set ODBCSYSINI=/usr/local/etc
#
# ODBC specific environment variables
#



#
# Environment variables required for the non-Oracle system
#

содержание initobdc2.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = logs #название источника, описанного в odbc.ini
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_SUPPORT_STATISTICS= FALSE
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15
#HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
#HS_NLS_LENGTH_SEMANTICS = CHAR
#HS_LANGUAGE = AMERICAN_AMERICA.UTF8
#HS_FDS_SQLLEN_INTERPRETATION = 32
HS_NLS_NCHAR = UCS2
HS_FDS_FETCH_ROWS=1
#HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15
#HS_FDS_PROC_IS_FUNC = TRUE
#HS_FDS_RESULTSET_SUPPORT = TRUE
#HS_NLS_NCHAR=UTF8
#HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
HS_FDS_SHAREABLE_NAME = /usr/lib64/libmyodbc5.so
#HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
set ODBCINI=/usr/local/etc/odbc.ini
set ODBCSYSINI=/usr/local/etc
#
# ODBC specific environment variables
#



#
# Environment variables required for the non-Oracle system
#

Vadim Lejnin,

Проблема решилась путем добавления файла initdg4odbc2.ora в директорию $ORACLE_HOME/dg4odbc/admin
т.е там лежат 2-а файла настройки initdg4odbc2.ora и initdg4odbc.ora,
затем я перезагрузила листенер и все заработало.