Database Error Messages

The initialization of the database link failed to connect to a system outside the Oracle network. The database could not connect to the Heterogeneous Services agent process of this system.

Check the Net8 service name definition in the following:

• the USING clause in the CREATE DATABASE LINK statement
• the TNSNAMES.ORA file
• the Oracle Names Server

Check the following to resolve the issue with name mismatch:

• The USING clause in the CREATE DATABASE LINK statement matches with the service name defined in the TNSNAMES.ORA file or in the Oracle Names Server.
• The protocol-specific information in the service name definition matches with 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) matches with the value in the LISTENER.ORA file for the responding listener.

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

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.

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

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.