ORA-28509: unable to establish a connection to non-Oracle system

ORA-28509: unable to establish a connection to non-Oracle system
Cause: Initialization of a database link to a non-Oracle system failed to connect to the Heterogeneous Services agent process for this non-Oracle system.
Action: Check the Net8 service name definition in the following places: -- the USING clause of the CREATE DATABASE LINK statement -- the TNSNAMES.ORA file -- the Oracle Names Server The following are possible reasons for name mismatches: -- The USING clause in the CREATE DATABASE LINK statement has to match the service name defined in the TNSNAMES.ORA file or in the Oracle Names Server. -- The protocol-specific information in the service name definition must match the protocol-specific definition of the responding listener. -- The SID= in the service name definition (in the TNSNAMES.ORA file or in Oracle Names Server) must match the value in the LISTENER.ORA file for the responding listener.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-28509：无法建立与非Oracle系统的连接,
.原因：初始化到非Oracle系统的数据库链接无法连接到该非Oracle系统的异构服务代理进程。,
.操作：在以下位置检查Net8服务名称定义： - CREATE DATABASE LINK语句的USING子句 - TNSNAMES.ORA文件 - Oracle名称服务器以下是名称不匹配的可能原因： - USING CREATE DATABASE LINK语句中的子句必须与TNSNAMES.ORA文件或Oracle名称服务器中定义的服务名称匹配。 - 服务名定义中的协议特定信息必须与响应侦听器的协议特定定义匹配。 - 服务名定义（在TNSNAMES.ORA文件或Oracle Names Server中）中的SID = 必须与响应侦听器的LISTENER.ORA文件中的值匹配。,
.

aiaiDBA

13718043309

010-86462881

ORA-28509: unable to establish a connection to non-Oracle system

1 个回答

相似问题