RE: Multiple listeners question

From: Jeffery Stevenson <jeff_at_mpv.com>
Date: Mon, 7 Aug 2000 10:42:47 -0500
Message-Id: <10582.113974@fatcity.com>

On the client-side (after the multiple listeners are configured), you can do the balancing with the following (unless you are balancing the listener usage yourself):

<alias> =
  (DESCRIPTION=(load_balance=on)
    (ADDRESS=(PROTOCOL=tcp)(PORT=<1st listener port>)...     (ADDRESS=(PROTOCOL=tcp)(PORT=<2nd listener port>)... ...

Also, make sure that when you start them up, you specify the name of each one--using the example provided below, you would issue the following commands:

lsnrctl start LSNR01
lsnrctl start LSNR02

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Suzy Vordos Sent: Monday, August 07, 2000 10:15 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Multiple listeners question

Yes, this can be done, here is an example...

####
# LSNR01
####

LSNR01 =
  (ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=LSNR01))
(ADDRESS= (PROTOCOL= TCP)(Host=host.domain)(Port= 1521))
  )
SID_LIST_LSNR01 =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = oradb01)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')

    )
    (SID_DESC =
(SID_NAME = oradb02)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')

    )
  )
STARTUP_WAIT_TIME_LSNR01 = 0
CONNECT_TIMEOUT_LSNR01 = 10
TRACE_LEVEL_LSNR01 = OFF

####
# LSNR02
####

LSNR02 =
  (ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=LSNR02))
(ADDRESS= (PROTOCOL= TCP)(Host=host.domain)(Port= 1526))
  )
SID_LIST_LSNR02 =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = oradb01)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')

    )
    (SID_DESC =
(SID_NAME = oradb02)
(ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6)
(ENVS='EPC_DISABLED=TRUE')

    )
  )
STARTUP_WAIT_TIME_LSNR02 = 0
CONNECT_TIMEOUT_LSNR02 = 10
TRACE_LEVEL_LSNR02 = OFF

> Andrey Bronfin wrote:
>
>
> Dear all !
>
> I'm going to administer an Oracle 8.1.6 DB on Sun 220 machine .
> Most of the SQL statements against the DB will retrieve a values from
> a BLOB or a CLOB column .
> Typical LOB size is ~25 - 50K .
> We expect ~ 700 such queries per second .
>
> The question : someone suggested me to configure more than one
> listener on the DB server in order to balance the load .
> Do U think it's appropriate ? Does anyone have any experience with
> multiple listeners on the same machine and for the SAME INSTANCE ?
> How can i implement multiple listeners ?
> Are there any papers on this
>
> TIA
>
> Andrey Bronfin
> VisualTop.com
>
>
>

--
Author: Suzy Vordos
  INET: lvordos_at_uswest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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

Received on Mon Aug 07 2000 - 10:42:47 CDT