查看资源配置:

[oracle@ocm1 public]$ crs_stat -p ora.prodb.prodb1.inst
NAME=ora.prodb.prodb1.inst TYPE=application ACTION_SCRIPT=/u01/app/oracle/product/10.2.0/db_1/bin/racgwrap ACTIVE_PLACEMENT=0 AUTO_START=1 CHECK_INTERVAL=600 DESCRIPTION=CRS application for Instance FAILOVER_DELAY=0 FAILURE_INTERVAL=0 FAILURE_THRESHOLD=0 HOSTING_MEMBERS=ocm1 OPTIONAL_RESOURCES= PLACEMENT=restricted REQUIRED_RESOURCES=ora.ocm1.ASM1.asm RESTART_ATTEMPTS=5 SCRIPT_TIMEOUT=600 START_TIMEOUT=0 STOP_TIMEOUT=0 UPTIME_THRESHOLD=7d USR_ORA_ALERT_NAME= USR_ORA_CHECK_TIMEOUT=0 USR_ORA_CONNECT_STR=/ as sysdba USR_ORA_DEBUG=0 USR_ORA_DISCONNECT=false USR_ORA_FLAGS= USR_ORA_IF= USR_ORA_INST_NOT_SHUTDOWN= USR_ORA_LANG= USR_ORA_NETMASK= USR_ORA_OPEN_MODE= USR_ORA_OPI=false USR_ORA_PFILE= USR_ORA_PRECONNECT=none USR_ORA_SRV= USR_ORA_START_TIMEOUT=0 USR_ORA_STOP_MODE=immediate USR_ORA_STOP_TIMEOUT=0 USR_ORA_VIP=

其中,AUTO_START=1表示自动启动,如果不为1,则使用以下命令修改:

[oracle@ocm1 public]$ crs_register ora.prodb.prodb1.inst -update -o as=1 [oracle@ocm1 public]$ crs_register ora.prodb.prodb1.inst -update -o as=always

还有一种情况会导致默认启动失败,REQUIRED_RESOURCES为空:

REQUIRED_RESOURCES=

使用以下命令修正:

srvctl modify instance -d <database name> -i <instance name> -s <ASM instance name>

示例:

srvctl modify instance -d prodb -i prodb1 -s +ASM3