I was recently creating a new database connection and have come across a weird scenario, probably associated with the 25.2 update, since on previous versions I had no issues.
In my company we have a tnsnames.ora file stored on a network drive acessible to all users in the company. So every computer has TNS_ADMIN system environment variable mapped on their computer pointing to \\company.lan\…..\Oracle\Admin\
During the 25.2 update issues, our tnsnames didnt work at all, so we stayed on the previous version until 25.2.2 came out which seemed to work.
Now some time later, when trying to create a new connection, if you select connection type TNS and Type Network Alias, it doesent display any network aliases. and TNS File Location says No tnsnames.ora or .tnsnames files found.
I played around with this, and found that it is a problem with the path being to a shared drive. If I map the path to a network drive, it works.
We can also still switch Type to Connect Identifier and write it in manually, and it works. But then you need to know the exact identifier, you cannot check what databases there are,… Not optimal.
Not sure if this is a niche case, just something I noticed that didnt seem to work right. So if maybe you could look into it. Can provide more details if required.