Re: Who is using clusterware 11.2 with 10.2 databases in failover mode ?

From: Robert Bialek <bialekr_at_gmail.com>
Date: Wed, 26 Jan 2011 12:40:22 +0100
Message-ID: <4D400826.8000908_at_gmail.com>

Hi Stefano,

> does anyone have already implemented a normal failover cluster with 2
> or n-nodes using clusterware 11.2 and databases running 10gR2 ?
> How have you integrated database in the cluster?

you cannot integrate pre 11.2 single instance databases as failover resources with srvctl.
With 11.2 it works, though not documented.

For pre 11.2 rdbms versions provide an action script able to start/stop/monitor and clean(optional)
the resource, e.g.:

crsctl add resource ${ResName}.inst -type cluster_resource \ -attr "ACTION_SCRIPT=/u00/app/oracle/local/dba/bin/crs_db.ksh,\ CARDINALITY=1,\
DEGREE=1,\
PLACEMENT=balanced,\
CHECK_INTERVAL=15,\

RESTART_ATTEMPTS=2,\
FAILURE_THRESHOLD=2,\
FAILURE_INTERVAL=3600,\

UPTIME_THRESHOLD=8h,\
DESCRIPTION=Oracle database instance resource,\ START_DEPENDENCIES='hard(ora.U01.dg,${ResName}.lsnr) pullup(ora.U01.dg,${ResName}.lsrn)',\
STOP_DEPENDENCIES='hard(intermediate:ora.asm,shutdown:ora.U01.dg,${ResName}.vip)'"

The same way you need to add VIP and listener resources.

Cheers,
Robert

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 26 2011 - 05:40:22 CST