Question: How do I use the
crsctl modify resource command to change the attributes
to autostart ASM, Oracle and my listener in RAC systems?
Answer: The
CRSCTL commands are used to control cluster ready
services (CRS) in RAC environments. Starting in 11g, you can use the
crsctl modify resource command starting in 11g to check and
modify the AUTO_START status of a CRS resource in RAC.
The crsctl modify resource does the same thing for
the database as the
ORATAB file, but it only for RAC databases. But
you can also autostart the listener on each RAC node and
autostart ASM.
You start by checking the current restart values with
crsctl stat. You
can
use crs_stat -p
command to get the profile of any RAC resource.
crsctl stat res -p
Here you can specify to never to autostart-start a CRS resource:
crsctl modify resource resource_name -attr
"AUTO_START=never"
Here you can specify to always auto-start a CRS resource:
by specifying AUTO_START=1:
crsctl modify resource resource_name -attr "AUTO_START=1"
Here are some
examples of the crsctl modify resource command:
crsctl modify resource "ora.asm" -attr "AUTO_START=1"
crsctl modify resource "ora.oracle.db" -attr "AUTO_START=1"
crsctl modify resource "ora.listener.lsnr" -attr "AUTO_START=1"
Beware that the "crsctl
modify resource" option is only available for 11g and
beyond.
The crsctl executable is locate in the $GRID_HOME/bin
directory and is used in Oracle RAC/Grid clusters.
Note that AUTO_START must always be in capital
letters, else you get the CRS-0160 error:
crsctl modify resource ora.db -attr
"auto_start=always"
CRS-0160: The attribute
'auto_start' is not supported in this resource type.
CRS-4000: Command Modify failed, or completed with errors.
