Re: Directing client connections to a set of nodes in 11gR2 RAC with SCAN

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 7 Sep 2011 13:21:58 -0300
Message-ID: <CAJ2dSGSCpZkvfDSKaXKX6kyHRac-CBhiRpNuCkuJWvPofd2uzA_at_mail.gmail.com>

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_at_gmail.com> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 07 2011 - 11:21:58 CDT