Understanding "lsnrctl status"

From: Christian Eriksson <c-eriks_at_algonet.se>
Date: 16 Aug 2004 06:50:32 -0700
Message-ID: <d0d6f67c.0408160550.51f075ab@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 Mon Aug 16 2004 - 08:50:32 CDT