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: Tue, 24 Jul 2007

I have oracle 10.1.0.5.0 and 10.2.0.1 installed on a Solaris 10
machine.

The listeners are set up on port 1522 and 1523. They are called
listener101 and listener102 respectively. Only one instance runs at a
time. However when i try to connect remotely, i get the above error.
Here is the output of some some commands: (using the 10.1.0.5
installation)

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)))
OK (10 msec)

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

last line of listener.log:
24-JUL-2007 10:03:23 * (CONNECT_DATA=(SID=curam101)(CID=(PROGRAM=)
(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.161.123)
(PORT=4152)) * establish * curam101 * 12505
TNS-12505: TNS:listener does not currently know of SID given in
connect descriptor

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

I am using squirrel to connect, using the oracle thin driver (which i
use to connect to other oracle instances on other servers).

any help would be much appreciated.

Replies