sqlplus : ORA-12154

I have been facing this issue with sqlplus for quite sometime and have been ignoring it with shortage of time as an excuse. But i couldn’t avoid any further given that i had to do lot of DB stuff recently and i needed it running fine.


I have TOAD, SQL Developer and SQLPlus all installed. I was able to connect to my db using TOAD and SQL Developer without issues but whenever i tried connecting using SQLPlus with same db/schema/pwd it threw up following error message,

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

Strange!!!. There aint any issue with tnsnames.ora or sqlnet.ora since it is being used by other tools and they work fine. I googled around and did checks here n there but no help.


I happened to read somewhere that some special characters like @ etc. have special meaning for sqlplus and using them in userid/password confuses it. I had an @ in my password and that was the reason for this error. I changed my pwd and it worked like charm. 🙂




  1. Hey Amit! Thanks for sharing this. I never knew about this. Now, this is added to my knowledgebase.

    Do share such experiences with technology 🙂

  2. Hi, I dont have @ symbol in the password. Even then I was unable to connect to the DB.Though with SQL developer the same DB I can connect to. Could you help me to short out?

    Thanks in Advance..


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s