Re: Directing client connections to a set of nodes in 11gR2 RAC with SCAN
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: anuragdba@xxxxxxxxx
- Date: Wed, 7 Sep 2011 13:21:58 -0300
You can achieve that using services. You define a service and set it as
enabled on only the subset of nodes you want to connect to, then in the TNS
entry you use that service in SERVICE_NAME and SCAN will hand off the
connections to the apropriate nodes.
hth
Alan.-
On Wed, Sep 7, 2011 at 12:42 PM, Anurag Verma <anuragdba@xxxxxxxxx> wrote:
> 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?
>
>
>
> --
>
> Anurag Verma,
> Database Administrator
> ERCOT(Electric Reliability Council of Texas),
> Texas 76574
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
