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

Home -> Community -> Usenet -> c.d.o.server -> listener load balancing

listener load balancing

From: <kstingel_at_sairgroup.com>
Date: 1998/08/26
Message-ID: <6s1b7f$fsg$1@nnrp1.dejanews.com>#1/1

I have setup non MTS listener load balancing by creating two listeners which listen on different ports both of which reference the one database.

Problem is Im not sure if it works, it looks like all connections just go the first address entry (which points to listener1) in the tnsnames.ora file.

If I shutdown the first listener, you would expect connections to go to listener2 the second entry in the tnsnames.ora file but they dont you just get a connection error.
(the second listener works ok if I switch the order in the tnsnames.ora)

Has anybody set this up.

regards
Kelvin

sampledb.world=

	(DESCRIPTION=
	(ADDRESS_LIST =
	     (ADDRESS =	(COMMUNITY = TCP.world)

(PROTOCOL = TCP)
(Host = server1)
(Port = 1529))
) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = server1)
(Port = 1528))
) (CONNECT_DATA=(SID=sampledb)))

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 00:00:00 CDT

Original text of this message

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