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-31469: cannot enable Change Data Capture for change set string

1 Answers  


ORA-24409: client cannot understand the object

1 Answers  


SQL*Loader-00956: Error calling once/data file finishing

1 Answers   Wipro,


DGM-16901: Unable to initialize environment

1 Answers  


ORA-14272: only a partition with higher bound can be reused

1 Answers  






ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS

1 Answers  


RMAN-06085: must use SET NEWNAME command to restore datafile string

1 Answers  


O2F-00334: A user-defined type is listed more than once in the INTYPE file

1 Answers  


SQL-02110: Inconsistent host cache. Invalid host cache entry type

1 Answers  


ORA-23300: %s

1 Answers  


NNL-00041: Object string not in domain string

1 Answers  


LPX-00659: Output write failed.

1 Answers  


Categories