Re: Setup two listeners on a machine

On Dec 27, 8:35 pm, "EdStevens" <quetico_..._at_yahoo.com> wrote:
> 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
> > januWhy 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.

Ed,

There is a case where different version listeners are required. I believe that it has to do with differences in Oracle Net and SQL*Net such that pre-8.1.7 and 10g databases and listeners are not compatible.

Jared posted about this on the oracle-l a couple of weeks back.

-bdbafh Received on Thu Dec 28 2006 - 09:29:33 CST