ERROR: ORA-12154 TNS:could not resolve the connect identifier specified

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.
LVL 35
mrichmonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GhostModConnect With a Mentor Commented:
Closed, 250 points refunded.

GhostMod
Community Support Moderator
0
 
actonwangCommented:
can you log in as another user?
0
 
actonwangCommented:
in command line, try:

tnsping <tns name>

is it ok?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
mrichmonAuthor Commented:
We could log in as THIS user until we changed the password.  And this user with this password works through MS SQL Server 2005 - same tns file.  It just doesn't work throught Oracle SQL*Plus beginning immediately when we changed the password.

Yes it pings fine.  The tnsfile is not the problem.
0
 
mrichmonAuthor Commented:
Okay I have confirmed it is the password.  Apparently there are certain special characters that do not work.  In our case the @ was causing a problem.  However simply enclosing the password in " also works.  Note the " are not needed except for in SQL*Plus
0
 
actonwangCommented:
I C. your password contains @!

sqlplus user/pass@<sid>


@ is a special character there.!
0
 
actonwangCommented:
you also would do:

sqlplus user


then let sqlplus prompt password for you then type in. you should be  ok then.
0
 
actonwangCommented:
or should be:

sqlplus user@<sid>
0
 
mrichmonAuthor Commented:
actonwang,

You are only repeating what I already stated I discovered was the problem - the @ sign.  I also stated the solutions we came up with.

I have requested this question to be closed.
0
 
actonwangCommented:
yes. exactly.  you can close it.
0
 
actonwangCommented:
just give you an alternative way to log in. is that not good?
0
 
actonwangCommented:
agree.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.