Re: Setup two listeners on a machine

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

You need to set up the local_listener and remote_listener in init.ora. You need to enable failover in tnsnames.ora. Sample code can be found in the Net administrators manual. Please do not cross and/or multipost.

-- 
Sybrand Bakker
Senior Oracle DBA