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

From: bomahony <bomahony_at_gmail.com>
Date: Tue, 24 Jul 2007 09:08:21 -0000
Message-ID: <1185268101.824353.73950@m3g2000hsh.googlegroups.com>

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. Received on Tue Jul 24 2007 - 04:08:21 CDT