Just a note, sometimes the TNSNAMES.ORA will get messed up. Nothing will jump out but it will not work and you cannot see the file though the net config. Just re-create it using notepad or [s]omething.
I replaced the two misbehaving files with the 'good' file and guess what? ORA-12154 magically went away.