Can't Initialize OCI.Error -1 when trying to log in to toad

Good job in tracking that down.

Thanks for your help! You started me on the right track...I appreciate that!

1 Like

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.

1 Like

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