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 the listener running on port 1521, or specify a local listener in your pfile (or spfile) with the host, port, protocol information as follows:
Example:
alter system set LOCAL_LISTENER="(address=(protocol=tcp)(host=yourhost)(port=1522))" SCOPE=SPFILE;
When you restart the instance, it should register with this listener automatically.
Oracle, in fact, doesn't recommend having SID_LIST in listener.ora (since 9i) because it seems to cause additional overhead on the listener process.
Regards.
-----Original Message-----
From: Bheemsen Aitha [mailto:[Email address protected]
Sent: sexta-feira, 28 de Setembro de 2007 17:35
To: [Email address protected]
Cc: Claudio Freire
Subject: RE: How many instances ?
What about these lines?
Service "ITNSTAGE" has 2 instance(s).
Instance "ITNSTAGE", status UNKNOWN, has 1 handler(s) for this service...
Instance "ITNSTAGE", status READY, has 1 handler(s) for this service...
-----Original Message-----
From: Claudio Freire [mailto:claudio.[Email address protected]
Sent: Friday, September 28, 2007 9:33 AM
To: Bheemsen Aitha
Subject: RE: How many instances ?
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text
Itīs ok. No problem...normal...
You have defined the "PLSExtProc" in listner.ora
Regards.
-----Original Message-----
From: Bheemsen Aitha [Email address protected]
Sent: sexta-feira, 28 de Setembro de 2007 17:30
To: LazyDBA Discussion
Subject: How many instances ?
Hi,
We have only one db and one instance running on our Solaris machine.
However when I run the following command, it says two instances running.
lsnrctl status
Here is the output:
Service "ITNSTAGE" has 2 instance(s).
Instance "ITNSTAGE", status UNKNOWN, has 1 handler(s) for this
service...
Instance "ITNSTAGE", status READY, has 1 handler(s) for this
service...
Service "ITNSTAGEXDB" has 1 instance(s).
Instance "ITNSTAGE", status READY, has 1 handler(s) for this
service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
Does anyone see any problem here?
Thanks
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page