oracle集群db启动不了,Oracle 11G RAC OS开启后集群组件开启但DB依然是关闭

OS開啟后其他集群件自動開啟但DB依然是關閉的：

ora.gc.db

1

OFFLINE OFFLINE                               Instance

Shutdown

2

OFFLINE OFFLINE                               Instance

Shutdown

grid01$crsctl stat res ora.gc.db -f

NAME=ora.gc.db

TYPE=ora.database.type

STATE=OFFLINE

TARGET=OFFLINE

ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:oper:r-x,user:grid:r-x

ACTION_FAILURE_TEMPLATE=

ACTION_SCRIPT=

ACTIVE_PLACEMENT=1

AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%

AUTO_START=restore

CARDINALITY=2

CARDINALITY_ID=0

CHECK_INTERVAL=1

CHECK_TIMEOUT=30

CLUSTER_DATABASE=true

CREATION_SEED=41

DATABASE_TYPE=RAC

DB_UNIQUE_NAME=gc

DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=database)

PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .))

ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE=

%DATABASE_TYPE%)

DEGREE=1

DESCRIPTION=Oracle

Database resource

ENABLED=1

FAILOVER_DELAY=0

FAILURE_INTERVAL=60

FAILURE_THRESHOLD=1

GEN_AUDIT_FILE_DEST=/u01/product/oracle/admin/gc/adump

GEN_START_OPTIONS=

GEN_START_OPTIONS@SERVERNAME(grid01)=open

GEN_START_OPTIONS@SERVERNAME(grid02)=open

GEN_USR_ORA_INST_NAME=

GEN_USR_ORA_INST_NAME@SERVERNAME(grid01)=gc1

GEN_USR_ORA_INST_NAME@SERVERNAME(grid02)=gc2

HOSTING_MEMBERS=

ID=ora.gc.db

INSTANCE_FAILOVER=0

LOAD=1

LOGGING_LEVEL=1

MANAGEMENT_POLICY=AUTOMATIC

NLS_LANG=

NOT_RESTARTING_TEMPLATE=

OFFLINE_CHECK_INTERVAL=0

ONLINE_RELOCATION_TIMEOUT=0

ORACLE_HOME=/u01/product/oracle/11.2.0/db_1

ORACLE_HOME_OLD=

PLACEMENT=restricted

PROFILE_CHANGE_TEMPLATE=

RESTART_ATTEMPTS=2

ROLE=PRIMARY

SCRIPT_TIMEOUT=60

SERVER_POOLS=ora.gc

SPFILE=+DATA/gc/spfilegc.ora

START_DEPENDENCIES=hard(ora.DATA.dg)

weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns)

pullup(ora.DATA.dg)

START_TIMEOUT=600

STATE_CHANGE_TEMPLATE=

STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg)

STOP_TIMEOUT=600

TYPE_VERSION=3.2

UPTIME_THRESHOLD=1h

USR_ORA_DB_NAME=gc

USR_ORA_DOMAIN=

USR_ORA_ENV=

USR_ORA_FLAGS=

USR_ORA_INST_NAME=

USR_ORA_INST_NAME@SERVERNAME(grid01)=gc1

USR_ORA_INST_NAME@SERVERNAME(grid02)=gc2

USR_ORA_OPEN_MODE=open

USR_ORA_OPI=false

USR_ORA_STOP_MODE=immediate

VERSION=11.2.0.4.0

AUTO_START=restore

Restore indicates whether Oracle

Clusterware should automatically start a resource after a cluster restart.

Valid AUTO_START values are:

-always—Causes the resource to restart

when the node restarts regardless of the resource's state when the node

stopped.

-restore—Does not

start the resource at restart time if it was in an offline state, such as

STATE=OFFLINE, TARGET=OFFLINE, when the node stopped. The resource is restored

to its state when the node went down. The resource is started only if it was

online before and not otherwise.

-never—Oracle Clusterware never

restarts the resource regardless of the resource's state when the node stopped.

Action Plan:

AUTO_START属性修改为 Always

grid01$crsctl modify resource ora.gc.db -attr

"AUTO_START=always"

CRS-0245:  User doesn't have enough privilege to perform

the operation

CRS-4000:

Command Modify failed, or completed with errors.

grid01$su

oracle

Password:

grid01$crsctl modify resource ora.gc.db -attr

"AUTO_START=always"