Re: lsnrctl status problems

Hi George

You will get the status as UNKNOWN if you have SID_DESC under the SID_LIST section of the ORacle 9i Listener.ora file. The SID_LIST is not required in the listener.ora as the Service handlers are been takecn care by the PMON background process based on the value of SERVICE_NAME,INSTANCE_NAME in init.ora file as well as the service Alias in the TNSNAMES.ORA.

This PMON functionality is been added in Oracle 8i Releasese. You can easily see the difference as when you start the listener with lsnrctl start and do imeediately lsnrctl status, you will see only one list of SID as been mentioned in your listener.ora but after around 1-2 minutes, you can do lsnrctl status again and now you will see two SID list as the other one is started by the Oracle background process PMON

Good Luck
Indy

george_working_at_hotmail.com (george bagley) wrote in message news:<ad097928.0210290636.26b78140_at_posting.google.com>...
> I am getting the following when I do a lsnrctl status?
>
> LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 29-OCT-2002
> 14:33:53
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 9.2.0.1.0 -
> Production
> Start Date 29-OCT-2002 14:28:31
> Uptime 0 days 0 hr. 5 min. 22 sec
> Trace Level support
> Security OFF
> SNMP ON
> Listener Parameter File
> /u01/app/oracle/product/920/network/admin/listener.ora
> Listener Log File
> /u01/app/oracle/product/920/network/log/listener.log
> Listener Trace File
> /u01/app/oracle/product/920/network/log/listener.trc
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.off.company.com)(PORT=1521)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.off.company.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.off.company.com)(PORT=2100))(Presentation=FTP)(Session=RAW))
> Services Summary...
> Service "DBDEV" has 1 instance(s).
> Instance "DEV", status READY, has 1 handler(s) for this service...
> Service "DEV" has 1 instance(s).
> Instance "DEV", status UNKNOWN, has 3 handler(s) for this service...
> Service "DEVXDB" has 1 instance(s).
> Instance "DEV", status READY, has 1 handler(s) for this service...
> Service "TTS" has 2 instance(s).
> Instance "TTS", status UNKNOWN, has 3 handler(s) for this service...
> Instance "TTS", status READY, has 1 handler(s) for this service...
> The command completed successfully
>
> Why is everything listed twice and why when I start the listener do I
> get status is UNKNOWN.
>
> Can someone please help me here as I am at a loss.
>
> My config files are below;
>
> Thanks
>
>
> ............................................................
>
> Here is my tnsnames.ora
>
> DBDEV =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = TCP)(HOST = 245.245.245.245)(PORT = 1521))
> (CONNECT_DATA = (SID = DEV)))
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
> (CONNECT_DATA = (SID = PLSExtProc)
> (PRESENTATION = RO)))
>
> .........................................................
>
> Here is my listener.ora
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)
> (KEY = PNPKEY))
> (ADDRESS = (PROTOCOL = TCP)
> (HOST = db)
> (PORT = 1521)))
>
> SID_LIST_LISTENER=
> (SID_LIST=
> (SID_DESC=
> (ORACLE_HOME=/u01/app/oracle/product/920)
> (SID_NAME= DEV)
> (PRESPAWN_MAX=30)
> (PRESPAWN_LIST=
> (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))))
> (SID_DESC =
> (ORACLE_HOME = /u01/app/oracle/product/920)
> (SID_NAME = TTS)
> (PRESPAWN_MAX=30)
> (PRESPAWN_LIST=
> (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1)))))
>
> TRACE_LEVEL_LISTENER=SUPPORT
> TRACE_FILE_LISTENER=LISTENER
> TRACE_DIRECTORY_LISTENER=/u01/app/oracle/product/920/network/log
> CONNECT_TIMEOUT_LISTENER=30
>
> .............................................................
>
> Here is my sqlnet.ora
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
> SQLNET.EXPIRE_TIME= 60
Received on Thu Oct 31 2002 - 22:28:53 CET