Re: RAC alternatives: do you have suggestions? (HELP!)

FM wrote:

> This RAC has to deal only with simple select and insert sql statements.
> They are in the form of:
> select column from table;
>
> the high workload is only in the number of connections and in disk I/O.
>
> However the system is a SUSE Linux Enterprise Edition 7 and the DB is a
> 9.2.0.4
> No oracle consultant was able to fix the bugs. The usual reply is "this
> is bug yyyy: please, apply the xxx patch" but recently we have
> terminated the available patches...
>
> In this moment my company is only seeking good alternatives.
> We gave up with RAC systems
>
> Fabrizio Magni
>
> fabrizio.magni_at_mycontinent.com
> replace mycontinent with europe
>
> Daniel Morgan wrote:
>

>> FM wrote:
>>
>>> Hi,
>>> after two years working with RAC (on linux) on a critical production 
>>> system the management decided to dismantle it due to too many 
>>> downtimes, bugs, crashes, hangs...
>>>
>>> Lately we experienced too much in a too short time.
>>> Now I'm looking for stable and really unbreakable HA alternatives 
>>> (active-passive clusters?).
>>>
>>> The selected platforms are:
>>>
>>> AIX + hacmp + oracle9i
>>> SOLARIS + veritas + oracle9i
>>>
>>> I'm open to alternatives but what I wish more are critics at those 
>>> two architectures. Which dangers? Have you experienced problems? 
>>> Every opinion is welcome.
>>>
>>> Thank you for any kind of help.
>>
>>
>>
>> Most of the time ... the problem isn't RAC it is the code being run on
>> it. What version of Oracle, what Linux, and what was the app?
>>
>> Thanks.

What was the point in trying RAC?

High availability?
Fail over?
Build-out rather than build-up to save money?

Without knowing the purpose a recommendation can not be made.

What versions of Linux and Oracle were you using in your attempt with RAC? Between the Solaris and AIX solutions ... I'd go with AIX. But I would be willing to bet I could make your current Linux RAC system as stable for a lot less money.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)