Re: Session distribution on 9i RAC

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Mon, 23 Aug 2004 08:25:37 +1000
Message-ID: <4127cb76$0$21036$afc38c87@news.optusnet.com.au>

Steffen Roegner wrote:

> Howard J. Rogers wrote:

>> Steffen Roegner wrote:
>>
>>

>>>Howard,
>>>
>>>We are talking about one node out of that I want to prevent from
>>>registering with remote listeners here.

>>
>>
>> I understand that. It's called a 'spare node configuration', and as I
>> said, the only way to do it when instances are > 2 is to not set the
>> remote_listener parameter for the spare node(s) (and also make sure no
>> client tnsnames.ora files make reference to the spare node(s) directly,
>> of course).

> 
> We have exactly one client making direct reference to this spare node -
> this is our batch processing using ORACLE_SID. Would you consider this
> to be wrong (although it works for us in our attempt to dedicate the
> node)?

Absolutely not. A "spare" node doesn't mean a useless piece of metal. It means a fully-fledged RAC instance ready to do whatever you ask of it... just so long as it's not used by regular users under ordinary circumstances. So, your setup is absolutely fine. Having a spare for some batch processing is *exactly* what this sort of configuration is intended for.  

Everything else in your post looked fine, too.

Best regards
HJR Received on Sun Aug 22 2004 - 17:25:37 CDT