11
Jun
09

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.

Issue:

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.

Resolution:

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. :)

 


3 Responses to “sqlplus : ORA-12154”


  1. 1 Srikanth
    June 11, 2009 at 13:04

    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. July 20, 2009 at 15:28

    Holy crap… this solved our problem after we wasted three hours on it! It was staring at us the whole time. Thanks!

  3. 3 palang
    October 5, 2009 at 03:24

    Thanks!

    You dont know how much time I wasted on this.


Leave a Reply




What You Said

Laxman on Passport for Baby in Bang…
nishi on Bangalore Property
Nilanchal on Bangalore Property
Nilanchal on Bangalore Property
suraj on Bangalore Property
Joe on Bangalore Property
Nilanchal on Bangalore Property
tgvindia on Bangalore Property
Swetha Viswanathan on Bangalore Property
Mr. Charm on Bangalore Property

History

Blog Stats

  • 129,690 views

Bookmarks