Understanding "lsnrctl status"

**Mark D Powell** · Jul 19 '05, 10:10 PM

Re: Understanding "lsnrct l status"

c-eriks@algonet.s e (Christian Eriksson) wrote in message news:<d0d6f67c. 0408160550.51f0 75ab@posting.go ogle.com>...[color=blue]
> 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[/color]

Starting with version 8.1 the Oracle instance and the listener have
the ability to automatically find each other without listener.ora
entries being predefinded for the database. Most listener.ora files
however would have had SID_DESC entries for the existing databases in
them since these were requried up to then. Habit, would result in
entries being made for new databases.

I believe this is the cause of the double listing for a database
instance via status. Unfortunately I am not allowed to change the
listener.ora and test if removing the now redundant entries and
bouncing the listener and databases 1- works correctly and 2- cleans
up the status enties.

As noted this is conjecture, but perhaps you can test it and post back
the results.

HTH -- Mark D Powell --

**Jan** · Jul 19 '05, 10:10 PM

Re: Understanding "lsnrct l status"

Service "ftgdb" has 2 instance(s).[color=blue]
> Instance "ftgdb", status UNKNOWN, has 1 handler(s) for this
> service...
> Instance "ftgdb", status READY, has 1 handler(s) for this service...[/color]

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@algonet.s e (Christian Eriksson) wrote in message news:<d0d6f67c. 0408160550.51f0 75ab@posting.go ogle.com>...[color=blue]
> 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[/color]

**Christian Eriksson** · Jul 19 '05, 10:10 PM

Re: Understanding "lsnrct l status"

Mark.Powell@eds .com (Mark D Powell) wrote in message news:<2687bb95. 0408161222.7804 0733@posting.go ogle.com>...[color=blue]
> c-eriks@algonet.s e (Christian Eriksson) wrote in message news:<d0d6f67c. 0408160550.51f0 75ab@posting.go ogle.com>...[color=green]
> > 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[/color]
>
> Starting with version 8.1 the Oracle instance and the listener have
> the ability to automatically find each other without listener.ora
> entries being predefinded for the database. Most listener.ora files
> however would have had SID_DESC entries for the existing databases in
> them since these were requried up to then. Habit, would result in
> entries being made for new databases.
>
> I believe this is the cause of the double listing for a database
> instance via status. Unfortunately I am not allowed to change the
> listener.ora and test if removing the now redundant entries and
> bouncing the listener and databases 1- works correctly and 2- cleans
> up the status enties.
>
> As noted this is conjecture, but perhaps you can test it and post back
> the results.
>
> HTH -- Mark D Powell --[/color]

Thank's for the answer!

I still can't pinpoint where the services are defined. In the
listener.ora file I can see the following for the LISTENER listener:

SID_LIST_LISTEN ER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ftgdb)
(ORACLE_HOME = /opt/oracle/product/9.2.0.1.0)
(SID_NAME = ftgdb)
)

I guess the SID_NAME entries in the two SID_DESC blocks defines the
services "PLSExtProc " and "ftgdb". My wondering is about the service
"ftgdbXDB". Can someone tell me where that service might be defined?

Regards Christian Eriksson

**Frank van Bortel** · Jul 19 '05, 10:10 PM

Re: Understanding "lsnrct l status"

Christian Eriksson wrote:
[color=blue]
> Mark.Powell@eds .com (Mark D Powell) wrote in message news:<2687bb95. 0408161222.7804 0733@posting.go ogle.com>...
>[color=green]
>>c-eriks@algonet.s e (Christian Eriksson) wrote in message news:<d0d6f67c. 0408160550.51f0 75ab@posting.go ogle.com>...
>>[color=darkred]
>>>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[/color]
>>
>>Starting with version 8.1 the Oracle instance and the listener have
>>the ability to automatically find each other without listener.ora
>>entries being predefinded for the database. Most listener.ora files
>>however would have had SID_DESC entries for the existing databases in
>>them since these were requried up to then. Habit, would result in
>>entries being made for new databases.
>>
>>I believe this is the cause of the double listing for a database
>>instance via status. Unfortunately I am not allowed to change the
>>listener.or a and test if removing the now redundant entries and
>>bouncing the listener and databases 1- works correctly and 2- cleans
>>up the status enties.
>>
>>As noted this is conjecture, but perhaps you can test it and post back
>>the results.
>>
>>HTH -- Mark D Powell --[/color]
>
>
> Thank's for the answer!
>
> I still can't pinpoint where the services are defined. In the
> listener.ora file I can see the following for the LISTENER listener:
>
> SID_LIST_LISTEN ER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /opt/oracle/product/9.2.0.1.0)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = ftgdb)
> (ORACLE_HOME = /opt/oracle/product/9.2.0.1.0)
> (SID_NAME = ftgdb)
> )
>
> I guess the SID_NAME entries in the two SID_DESC blocks defines the
> services "PLSExtProc " and "ftgdb". My wondering is about the service
> "ftgdbXDB". Can someone tell me where that service might be defined?
>
> Regards Christian Eriksson[/color]

See pfile - there's a Mutli-threaded Server for XDB defined.
Try http://localhost:8080 and you should get a log on screen.
--

Regards,
Frank van Bortel

Understanding "lsnrctl status"

Understanding "lsnrctl status"

Comment

Comment

Comment

Comment