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-37003: (AWLISTALL01) number readers

1 Answers  


ORA-00349: failure obtaining block size for 'string'

1 Answers  


ORA-19510: failed to set size of string blocks for file "string" (blocksize=string)

1 Answers  


ORA-31673: worker process interrupt for normal exit by master process

1 Answers  


ORA-23427: deferred purge queue argument string out of range

1 Answers  


RMAN-06131: skip offline/readonly only allowed with current controlfile

1 Answers  


ORA-12027: duplicate filter column

1 Answers  


PROC-00016: Cannot retrieve any more subkeys for the given keyhandle

1 Answers  


ORA-30100: internal error [number]

1 Answers  


ORA-01911: CONTENTS keyword expected

1 Answers  


ORA-12415: A column of another datatype exists on the specified table

1 Answers  


SQL-02118: Invalid row for a WHERE CURRENT OF operation

1 Answers  


Categories