Good job in tracking that down.
Thanks for your help! You started me on the right track...I appreciate that!
FYI, I was able to reproduce this, but only when the empty file was in my TNS_ADMIN folder. I'll add a check for this in the next version of Toad.
Hi John,
Oraaccess.xml is new for 12c and apparently, allows configuration of the OCI interface.
Details here if required: https://docs.oracle.com/database/121/LNOCI/oci10new.htm#GUID-9D12F489-EC02-46BE-8CD4-5AECED0E2BA2
Cheers,
Norm.
Thanks Norm.
Since @cantyk brought that to my attention yesterday, I put that file in my tns_admin folder (first the blank one to reproduce the problem, then a valid version of the file just to play with).
I've noticed, with a 19c client at least, that if a connection times out due to profile, and a valid version of oraaccess.xml is present, then I get an access violation from one of the Oracle client dll's instead of the ORA-##### for a profile disconnect. Hopefully that can be solved (seems like an oracle bug at first glance), but it's something to be aware of.
-John