Just another Blog

My Technical, Professional and at times Personal Blog

Showing posts with label ORA Errors. Show all posts

ORA-12154 in TOAD


I recently ran into this error while trying to connect to a new Oracle database using TOAD. The following steps seem to resolve it…

Step 0 – you get the error ORA-12154: TNS:could not resolve the connect identifier specified

step 1 – create new tnsentry using TNSNames Editor

step 2 – restart TOAD and try connecting using the new tnsentry you just created

Strangely the first time after adding the new entry, I was unable to see the entry in the connection dropdown. So, I just manually typed in the new tnsentry in the Database textbox at the TOAD login prompt and voila!

I have TOAD on my PC and there are probably patches available for this version of TOAD that I should first install.

Google+ Followers