Re: Multiple instances on one listener

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Mon, 24 Jan 2000 23:00:55 GMT
Message-ID: <HQ4j4.94256$n3.1813814@news0.telusplanet.net>

Your listener.ora needs something like the following. In this example it's listening for 2 SIDs.

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= MERAX)


        )
        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= PROD)


        )
        (ADDRESS=


          (COMMUNITY= TCP)


          (Host = xxx.xxx.xxx.xxxx)


          (PROTOCOL= TCP)


          (Port= 1526)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 20
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = MERA)
    )
    (SID_DESC =
      (SID_NAME = PROD)
    )
  )

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Michael Reali <miker_at_newcenturysoftware.com> wrote in message news:388CA50E.D26CE531_at_newcenturysoftware.com...

> I asked this a few months ago and was given the answer.  I misplaced it
> and now I ask again...
> Could someone tell me how to configure a 7.3.4 listener so that I can
> hit multiple instances from my client machines without having to switch
> the ORACLE_SID environment variable?
>
> MR
>

Received on Mon Jan 24 2000 - 17:00:55 CST