Wednesday, 24 October 2012

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

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 24 14:49:32 2012

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

Enter user-name: sys/sys@orc1 as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Reason
1) OracleOraDb11g_home1TNSListener
D:\Oracle\product\11.2.0\dbhome_1\BIN\TNSLSNR  - Service was not started

2) OracleServiceORCL:
d:\oracle\product\11.2.0\dbhome_1\bin\ORACLE.EXE ORCL - Service was not started

Starting one by one
1) Started from Services.msc -
but got same error

2) Started from Services.msc -
but got same error

What the HECK, OH I WAS WRITING something WRONG :(

Enter user-name: sys/sys@orc1 as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name: sys/sys@orcl as sysdba (it is L not 1)



but now

ERROR:
ORA-12541: TNS:no listener


AHHH.....ERROR CHANGED :(

OHH...... I NEED TO RESTART THE SERVICE, LET ME START ONE BY ONE AND CHECK ERRORS :P

If we start OracleServiceORCL first, then also get same error as above i.e
ERROR:
ORA-12541: TNS:no listener

If we start  OracleOraDb11g_home1TNSListener first then gets following error:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

So now we have started both Services and write following and

Enter user-name: sys/sys@orcl as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Yappyyyyyy!!!!

Now i will look into technical details later. I gotta go















No comments:

Post a Comment