We migrated our firewalls over the weekend (from Juniper to Palo Alto) Today I have one user who can connect thru tns to the Oracle DBs from SQLDeveloper but not thru SQL*Plus. The error is a common one: ORA-12154: TNS could not resolve the connect
identifer specified. There are 2 Oracle homes on this user's machine and I have checked the path to ensure the oracle home/tnsnames location being used is the correct one. I've also checked to ensure that both of the tnsnames.ora file entries match.
We have about 20 other users who can connect thru SQL*Plus and either SQLDeveloper or TOAD with no problems. In checking the firewall rules, this user has the same firewall profile as everyone else as well.
Has anyone see something like this and if so, what should I be looking for to resolve?