Oracle-L: Listener

From: Ramon E. Estevez <com.banilejas_at_codetel.net.do>
Date: Sun, 23 Feb 2003 05:43:37 -0800
Message-ID: <F001.00555EC4.20030223054337@fatcity.com>

Hi list,

I have my DB server with 2 network card and I want to split the connections between the users to balance the load.

I added LOAD_BALANCE=ON in the listener.ora and another line with the new ip address with the port 1526.

Now all the connections are managed with the new address and the port 1526.

(ADDRESS_LIST=
(LOAD_BALANCE=ON)

          (ADDRESS = (PROTOCOL = TCP) (HOST=125.115.100.10)(PORT=1521)
          (ADDRESS = (PROTOCOL = TCP) (HOST=125.115.100.11)(PORT=1526)

)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=ON)

      (ADDRESS = (PROTOCOL = TCP)(HOST = 125.115.100.10)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 125.115.100.11)(PORT = 1526))

    )
(CONNECT_DATA =

      (SERVICE_NAME = ORCL)
    )
  )

Any suggestions, comments will be appreciated.

TIA Ramon E. Estevez
com.banilejas_at_codetel.net.do
809-565-3121

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

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 Sun Feb 23 2003 - 07:43:37 CST