AW: Directing client connections to a set of nodes in 11gR2 RAC with SCAN
From: Jost, Jörg <Joerg.Jost_at_unitrade.com>
Date: Wed, 7 Sep 2011 18:17:13 +0200
Message-ID: <341EFE663A61124B9D46CFED9A78AC8E02C0AC37_at_exchange.unitrade.com>
>
> If you implement SCAN for your 3 or 4 Node 11gR2 RAC, how do you setup
> client applications to connect to a particular set of nodes?
> For example, say, you want your HR application connect to
> only node 1 and 2
> and Payroll application connect to only 2 and 3?
>
> Since TNS entry will have only SCAN name, how do we configure
> to direct the
> client applications to connect to only a set of nodes?
>
>
Date: Wed, 7 Sep 2011 18:17:13 +0200
Message-ID: <341EFE663A61124B9D46CFED9A78AC8E02C0AC37_at_exchange.unitrade.com>
>
> If you implement SCAN for your 3 or 4 Node 11gR2 RAC, how do you setup
> client applications to connect to a particular set of nodes?
> For example, say, you want your HR application connect to
> only node 1 and 2
> and Payroll application connect to only 2 and 3?
>
> Since TNS entry will have only SCAN name, how do we configure
> to direct the
> client applications to connect to only a set of nodes?
>
>
Hi Anurag,
You can handle this via services. Just point your connections against services which are only activated on the desired nodes.
I think this will do the trick.
Hth
Jörg Jost
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 07 2011 - 11:17:13 CDT