RE: Listener load balance

From: Kevin Lange <kgel_at_ppoone.com>
Date: Tue, 17 Sep 2002 09:03:46 -0800
Message-ID: <F001.004D1755.20020917090346@fatcity.com>

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: Kevin Lange
  INET: kgel_at_ppoone.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 Tue Sep 17 2002 - 12:03:46 CDT