Was using Toad for Oracle 11.5 but company upgraded. That version was uninstalled and I just received Toad for Oracle 126.96.36.199
My saved sessions were wiped. I had to re-edit the tnsnames.ora and re-add my servers. I did this via copy 'n paste from a tnsnames.ora on the servers... they're identical contents.
I can connect to the DB using SQL*Plus from server1
% sqlplus myname/password@server1 SQL*Plus: Release 188.8.131.52.0 Production on Thu Oct 1 19:02:58 2020 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connect to: Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production SQL>
However, when I try to connect to the database using Toad for Oracle 220.127.116.11 it gives me this error:
ORA-12154: TNS:could not resolve the connect identifier specified
The error dialog is quite large and interestingly, it has a number of bulleted items that are all green. It says that TNS_ADMIN was found, tnsname.ora was found, Oracle home was found, it displays an accurate connect descriptor, sqlnet.ora, and that the NAMES>DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file. Everything has a pretty green checkmark. So it is an error dialog, but everything it display is good/green/accurate.
It then suggests I take the following steps:
Try to ping <hostname> using the Ping button on the toolbar Try to TNSPing SERVER1 using the TNS Ping button on the toolbar
the ping is successful, but the TNSPing says failed to resolve name.
Any idea why it is failing to resolve the name when it has found the tnsnames.ora and even shows me an accurate connect descriptor?
 I just tried a direct connect and that worked. So it appears to just be failing when trying to do TNS.
Thank you in advance,