Re: Understanding "lsnrctl status"

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0408161222.78040733_at_posting.google.com>...
> 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
>
> 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 Received on Tue Aug 17 2004 - 09:51:22 CEST