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

Giganews Newsgroups
Subject: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Posted by:  bomahony (bomaho…@gmail.com)
Date: Thu, 19 Jul 2007

The error im getting is:
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in
connect descriptor
The Connection descriptor used by the client was:
beatrix:1522:cm101

This is happening on oracle102 and oracle101

For this ill just use the oracle 10.1.0.5 install.

i have the listener called listener101, and the port is 1522 (oracle
10.2 install is listener102 and port 1523 - only one is ever running
at a time)

Here is the result from a tnsping:
bash-3.00$ tnsping curam101

TNS Ping Utility for Solaris: Version 10.1.0.5.0 - Production on 19-
JUL-2007 16:27:54

Copyright (c) 1997, 2003, Oracle.  All rights reserved.

Used parameter files:
/oracle101/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST
= beatrix)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = curam101)))

here is the output from lsnrctl status:
bash-3.00$ lsnrctl status listener101

LSNRCTL for Solaris: Version 10.1.0.5.0 - Production on 19-JUL-2007
16:28:48

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                    listener101
Version                  TNSLSNR for Solaris: Version 10.1.0.5.0 -
Production
Start Date                19-JUL-2007 10:43:53
Uptime                    0 days 5 hr. 44 min. 55 sec
Trace Level              off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  /oracle101/network/admin/listener.ora
Listener Log File        /oracle101/network/log/listener101.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=beatrix)(PORT=1522)))
The listener supports no services
The command completed successfully

Netstat:

bash-3.00$ netstat -a | grep 1522
      *.1522              *.*                0      0 49152      0
LISTEN

So its listening and seems to be hooked up, but when i ever i run an
app locally, that connects to the db, or when i do a remote connection
using squirell, it fails with the error.

And here is the last line from the listener101.log file:
19-JUL-2007 16:28:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=beatrix)
(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener101)(
VERSION=168822016)) * status * 0

I dont have a clue where to go from here.

Any ideas?
OK (10 msec)

Replies