注册

oracle到DM的dblink报错ORA-28545

老徐 2026/02/07 403 3

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:V8.4
【操作系统】:银河麒麟V10
【CPU】:海光C86
【问题描述】*:
源端环境:oracle linux 7.6+ intel x86+orace 19c单机+GI软件+ASM管理存储
目标端:如上
dblink报错信息:
ora-28545:error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ora-02063:preceding 2 lines from linKdm

配置信息:
1./etc/odbc.ini
[dm8]
Driver = DM8 ODBC DRIVER
Description = DM ODBC DSN
SERVER = 10.10.10.10
UID = TEST
PWD = TEST@123
TCP_PORT = 5236
2./etc/odbcinst.ini
[DM8 ODBC DRIVER]
Description = ODBC DIRVER FOR DM8
DRIVER = /home/dmdba/dmdbms/bin/libdodbc.so
3.listener.ora(grid用户启动监听)
SID_LIST_LISTENER22=
(SID_LIST=
(SID_DESC=
(SID_NAME=dm8)
(PROGRAM=/usr/bin/env)
(ARGS=-i ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1 LD_LIBRARY_PATH=/home/dmdba/dmdbms/bin:/usr/lib64:/u01/app/oracle/product/19.0.0/db_1/lib ODBCINI=/etc/odbc.ini /u01/app/oracle/product/19.0.0/db_1/bin/dg4odbc /u01/app/19.0.0/grid/network/admin/listener.ora dm8)
)
)
4.tnsnames.ora(oracle用户)
dm8 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1522))
(CONNECT_DATA =
(SID = dm8)
)
(HS = OK)
)
5.initdm8.ora(oracle用户$ORACLE_HOME/hs/admin)
HS_FDS_CONNECT_INFO=dm8
HS_FDS_TRACE_LEVEL=4
HS_FDS_TRACE_DIRECTORY=/tmp
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_SHAREABLE_NAME=/home/dmdba/dmdbms/bin/libdodbc.so
HS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8
HS_NLS_NCHAR=AL32UTF8
HS_FDS_CONVERT_NCHAR=TRUE
HS_FDS_CONVERT_METHOD=CONVERT_DATATYPE
6.lsnrctl status
image.png
7.grid、oracle用户测试 isql -v dm8;
image.png
8.创建dblink测试:
create public database link linkdm connect to "TEST" identified by "TEST@123" using 'dm8';

select * from v$version@linkdm;
image.png

注:目前排错方向在grid用户环境变量导致dg4odbc进程无法启动问题。

回答 0
暂无回答
扫一扫
联系客服