• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 692
  • Last Modified:

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

Hi Guys,
I am getting the below error,
ORA-12154: TNS:could not resolve the connect identifier specified

I am trying to connect with
sqlplus whsusr/Airtr@n1@diwp

Can my password is problem
If yes how to solve without using password

it urgent, Please help
1 Solution
no, your password is not the problem...

Check the following:
1) You have "tnsnames.ora" file
2) You have 'path' variable point to the folder where 'tnsnames.ora' can be found

slightwv (䄆 Netminder) Commented:
The 12154 is typically a problem with your tnsnames.ora file.

Check that it has an entry for diwp.  If so, do you have more than one Oracle product installed?

Each oracle install needs it's own tnsnames.ora or you need to set the TNS_ADMIN environment variable to point to a common one.
Look in your tnsnames.ora file and make sure the host, port and service name specified are correct.

Also, look in your system path variables and make sure you have the oracle paths set.  The page below will help you out.  It doesn't sound like a password problem.  Good luck!

slightwv (䄆 Netminder) Commented:
Now that I'm back on a real computer the issue is with the connect string you used:  @n1@diwp

You only use one '@' and what follows needs to be an entry in the tnsnames.ora file.

If the '@' is part of the password I believe you can use double quotes on the password.
nirvairghumanAuthor Commented:
Thanks Slightwv,

You got the real issue. I did same thing in the night time and issue was resolved.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now