Re: Two instances, two listeners and /etc/services

From: Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1997/03/11
Message-ID: <5g483d$lrq@gw.PacBell.COM>#1/1

> Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE> wrote:
> >However, I would like to point out that you don't need a separate listener
> >for each instance on the same node: In all but a few exceptions, a single
> >listener is able to handle connections into multiple instances in the same
> >node. You merely have to configure the /etc/listener.ora file properly so

> I've tried to configure my listener.ora to handle for multiple instances but
> it seemed that sometimes the listener connects the user to the wrong instance.
> The log file shows that the listener has connected the user to the correct
> sid.
> What I had for my listener.ora is like this:
 

> (ADDRESS_LIST =
> (
> key for first instance
> )
> (
> key for second instance
> )
> (
> community ,host,port for the listener used
> )
> )

> And under my tnsnames.ora file, I have
 

> first instance = (
> description and connect data info
> )
> second instance = (
> description and connect data info
> )

> Thanks for any advice rendered.

Here's a sample listener w/ multiple SID's:

LISTENER=
 (ADDRESS_LIST=
  (ADDRESS=

   (COMMUNITY=finance.world)
   (PROTOCOL=tcp)
   (HOST=ppdss2.hycrc.pacbell.com)
   (PORT=1521)

  )
 )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER=
 (SID_LIST=
  (SID_DESC=
   (SID_NAME=DMD1)
   (ORACLE_HOME=/u01/oracle/product/7.3.2.2)   )
  (SID_DESC=
   (SID_NAME=OTST)
   (ORACLE_HOME=/u01/oracle/product/7.3.2.2)   )
  (SID_DESC=
   (SID_NAME=STST)
   (ORACLE_HOME=/u01/oracle/product/7.3.2.2)   )
  (SID_DESC=
   (SID_NAME=DMD2)
   (ORACLE_HOME=/u01/oracle/product/7.3.2.2)   )
  (SID_DESC=
   (SID_NAME=ABCDSS)
   (ORACLE_HOME=/u02/oracle/product/7.3.2.2)   )
 )

Here's a sample entry in tnsnames.ora:

DMD2 =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY=finance.world)
          (PROTOCOL = TCP)
          (Host = ppdss2.hycrc.pacbell.com)
          (Port = 1521)
        )

    )
    (CONNECT_DATA = (SID = DMD2)
    )
  )

Hope this helps.

Johnny Chan
Independent Oracle Specialist Received on Tue Mar 11 1997 - 00:00:00 CST