Oracle-L: Re: Listener problem ....

From: Arup Nanda <arupnanda_at_hotmail.com>
Date: Tue, 21 Jan 2003 06:14:45 -0800
Message-ID: <F001.00535CB7.20030121061445@fatcity.com>

Joshua,

This is not a problem. From Oracle 8i onwards, the instance running can register itself with the listener running on the local host without any listener.ora file. Or, if the listener.ora is defined and the listener runs on the default port, 1521.

In this case you have one handler for the one defined in listener.ora file (under SID_LIST parameter) an another for the one that has been registered automatically.

HTH. Arup Nanda

Original Message ----- From: Joshua Becker To: Multiple recipients of list ORACLE-L Sent: Monday, January 20, 2003 11:59 PM Subject: Listener problem ....

Hi all,

I am wondering is there something wrong with my listener settings. I mean when I type

  LSNRCTL> services
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521)))   Services Summary...
  Service "TEST2" has 2 instance(s).
    Instance "TEST2", status UNKNOWN, has 1 handler(s) for this service...

      Handler(s):


        "DEDICATED" established:0 refused:0

           LOCAL SERVER
    Instance "TEST2", status READY, has 1 handler(s) for this service...
      Handler(s):


        "DEDICATED" established:1 refused:0 state:ready

           LOCAL SERVER

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

      Handler(s):


        "DEDICATED" established:0 refused:0

           LOCAL SERVER
    Instance "TEST1",! status READY, has 1 handler(s) for this service...
      Handler(s):


        "DEDICATED" established:0 refused:0 state:ready

           LOCAL SERVER

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

      Handler(s):


        "DEDICATED" established:0 refused:0

           LOCAL SERVER
    Instance "TEST3", status READY, has 1 handler(s) for this service...
      Handler(s):


        "DEDICATED" established:0 refused:0 state:ready

           LOCAL SERVER

Why it shows service XXXX has 2 instances?

I am using Sun Solaris with Oracle 8.1.7 and 9.2.

rgds,

Joshua

Gratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jan 21 2003 - 08:14:45 CST