Return
-
Title
ORA-03113 and/or ORA-02019 error when running an 8i to 8i Database Link query in the Editor. -
Description
Getting the errors, ORA-03113 and/or ORA-02019, when running an 8i to 8i Database Link query in the Editor.
Defined a DB Link between two Oracle 8i version databases. It does not work using F9. It works if using F5. It runs fine in SQL Plus. The Test button in the Schema Browser also works fine.
ERRORS:
"ORA-03113: end-of-file on communication channel"
and/or
"ORA-02019: connection description for remote database not found"
-
Resolution
Go to the Toad Options | Oracle | General | and set the "OCI Array Buffer Size" to 'Manual' and accept the default 500 for the size. Restart Toad and then retest the issue.