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

On Jul 19, 8:31 am, bomahony <bomah..._at_gmail.com> wrote:
> 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

Your database, if up, should be registering as a service. This should be happening automatically. Do you see it with other listeners? http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/listenercfg.htm#sthref947

It might have something to do with how you configured service registration in the init.ora, or you might need to be explicit about oracle_home, or you might need to bring up the db.

> 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.

Please copy and paste the exact commands you are using and the results. Syntax makes a difference as to whether you are really local or just pretending to be non-local.

>
> 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)

jg

--
@home.com is bogus.
"Can the following paragraph be removed? It seems to be relevant only
to Oracle8" - OracleŽ Database Net Services Administrator's Guide 10g
Release 2 (10.2)