Oracle 11G RAC OS開啟後叢集元件開啟但DB依然是關閉

guocun09發表於2017-10-26

OS開啟後其他叢集件自動開啟但DB依然是關閉的:

ora.gc.db

      1        OFFLINE OFFLINE                               Instance Shutdown  

      2        OFFLINE OFFLINE                               Instance Shutdown  

grid01<*+ASM1*/home/grid>$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<*+ASM1*/home/grid>$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<*+ASM1*/home/grid>$su oracle

Password:

grid01<*+ASM1*/home/grid>$crsctl modify resource ora.gc.db -attr "AUTO_START=always"

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25583515/viewspace-2146402/,如需轉載,請註明出處,否則將追究法律責任。

相關文章