lsnrctl - why status unknown ?

[Ratzie]

Why when we give the command lsnrctl we get the status unknown?

It does give the time up ect. but it does not what to say they status.


LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 13-MAR-2006 10:39:55

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 10.1.0.3.0 - Production
Start Date 13-MAR-2006 09:11:41
Uptime 0 days 1 hr. 28 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/app/oracle/network/admin/listener.ora
Listener Log File /opt/app/oracle/network/log/listener.log
Listener Trace File /opt/app/oracle/network/trace/listener.trc
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.101)(PORT=1521)))
Services Summary...
Service "DATADB" has 1 instance(s).
Instance "DATADB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[Geoff Wild]

Are you running it as root or as the oracle user?

Rgds...Geoff

[Ratzie]

as oracle user

[Steven E. Protter]

Shalom,

There is probably some obtuse technical requirements to get that status.

I've seen it for years and only cared if the listener actually was not working.

If it is, the cause is probably a lack of customer service oriented programming on their part, nothing to worry about.

Not an asnwer, but an opinion. It surprises me Oracle hasn't complained about my postings over the years.

SEP

[Geoff Wild · Accepted solution]

http://www.orafaq.com/faq/what_does_unknown_status_mean_in_lsnrctl_status_output

"An 'UNKNOWN' status means that the instance is registered statically (with a SID_LIST) in the listener.ora file, rather than dynamically with service registration."

Rgds...Geoff

[James A. Donovan]

An UNKNOWN status means that the instance is registered statically
(with a SID_LIST) in the listener.ora file rather than dynamically with
service registration. Therefore, the status is not known.

The SID_LIST in the listener.ora file is not required.
One of the reasons why Oracle recommends not using one, is because it
may cause unnecessary overheads on the listener process.
The SID_LIST section only needs to be used for instances such as PLSExtProc.
It is not normally a problem having the instance duplicated in the SID_LIST,
but it is preferable not to have it.

[Sandman!]

Hi,

'UNKNOWN' status means that the instance is registered statically (with a SID_LIST) NOT dynamically in the listener.ora file. You can either ignore it or remove SID_LIST from your listener.ora so that your instance registers with the default listener on port 1521 or specify a local listener in your pfile (or spfile) with the host, port, protocol information as follows:

alter system set LOCAL_LISTENER="(address=(protocol=tcp)(host=yourhost)(port=your_listener_port))";

When you restart the instance, it should register with this listener. Having SID_LIST in listener.ora (since Oracle 9i) is not recommended since it causes additional overhead on the listener process.

cheers!

[Indira Aramandla]

Hi LHradowy,

An UNKNOWN status means that the instance is registered statically (with a SID_LIST) in the listener.ora file rather than dynamically with service registration. Therefore, the status is not known.

If the SID is not registered with the listener (lsnrctl status; Instance , status UNKNOWN)
but the service name is registered (status READY), then the connection to the info store db will fail (using SID), even though it is possible to make a sqlplus connection using the tnsnames.ora connect info, which specifies service_name for connections.

The SID_LIST in the listener.ora file is not required. One of the reasons why Oracle recommends not using one, is because it may cause un-necessary overheads on the listener process. The SID_LIST section only needs to be used for instances such as PLSExtProc. It is not normally a problem having the instance duplicated in the SID_LIST, but it is preferable not to have it.

The handlers are like this. One is for the Dedicated service in the SID_LIST. One is for the Dedicated service that has automatically registered itself with the listener process (instance_name in the init.ora file). One is for each Dispatcher that has started (Giop and SGiop use).


Indira A

[Yogeeraj_1]

hi,

see also metalink note: 151223.1 "Oracle Net 9i Listener - Lsnrctl services / "status UNKNOWN" displayed"


kind regards
yogeeraj

[Ratzie]

excellent