Understanding "lsnrctl status"

[Christian Eriksson]

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

[Mark D Powell]

c-*****@algonet.se (Christian Eriksson) wrote in message news:<d0**************************@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

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]

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-*****@algonet.se (Christian Eriksson) wrote in message news:<d0**************************@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

[Christian Eriksson]

Ma*********@eds.com (Mark D Powell) wrote in message news:<26**************************@posting.google. com>...

c-*****@algonet.se (Christian Eriksson) wrote in message news:<d0**************************@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

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 --

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_LISTENER =
(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]

Christian Eriksson wrote:

Ma*********@eds.com (Mark D Powell) wrote in message news:<26**************************@posting.google. com>...

c-*****@algonet.se (Christian Eriksson) wrote in message news:<d0**************************@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

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 --

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_LISTENER =
(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

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