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

On Jul 24, 11:08 am, bomahony <bomah..._at_gmail.com> wrote:
> 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.

As Frank as already suggested to you, you must set database parameter local_listener,
in fact, you see in the output of lsnrctl status that there are no services registered. If listener
is configured on a non-default address-port you must specify explicity parameter local_listener
to say database where to register itself (you can use an alias defined in tnsnames.ora of the
dbserver)

Bye
 Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.worpress.com Received on Tue Jul 24 2007 - 05:28:40 CDT