| What does an UNKNOWN state mean [message #59869] |
Tue, 30 December 2003 10:58  |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
I ran
lsnrctl services and got a bunch of output. As is read through it listed all the databases in my server.
Some of them said READY status and others said UNKNOWN.
I shutdown the machine and restarted everything but its still the same.
I tried reading the Oracle Docs for this but may be I am looking at the wrong page. Can someone tell me where I can find the best info regarding this.
Thanks
Scott
|
|
|
|
| Re: What does an UNKNOWN state mean [message #59870 is a reply to message #59869] |
Tue, 30 December 2003 11:38  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
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.
You can either ignore it, or remove the SID_LIST from your listener.ora so that your instance registers with default listener running 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=1522))";
When you restart the instance,it should register with this listener .
Oracle infact doesnt recommend having SID_LIST in listener.ora (since 9i) becos it seems it causes additional overhead on listener process. I havent seen this(ie slowdown) practically,just passing on the information I heard.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
