ORA-02019: connection description for the remote database is not found.

  • Document ID:KM03213927
  • Creation Date:31-Jul-2018
  • Modified Date:31-Jul-2018
    • Micro Focus Products:
      structured data manager

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Running BF fails when try to connect and find db connection, like remote one or in distributed environments or simple db connection.

Error

ORA-02019: connection description for the remote database is not found.

Cause

Cause:

BF is pointing to remote databases which now aren't the right ones, so when dblinks or connections try to reach any register connect string, this fails due to referenced host or port or database isn't the original one.

Fix

Error:

ORA-02019: connection description for the remote database is not found.

 

Cause:

Most of the cases related to this Oracle error when you are running a BF are about dblinks point to wrong database, or connect string is point to database where the connection is failing by causes like DB down, network issues, security about blocking traffic and user privileges.

 

However, in this case we will cover only db remote connections about dblinks or references to remote connections.

 

About dblinks, so the way to proceed is:

  1. Check your dblinks, pointing to the right DBs
  2. If not, the way to proceed is to re-create them pointing them as you need.
  3. Also check for users used in that dblinks.
  4. Following, so check them out, and modify to point the right dbs about values in the tables:

The part that we may need to review the locations at a database level (What is your current database?). 

Below you will find the tables where the locations are related, 

kindly please tell your database administrator to check them out (if you can pass me some screenshots I would really appreciate it):

• obtpa_locations,
• obtcfg_location_types
• obtpa_location_properties

 

Take a look of attached file.

Apply to any SDM/AIO versions.