Skip to Main Content

Oracle Database Discussions


For appeals, questions and feedback, please email

ORA-12154: TNS:could not resolve service name

879447Aug 1 2011 — edited Jul 8 2012

I am experiencing problems connecting to my local oracle db using the sqlplus command tool.
I have created the necessary settings as described into the documentation and I am able to connect to the db with external tools (sqldeveloper, net manager, net configuration assistant - test) but when I try to do the following:

sqlplus system/password@prem

I receive the following error message:

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

My service name is prem.ucb.lan, my connect identifier is prem, I use the TNSNAMES for local naming. I've been struggling for days around this problem now and it seems that there isn't much information on the net regarding how to debug this issue. Everything points to "possible incorrect tnsnames.ora" but I am pretty sure that mine is OK.

Any ideas?
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2012
Added on Aug 1 2011