Re: Multiple listeners for MTS

On Feb 25, 6:05 pm, "domin..._at_gmail.com" <domin..._at_gmail.com> wrote:
> Ok,
> I got it working by
> putting an additional line like:
> *.local_listener='LISTENER_TEST3'
> *.local_listener='LISTENER_TEST3_2'
>
> the second line is my new listener,
> now both listener is running MTS now.
>
> Dominica

Hi Dominica,

Try
*.local_listener='(address_list=(address=(protocol=TCP)(host=hostname) (port=port1))(address=(protocol=TCP)(host=hostname)(port=port2)))'

You can use alter system to do it and see the effect immediately (may need alter system register if you don't want to wait up to 1 minute).

To Ana,

Multiple listeners are sometimes used for higher resilience against listener crash, for easier maintenance, or to some extent protection from login storm. Oracle has some documents about the benefit of multiple listeners. Saying a NIC is a single threaded device is like saying a server with only one CPU will never benefit from parallel executions, or setting a buffer size above 1500 at any network layer above Ethernet is always a futile effort. Neither is true.

Yong Huang Received on Wed Feb 27 2008 - 22:21:09 CST