Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple instances on one listener

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US