Re: listener load balancing

there was a syntax error
tnsnames should look like

pp4.world=

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

In article <6s1b7f$fsg$1_at_nnrp1.dejanews.com>,   kstingel_at_sairgroup.com wrote:
>
>
> 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
>

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