'ORA-02019: Connection Description for Remote Database Not Found' when running a statement in Editor with DB Link as a sysdba user (4244750)

'ORA-02019: Connection Description for Remote Database Not Found' when running a statement in Editor with DB Link as a sysdba user

In v13.1 when running a query in the Editor (with F5 or F9) with a private DB link, the following error shows:
'ORA-02019: Connection Description for Remote Database Not Found.'

When you run the statement directly in SQL*Plus, the same statement succeeds.

This only happens on a private DB Link, a public one works ok.


If you run the statement in Toad Editor via SQL*Plus, it fails with the same error, but when you type 'Show User' command, it shows SQL*Plus is running as SYS, and not the originally connected user.

In the SQL Tracker log, it shows Toad is trying to switch the user to SYS, just before the error appears.

Toad is changing the current schema after running the query. So the next query is set tothe wrong schema during execution.

WORKAROUND:
The issue doesn't occur if you don't log in as a non SYS user, logged in as SYSDBA

STATUS:
Waiting for fix in a future release of Toad for Oracle

TOR-3167​