Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Jon80Jun 20 2012 — edited Jun 27 2012
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Jon>sqlplus connect sysdba@LISTENER

SQL*Plus: Release 11.2.0.1.0 Production

Copyright (c) 1982, 2010, Oracle. All rights reserved.
C:\Documents and Settings\Jon>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 20:33:35 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> connect sysdba@listener
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> exit

C:\Documents and Settings\Jon>set ORACLE_HOME=C:\app\Jon\product\11.2.0\dbhome_1


C:\Documents and Settings\Jon>ORACLE_HOME
'ORACLE_HOME' is not recognized as an internal or external command,
operable program or batch file.

C:\Documents and Settings\Jon>echo %ORACLE_HOME%
C:\app\Jon\product\11.2.0\dbhome_1

C:\Documents and Settings\Jon>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 20:35:34 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> connect sysdba@listener
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


I have also noticed that trying to set new environment variables through My Computer, does not seem to retain the environment variable, maybe my operating system (Win SP SP3) has gone corrupt, or has a bug, but I don't have a confirmation as yet.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2012
Added on Jun 20 2012
27 comments
4,254 views