Re: Setup two listeners on a machine

From: EdStevens <quetico_man_at_yahoo.com>
Date: 27 Dec 2006 17:35:27 -0800
Message-ID: <1167269727.725110.108730@79g2000cws.googlegroups.com>

RA wrote:
> 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

Why two listeners? One listener can serve as many databases as you have on the server, even different version databases.

Working with Oracle since v7.3, I can only remember one listener 'crash'.

Assuming you still think you need two listeners for high-availability, you set up the 'failover' in your tnsnames. See chapter 6 of the Net Services Reference. Received on Wed Dec 27 2006 - 19:35:27 CST