ORA-28509: unable to establish a connection to non-Oracle system
- 1 Answers
- 3514 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-12025: materialized view log on "string"."string" already has primary keys
ORA-14170: cannot specify <partition-description> clause in CREATE TABLE|INDEX
IMP-00087: Problem with internal hash table of schema/table names
PCC-02100: Unable to initialize PL/SQL
ORA-12714: invalid national character set specified
NZE-28815: Cannot convert a number in native format to Oracle format.
ORA-19599: block number string is corrupt in string string
NNL-01064: Statistic counter reset interval: string
ORA-12041: cannot record ROWIDs for index-organized table "string"."string"
LSX-00220: "~1S" is wrong length, should be ~2d
ORA-14084: you may specify TABLESPACE DEFAULT only for a LOCAL index
PCC-01014: "VARYING" not supported with PIC N PICTURE clause
Oracle Errors 
