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

From: bomahony <bomahony_at_gmail.com>
Date: Thu, 19 Jul 2007 15:31:49 -0000
Message-ID: <1184859109.698081.107560@m3g2000hsh.googlegroups.com>

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) Received on Thu Jul 19 2007 - 10:31:49 CDT