Re: OCF(v2).

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 05 Nov 2007 18:53:02 -0800
Message-ID: <1194317577.770047@bubbleator.drizzle.com>

per.lanvin_at_fouredge.se wrote:
> On Nov 5, 6:32 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> per.lan..._at_fouredge.se wrote:
>>> Hi,
>>> I need some advise from someone who knows alot about OCF and maybe CFs
>>> in general..
>>> Suppose you have two independent (A & B) database nodes share a
>>> database volume on a CF.
>>> Is it possible to have the CF queue (FIFO) requests (read / write)
>>> from either node in order to let them be executed in that order?
>>> Rgds
>>> /PL
>> Please define your terms.
>>
>> 1. What version of Oracle?
>> 2. Are you discussing RAC? If not what are you discussing?
>> 3. If RAC have you read the concepts and architecture docs?
>>     Which ones?

>
> Thanks for your reply.
>
> 10g, two stand alone DBs (not RAC) + proprietary cluster.
>

>> If you want serialization what you are saying is that if node 1
>> starts something that will take 15 minutes you want node 2 to
>> freeze. Does this make sense?

>
> Well, that's a good to begin with but if that's the starting point we
> would like to add nifty features such as.
> i) If a write process has been active for more than x seconds, pass
> through all read processes in the queue.
> And with even more intelligence added: ii) Write's could be passed
> through as well as long as they don't interfere with each other.
>
>
> Rgds
>
> /PL

Two separate 10g instances hitting the same database files without the benefit of Oracle clusterware? Have you considered just dropping a brick on your foot. Why? My expectation is that you are trying to earn pain and will likely get a boatload of it.

Why not just build a 2 node RAC cluster with Standard Edition and get all of the benefits of the architecture plus stability and maintainability and support?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Nov 05 2007 - 20:53:02 CST