Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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=<name> 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27477: "string.string" already exists

1 Answers  


ORA-07285: sksaprd: volume size should not be specified for a disk file.

1 Answers  


RMAN-08119: skipping backup piece handle string; already exists

1 Answers  


ORA-25211: invalid DELAY specified when using sequence deviation

1 Answers  


ORA-27091: unable to queue I/O

1 Answers  






ORA-07280: slsget: unable to get process information.

1 Answers  


ORA-01643: system tablespace can not be made read only

1 Answers  


UDI-00007: attempt to free unallocated memory

1 Answers  


ORA-23330: column group string already exists

1 Answers  


ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables

1 Answers  


DGM-16949: "string" was not found

1 Answers  


RMAN-06597: conversion between platforms 'string' and 'string' is not implemented

1 Answers  






Categories