I just spent three hours troubleshooting this error: "ORA-12154: TNS:could not resolve the connect identifier specified." I had three TNSNAMES.ORA files with identical information.
Oracle.DataAccess interaction with two of the three resulted in the ORA-12154 error. After scouring Google, I finally
came across this nugget of wisdom:
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.
No comments:
Post a Comment