RE: Listener load balance

Wed, 18 Sep 2002 08:47:15 -0700

are either of you or any one on this list working with 11i applications?  I am curious as to how the load balancing works against the hard
coding of web service infomation in the FND profile options which seems to only provide configuration for one application tier.  Does the
second tier only contain one entry for itself within its listener.ora and all the initial routing is handled by the first tier?  I haven't
implemented this but I envision that during navigation within the apps the clients connection would be redirected to the web addresses
defined in the profile options causing issues with established connections.  I hope to be able to periodicaly duplicate my first application
tier to a second tier and could use some insight on what to consider in this scenario.  Perhaps a good doc source would suffice.
-----Original Message-----
From: Yechiel Adar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 5:09 AM
To: Multiple recipients of list ORACLE-L
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:[EMAIL PROTECTED]]
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
[EMAIL PROTECTED]
809-565-3121

Reply via email to