DBA/ASE interaction/interference in cluster environment

From: <JBeck_at_CareWiseInc.com>
Date: Thu, 15 Nov 2001 09:20:28 -0800

We're migrating from 8200s running 4.0f,pk6, ASE, oracle 8.0.6, "manual"
failover of the databases, to ES40s running 5.1,pk3,ase, oracle 8.1.7,
with "automatic" failover of the databases. We currently only have
one database configured in the "automatic" failover mode and the
database and listener can be moved back and forth between nodes and
shutdown using the CAA tools without any problem (if you're the unix
admin). Our DBA wanted to do some maintenance tasks the other day
so she went into Oracle's "svrmgrl" and shutdown the database. The
problem is that ASE detected the database was down and promptly
brought it up on the other system. Are there any easy ways to keep
the DBA and ASE from interfering with each other? From my initial
look at this, it seems we can either give the DBA access to the
CAA tools (less than ideal from the DBA's point of view), or we
have to give up the "automatic" failover. Has anyone else come
up with a solution to this?

Jeff Beck
jbeck_at_carewiseinc.com
206.749.1878

CareWise Inc.
1501 4th Ave.
Suite 800
Seattle, WA 98101-1629
Received on Thu Nov 15 2001 - 17:22:45 NZDT

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:42 NZDT