Oracle-L: Re: clustering

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 31 Jul 2003 06:54:33 -0800
Message-ID: <F001.005C7FBE.20030731065433@fatcity.com>

Ah. I never went to 9.0.1 I went from 8.1.5 OPS to 9.2.0.2 RAC, using Export-Import
and migrating to LMT, AutoAllocate, ASSM etc.

Hemant
At 05:24 AM 31-07-03 -0800, you wrote:

Hi!

I found out that these hanging problems were version 9.0.1's problems. I wasn't directly involved with this setup. But in 9.2 they say these problems are fixed. (One instance hits ORA-600 with parameter 4519 and all instances would hang until restarted all instances).
This was on 3-node tru64.

Tanel.

----- Original Message -----
From: Hemant K Chitale
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, July 29, 2003 6:19 PM
Subject: Re: clustering

Tanel,

I think that you've had some unfortunate experiences with RAC. Mind elucdating them ?
I don't see nodes hanging when one node dies [I'm running a 2-node Tru64 RAC Cluster]

Hemant

At 03:04 PM 28-07-03 -0800, you wrote:

However, failed transactions must be handled from client side. Queries may migrate to surviving nodes transparently.
Also, currently RAC has many problems, such all nodes hanging when one node dies. Completely separate systems are still (an will always be) the most available solution.

Tanel.

----- Original Message -----
From: Indy Johal
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 28, 2003 7:49 PM
Subject: Re: clustering

Another Important different is that RAC is best High Availability solution in case of System/Instance Failure where in case of HP or Veritas Cluster, all of the resource get stopped on live system/node of the cluster and then get started on second node and hence user will be affected. But in case of system or Instance failure, there is seamless transition of the User session in RAC

Indy Johal

"Ron Rogers" <RROGERS@galottery.org>
Sent by: ml-errors@fatcity.com

07/28/03 12:29 PM
Please respond to ORACLE-L

        To:        Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
        cc:
        Subject:        Re: clustering

ak,
As I understand it, an HP cluster is 2 boxes that have the capability
to access the same disks and data but only one can have the oracle
instance running and accessing the datafiles(active). Sort of like a
high availability option.
With RAC both boxes can access the instance and datafiles at the same
time.
List, Correct me if I need it.
Ron

>>> oramagic@hotmail.com 07/28/03 12:14PM >>>
Hi Guys ,
I am new to this clustering concept. Just trying to understand few
basics . Need ur help .

what is differece between oracle running on sun /hp cluster with 2
nodes and oracle with RAC running on 2 nodes ?

thanks,
-ak
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: RROGERS@galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: hkchital@singnet.com.sg Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).