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
Listener Log File /u01/app/oracle/product/10.1.0.2/network/log/listener.
Listening Endpoints 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
01-02-2006, 07:16 PM
becuase the database hasnt registered itself with the listener, so the listener doesnt know what state the database is in
01-03-2006, 08:53 AM
Do i have to register it? or just leave it that way? does it matter?
01-03-2006, 09:04 AM
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
01-04-2006, 09:13 AM
thanks :) how do i register the database to the listener?
01-04-2006, 09:20 AM
it should do itself on startup if the defaults are set, otherwise you need to set the local_listener parameter
01-04-2006, 09:27 AM
I didnt do itself at startup :confused: , how do i set the local_listener parameter?
01-04-2006, 12:36 PM
As dave pointed out, are you using the default listener or different listener. check your listener.ora parameter file.