Special welcome gift. Get 30% off your first purchase with code “Eduma”. Find out more!

    Get Started
    HomeOracle

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

    admin December 3, 2024 No Comments

    Oracle Error Message

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

    Reason for the Error

    Initialization of a database link to a non-Oracle system failed to connect to the Heterogeneous Services agent process for this non-Oracle system.

    Solution

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

    Tag:
    Share:

    Leave A Reply

    Your email address will not be published. Required fields are marked *

    Categories

    Archives
    Tags
    c# C# Compiler Errors C# Programs C++ examples C programs csharp DB2 Errors Delphi Errors Download Excel Excel 2016 Excel Automation excel functions excel tips excel tutorials Excel VBA Functions in Excel how to HPE NonStop SQL/MX Java examples Microsoft Microsoft Excel MS Office MySQL Errors Oracle Errors Outlook Errors PolarDB for PostgreSQL Python examples python programs SQL Server SQL Server Errors Sybase Error Message tips tricks troubleshoot Visual Studio Visual Studio 2012 Win32 Windows 11 Windows 11 tutorials Windows BSOD Errors windows phone windows phone 8 Windows Store wp8

    You May Also Like

    See more

    Oracle Error ORA-24328: illegal attribute value

    Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
    Read more

    Oracle Error ORA-01346: LogMiner processed redo beyond specified reset log scn

    Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
    Read more

    Oracle Error ORA-13241: specified dimensionality does not match that of the data

    Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...
    Read more