ORA-28509: unable to establish a connection to non-Oracle system
- 1 Answers
- 3687 Views
- I also Faced
- E-Mail Answers
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 |
ORA-00113: protocol name string is too long
ORA-22060: argument [string] is an invalid or uninitialized number
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
SQL*Loader-00277: Local file specification overrides global file specification.
ORA-09820: Conversion of class string to numeric representation failed.
ORA-12511: TNS:service handler found but it is not accepting connections
PCC-00101: Lower case 'e' in floating point number is not ANSI
NNL-00534: query <name> [<type>] : query for a desired name and RR type
NNF-04006: Could not create outputfile
RMAN-06210: List of Mismatched objects
PCC-00136: Invalid SQL_CURSOR declaration
PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal
Oracle Errors 
