Suddenly getting ORA-12154 errors on one client only
I have a puzzler here.
We have a 11g client on a server that remotely connects to databases via tnsnames. We have not made any changes to the client. From what we can tell from our application logs, we "suddenly" started getting ORA-12154 (via sqlplus) and TNS-03505 (via tnsping) errors on this client to any remote database. We can telnet to the 1521 port of the remote database servers so it doesn't look like a firewall issue. The clients on other servers are working just fine.
We have even installed a new client and it is reporting the same issues.
To make things more puzzling, I am able to make a test connection via the Oracle Net Configuration Assistant.
1