We are getting an error when using Oracle SQL*Plus:
ERROR: ORA-12154 TNS:could not resolve the connect identifier specified
However, before saying "obviously the problem is the tnsnames.ora file" please read the following:
We have the tnsnames.ora file set up correctly. How do I know? Well it worked not 2 minutes ago with our default assigned password. We got in. However, we are required to change our password from the default. So we issued the password command and changed the password. When we then tried to connect using the new password we get the above error. If we try to connect using the old password we get ERROR: ORA-01017: invalid username/password; logon denied.
Therefore it indicates to us that the problem is due to something in the new password. Does this sound correct? Any idea what characters are not accepted in Oracle passwords through Oracle SQL*Plus, which are accepted otherwise? Also the new password does working connecting through SQL Server 2005 - just not through Oracle SQL*Plus.