Hi,

I have a question on Listener process.

I have two listeners (L1 and L2) and two databases(DB1 and DB2) on one
machine.

L1 and L2 are using the port 1521 and 1522.

My question is,

How do I set up failover for L1 and L2, meaning if L1 crashes, my
user connections should automatically connect to L2.

A sample code would be great.

Thanks a bunch
janu

janu schreef:
> Hi,
>
> I have a question on Listener process.
>
> I have two listeners (L1 and L2) and two databases(DB1 and DB2) on one
> machine.
>
> L1 and L2 are using the port 1521 and 1522.
>
> My question is,
>
> How do I set up failover for L1 and L2, meaning if L1 crashes, my
> user connections should automatically connect to L2.
>
> A sample code would be great.
>
> Thanks a bunch
> janu
>
No - connections are there as a result of
a hand-off by the listener. When a listener stops,
connections still exist; there is no reason to reconnect.

New connection attempts, however, will fail with a
'No Listener' error.

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

On Dec 28, 7:11 pm, Frank van Bortel <frank.van.bor...@gmail.com>
wrote:
> janu schreef:
>
>
>
> > Hi,
>
> > I have a question on Listener process.
>
> > I have two listeners (L1 and L2) and two databases(DB1 and DB2) on one
> > machine.
>
> > L1 and L2 are using the port 1521 and 1522.

Janu, you should be able to use one listener for both databases. There
is usually no need for multiple listeners unless you need to listen for
multiple protocols.

HTH -- Mark D Powell --

>
> > My question is,
>
> > How do I set up failover for L1 and L2, meaning if L1 crashes, my
> > user connections should automatically connect to L2.
>
> > A sample code would be great.
>
> > Thanks a bunch
> > januNo - connections are there as a result of
> a hand-off by the listener. When a listener stops,
> connections still exist; there is no reason to reconnect.
>
> New connection attempts, however, will fail with a
> 'No Listener' error.
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...- Hide quoted text -- Show quoted text -