sorry for loosing track of this thread. What
I wanted to address was the comment that CRS
will fail over the listener. Since we are not
talking about RAC, there will be no CRS. And
even if CRS was de-coupled from RAC, it is
not an HA framework (monitors/probes,start,stop,
failover scripts/executables, etc) as is
software like Steeleye and PolyServe Matrix Server,
VCS, etc.

Yes, of course with a SAN you can write your own
scripts to monitor the database and manually
push filesystems over to the server and go with it, but
without a cluster-global HA policy engine, such
scripts are usually not effective. Therein lies
the market for the types of products I've mentioned
in the previous paragraph. And within those, there
are feature differentiators as well...

Kevin Closson
Chief Architect, Database Solutions
PolyServe, Inc
kevinc@(protected)
and www.oaktable.net



>-----Original Message-----
>From: Keith Pettit [mailto:Keith_Pettit@(protected)]
>Sent: Wednesday, August 11, 2004 12:51 PM
>To: Kevin Closson
>Cc: Peter Mooshammer; SuSE - Oracle
>Subject: RE: [suse-oracle] Oracle 10g failover suggestion?
>
>
>Thanks all for the replies, I've answered the responses below.
>
>On Wed, 2004-08-11 at 13:39, Kevin Closson wrote:
>> I am still presuming non-rac. Failing over
>> the listeber will not help if the database is on
>> a node that crashes
>
>Why is that? So from what your telling me, if my oracle1
>server craps out, I can't mount the database that's store on
>the SAN from my oracle2 machine and have it work?
>
>If that dosen't work, what other options do I have?
>>
>>
>> -----Original Message-----
>> From: Peter Mooshammer [mailto:Peter.Mooshammer@(protected)]
>> Sent: Wednesday, August 11, 2004 11:33 AM
>> To: Kevin Closson
>> Cc: Keith Pettit; SuSE - Oracle
>> Subject: Re: [suse-oracle] Oracle 10g failover suggestion?
>>
>>
>> Hello
>>
>> Kevin Closson wrote:
>>
>> >Note1. Stanadard Edition RAC in Oracle10g is limited to
>> >a total of four CPUs clusterwide. It is cheap, but limited in that
>> >respect and remember that Standard Edition does not include
>Parallel
>> >Query Option. You'll not any single query to use more than 1 CPU
>> >bandwidth that way.
>> >
>> >
>>
>> Since they bought only 2 licences and are on a budget they are fine.
>>
>> >Note2. CRS is Oracle node-membership software. It is what skgxn()
>> >routines use to detemin "who" is in the cluster. It is
>scritctly, and
>> >only, a replacement for OCMS.
>> >
>> >
>
>I'm checking on the specifics of our license, but from what
>I've been told we have 2 Oracle 10G 2CPU licenses, but we do
>not have RAC.
>
>> >
>>
>>
>> >Note3. For failover (HA), you need HA clusterware to do service
>> >monitoring and Failover/restart. such software in the legacy Unix
>> >world would be Sun clusters, VCS, HACMP, Service Guard. On
>> Linux, there
>> >is PolyServe Matrix Server with the MxDB-Oracle-HiAv Soluition Pack,
>> >Steeleye. The former has a cache coherent general purpose
>directIO CFS
>> >with async IO and Oracle Disk Manager. The latter is a very
>stripped
>> >down kit.
>> >
>> >
>> >
>> >
>> What else do you need on LINUX, if you don't want to go all the way?
>>
>> CRS will failover the listener ..
>
>I'm still checking the exact specifics of our license, but
>from what i've been told we do not have RAC, and I'm assuming
>that means we also do not have CRS. If that's the case is
>there any GPL/OpenSource that will do the clusterware type stuff?
>
>
>>
>> Peter
>>
>>
>>
>> >-----Original Message-----
>> >From: Peter Mooshammer [mailto:Peter.Mooshammer@(protected)]
>> >Sent: Wednesday, August 11, 2004 11:05 AM
>> >To: Keith Pettit
>> >Cc: SuSE - Oracle
>> >Subject: Re: [suse-oracle] Oracle 10g failover suggestion?
>> >
>> >
>> >Hello,
>> >
>> >check your licence agreement RAC is part of the standard
>edition with
>> >10g.
>> >
>> >
>> >And your cluster manager is CRS
>> >
>> >
>> >Peter
>> >
>> >Keith Pettit wrote:
>> >
>> >
>> >
>> >>I'm new to Oracle. We just got Oracle 10g and are running it on
>> >>SuSE Enterprise 9.
>> >>
>> >>I have two machines connected to a SAN, currently I don't have any
>> >>cluster software, so if I mount a LUN on both servers at the
>> same time
>> >>I will have corruption issues. We didn't have enough money to by
>> >>the
>> >>"RACK" version of Oracle, but we have 2 licenses of Oracle so
>> >>  
>> >>
>> >I can run
>> >
>> >
>> >>a version on each server.
>> >>
>> >>What is the best way to do failover? Ideally I want my
>> >>  
>> >>
>> >oracle2 machine
>> >
>> >
>> >>to take over for my oracle1 machine in the event of a failure. I
>> >>want it to take control of the database that will be
>stored on the SAN.
>> >>What is the best way to go about this?
>> >>
>> >>Thanks for any suggestions,
>> >>
>> >>Keith
>> >>
>> >>
>> >>
>> >>
>> >>  
>> >>
>> >
>> >
>> >
>> >
>>
>

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting