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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Listener load balance

RE: Listener load balance

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Wed, 18 Sep 2002 09:58:38 -0800
Message-ID: <F001.004D28FD.20020918095838@fatcity.com>










LOAD_BALANCE=ON in  TNS descriptor means that the client will try to randomly connect to any
of the dress descriptions in the descriptor, thus evenly spreading the load. On the other hand, you can have
a listener based balancing, which is facilitated through the "local_listener" init.ora parameter. When
the instance starts up, it attempts to register the dispatchers with any listener listed in the local_listener
parameter. When a listener encounters a connection request, it uses a dispatcher from the machine with
the least CPU load. Listener load balancing is used in the OPS environments where several nodes are
accessing the same database and the DBA wants to spread the accesses evenly accross the nodes.
-----Original Message-----
From: Kevin Lange [mailto:kgel@ppoone.com]
Sent: Wednesday, September 18, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Listener load balance

I did not know about the LOAD_BALANCE=ON .  Thanks.
-----Original Message-----
From: Ramon E. Estevez [mailto:com.banilejas@codetel.net.do]
Sent: Wednesday, September 18, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Listener load balance

TKS Yechiel for your help,
 
Two more questions.
 
Is there any way I can find out which one of the 2 addresses I am using ?
 
Which is better solution this method or add another listener ?
 
Tks for your help
 
TIA
 
Ramon
 
----- Original Message -----
From: Yechiel Adar
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 18, 2002 4:09 AM
Subject: Re: Listener load balance

Hello Ramon
 
I think that you have an error in your parameters.
As far as I know (not much) the second network card have a different TCP/IP address.
You have to put this address in the added line in listener.ora and add (load_balance=on).
      (ADDRESS_LIST =
         (load_balance=on)
        (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))   ---> Original
        (ADDRESS = (PROTOCOL = TCP)(HOST = new network card address)(PORT = 1526))   ---> Added
      )
   
In the tnsnames you have to use load_balance=on and put both addresses and ports in the address list:
(description=
 (address list=
  (load_balance=on)
  (address=(protocol=TCP,host=225.125.110.5,port=1521))
  (address=(protocol=TCP,host=new network card address,port=1526))
 
This way the clients will use both address.
Yechiel Adar
Mehish
----- Original Message -----
Sent: Tuesday, September 17, 2002 10:19 PM
Subject: Re: Listener load balance

Tks Kevin,
 
I didn't setup the DNS to do that.  I ping myserver and is using the new address.  Don't know how to do it either.
 
What I am planning to do is to set the manually the ip address to the both port.  I am using local names.
 
        (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.5)(PORT = 1521))   ---> Original
        (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.6)(PORT = 1526))   ---> Added

 
Ramon
 
----- Original Message -----
Sent: Tuesday, September 17, 2002 12:03 PM
Subject: RE: Listener load balance

Your HOSTNAME of 'myserver' would tell you which.
 
Since you have the same hostname on the listener, both ports would currently be using the same IP address.
 
Did you setup DNS so that the cards share a Hostname ?
-----Original Message-----
From: Ramon E. Estevez [mailto:com.banilejas@codetel.net.do]
Sent: Tuesday, September 17, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L
Subject: Listener load balance

Hi list,
 
Scenario Win2000 server, 8.1.7.
 
I added a network card to my DB Server.  I want the listener to accept connections for the 2 IP address to make load balance.  I just added a line to the listener file with a different port.
 
How can I assure that the port 1521 is listening for the net address 01 and the port 1526 in the address 02 ?
 
Is that correct ?
 
-----------------------
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))   ---> Original
        (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1526))   ---> Added
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481))
    )
  )
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\Oracle\Ora8I)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = C:\Oracle\Ora8I)
      (SID_NAME = ORCL)
    )
  )
 
----------------------------
 
TIA,
 
 
Ramon E. Estevez
com.banilejas@codetel.net.do
809-565-3121
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.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 Wed Sep 18 2002 - 12:58:38 CDT

Original text of this message

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