LISTENER status unknown

[yxez]

Hi Friends,

I have the following listener status log for our ora10g db with SID=ora10 :

=================================
Listener Parameter File /u01/app/oracle/product/10.1.0.2/network/admin/listene
r.ora
Listener Log File /u01/app/oracle/product/10.1.0.2/network/log/listener.
log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=P520)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora10" has 1 instance(s).
Instance "ora10", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
================================

What does >>Instance "ora10", status UNKNOWN<< mean? why it is unknown?

Thanks a lot

[davey23uk]

becuase the database hasnt registered itself with the listener, so the listener doesnt know what state the database is in

[yxez]

thanks davey....

Do i have to register it? or just leave it that way? does it matter?


Thanks again

[davey23uk]

if your listener is called LISTENER and listens on port 1521 when the databases comes up (9i and higher) it should register itself and the status will change to READY.

Any no it doesnt really matter - it just saves you having to list things in the listener.ora file

[yxez]

thanks how do i register the database to the listener?

[davey23uk]

it should do itself on startup if the defaults are set, otherwise you need to set the local_listener parameter

[yxez]

I didnt do itself at startup , how do i set the local_listener parameter?

[sambavan]

As dave pointed out, are you using the default listener or different listener. check your listener.ora parameter file.


Also check your services

lsnrctl services