DB-Link, 19c, ORA-02019: connection description for remote database not found — oracle-tech

    Forum Stats

  • 3,702,035 Users
  • 2,239,551 Discussions
  • 7,835,727 Comments

Discussions

DB-Link, 19c, ORA-02019: connection description for remote database not found

Oracle 19c (SE2) on Oracle Linux

We are facing this issue when trying to connect to a remote database. Both databases are 19c.

ORA-02019: connection description for remote database not found

select col1 from [email protected]db_link.prod <- works (= tnsnames entry)

within a package (procedure) <- above ora-message.

Any ideas?

Answers

  • EdStevensEdStevens Posts: 27,736 Gold Crown
    edited October 6

    Check your permissions on the link. Permissions inherited from a granted role do not apply in a stored procedure.

    Other than permissions on the link, it could be that you haven't 'dotted your i's and crsosed your t's'. To that we'd need to see the relevent output from dba_db_links, and the relevent entry from tnsnames.ora.

Sign In or Register to comment.