ORA-02019

ORA-02019 'Connection Description For Remote Database Not Found' Error When Starting the Messaging Gateway Agent

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.

Symptoms

The following error is received when starting the messaging gateway agent:
   

ORA-02019: connection description for remote database not found

Cause

Run the following query:

SQL> select * from dba_db_links where host = 'MGW_AGENT';

If no rows are returned, then the public database link called 'MGW_AGENT' that was created when MGW was installed was somehow dropped. The gateway agent needs to refer to this database link in order to start.
The same error can be reported if the link exists but has been modified by the customer to use another alias. This is not supported.

Solution

To resolve the problem, create the public link manually as SYS as SYSDBA:

SQL> create public database link mgw_agent using 'MGW_AGENT';

---

In 10.1 and 10.2, the script $ORACLE_HOME/mgw/admin/mgwlib.sql can instead be run as sys as sysdba.