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

Posted on 2011-10-11
Last Modified: 2013-01-16
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
Question by:nirvairghuman
    LVL 7

    Expert Comment

    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

    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    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.
    LVL 4

    Expert Comment

    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!
    LVL 76

    Accepted Solution

    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.

    Author Comment

    Thanks Slightwv,

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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now