ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

post results from the following two OS commands:

lsnrctl status

lsnrctl service

Since every connection request to the listener gets logged, listener.log file will contain a line with 12505 as status code.

*This line contains valuable debugging details. So post this line & surrounding lines.*

for additional debugging suggestions read the URL below:

http://edstevensdba.wordpress.com/2011/03/19/ora-12514/

[[email protected] ~]$ oerr ora 12505

12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor"

// *Cause:  The listener received a request to establish a connection to a

// database or other service. The connect descriptor received by the listener

// specified a SID for an instance (usually a database instance) that either

// has not yet dynamically registered with the listener or has not been

// statically configured for the listener. This may be a temporary condition

// such as after the listener has started, but before the database instance

// has registered with the listener.

// *Action:

//  - Wait a moment and try to connect a second time.

//  - Check which instances are currently known by the listener by executing:

//    lsnrctl services <listener name>

//  - Check that the SID parameter in the connect descriptor specifies

//    an instance known by the listener.

//  - Check for an event in the listener.log file.

sandeep.c wrote:

Thanks sb92075 for the quick response.

FYI Please...

a) lsnrctl status

Output:

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 05-NOV-2013 21:07:55

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                05-NOV-2013 18:41:18
Uptime                    0 days 2 hr. 26 min. 37 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   \app\Sandeep\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         d:\app\sandeep\diag\tnslsnr\Sandeep-PC\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
The command completed successfully

b)lsnrctl service

Output:

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 05-NOV-2013 21:10:34

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
      "ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready
         CLRExtProc
         (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_E5C_373D2E46.ORA))
      "ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready
         CLRExtProc
         (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_E5C_373D2E46.ORA))
The command completed successfully

So now you have to ask yourself, "why doesn't my listener know about 'orcl'?"

Two reasons come immediately to mind:

1) this listener isn't on the server where your 'orcl' instance is running

2) this listener IS on the same server, but the 'orcle' instance is NOT running

3) this listener IS on the same server, the 'orcle' instance IS running, but an incorrectly set LOCAL_LISTENER parameter prevents it from registering with the listener.

BTW, your listener is configured to listen on IP address 127.0.0.1.  This absolutely guarantees that it will never receive a connection request that originates from any other box.

sandeep.c wrote:

I am running this code on my Laptop.

What really annoys me is that this code snippet worked before.I formatted my system and re-installed Oracle and now this exception.
I am sorry if this sounds stupid.

So is the database running on your laptop?  On the native OS - not a virtual machine?

You've been given several clues ... I've not seen anything indicating you've actually followed up on them.