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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

First of all, you do not have consent from the Ministry of Interior to use Our Queens name for servers.
Because of this, FBI's working with flaws.

Secondly, use the database parameter local_listener wisely, and perform alter system register. Then query your listener again - it should be supporting services now.

You local connection may go through bequeath - no listener required, just the SID as environment setting

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGn4xRLw8L4IAs830RAtnKAJ4tG60gHeN6KyVkQDsAQqbBjA4EFACfUiSE zbOXZgS7K9wuzguF+AWoceA=
=Ua5v
-----END PGP SIGNATURE----- Received on Thu Jul 19 2007 - 11:07:45 CDT