Re: Understanding "lsnrctl status"

Service "ftgdb" has 2 instance(s).
> Instance "ftgdb", status UNKNOWN, has 1 handler(s) for this
> service...
> Instance "ftgdb", status READY, has 1 handler(s) for this service...

One with the UNKNOWN status is that one which is definied statically - it is writen in listener.ora file
One with status READY si that one which is registered automatically - when DB is starting up PMON automatically registers DB to the listener. It is doing so also after starting up every 1 min.

You need to have the static definition since some tools (e.g. OEM) require it.

Jan

c-eriks_at_algonet.se (Christian Eriksson) wrote in message news:<d0d6f67c.0408160550.51f075ab_at_posting.google.com>...
> Hi!
>
> I want to clarify, for myself, some basic facts about Oracle Client
> Server configuration. I start with the listener configuration on the
> server side.
>
> What block(s) in what configuration file(s) defines the services
> (shown below)?
>
> What causes there to be more than one instance of a service (shown
> below)?
>
> Output from "lsnrctl status" (Oracle 9.2.0.1.0 on Sun Solaris 8):
>
> ........................
>
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> Service "ftgdb" has 2 instance(s).
> Instance "ftgdb", status UNKNOWN, has 1 handler(s) for this
> service...
> Instance "ftgdb", status READY, has 1 handler(s) for this service...
> Service "ftgdbXDB" has 1 instance(s).
> Instance "ftgdb", status READY, has 1 handler(s) for this service...
> The command completed successfully
>
> Regards Christian Eriksson
Received on Tue Aug 17 2004 - 08:32:08 CEST