My first post on this forum, so a bit about me:
I'm an Oracle DBA for 23 years now.
I have lots of experience with databases ranging from 10.2 up to 19c
I have been working with Toad for Oracle for the last 12 years.
But even with years of experience, sometimes a strange thing happens, like now:
We're seeing some strange behavior when using the new Toad 14 in combination with Oracle client 19c when connecting to an old 10.2. database.
The connection results in an ORA-03113 when using a TNS connection setup
When using a direct connection instead, Toad connects fine.
Also when using e.g. SQLplus, or SQL-developer also the TNS connections works fine.
All other connections from e.g. other databases also have no problems.
Even better, using Toad with a TNS connection to another 10.2 database also works fine.
All applications use the same tnsnames.ora file
It is just Toad that runs into an ORA-03113 when a TNS connection is used with this database.
Has anyone seen this before, and or know what to do to solve it?