Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> listener load balancing
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
![]() |
![]() |