Skip to Main Content
  • Questions

  • Not getting connection with database in cmd window

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Minal.

Asked: January 13, 2018 - 8:43 am UTC

Last updated: January 14, 2018 - 9:13 am UTC

Version: Oracle Database 11g Express Edition

Viewed 1000+ times

You Asked

Hi,

I have just installed the Oracle Database 11g Express Edition from www.oracle.com. When I was connecting database in command prompt window I am getting error while entering paasword for user name "system".
I am typing below the exact error which it is showing. I have entered the password what I was provided at the time of installation.

Enter user-name: system
Enter passwod:
Error:
ORA-12154: TNS: could not resolve the connect identifier specified

Please help me through this as soon as possible. Thanks In Advance.

and Connor said...

Do you have an "@" sign in your password ? If so, you'll need quotes

SQL> create user demo identified by "Passw@ord";

User created.

SQL> grant create session to demo;

Grant succeeded.

SQL> connect demo/Passw@ord
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Warning: You are no longer connected to ORACLE.
SQL> connect demo/"Passw@ord"
Connected.



Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database