Oracle 11G RAC OS開啟後叢集元件開啟但DB依然是關閉
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11G R2 RAC 關閉叢集自啟資料庫Oracle資料庫
- Oracle 11g關閉開啟AWROracle
- Oracle10g RAC開啟關閉過程Oracle
- Oracle 11gR2 RAC叢集服務啟動與關閉總結Oracle
- Oracle 11gR2 RAC 叢集服務啟動與關閉總結Oracle
- Oracle10g RAC OS系統啟動時自動開啟的一些RAC元件Oracle元件
- RAC常用開啟關閉命令 – SRVCTL用法
- Oracle:RAC關閉、啟動、重啟步驟:10g、11gOracle
- oracle 開啟、關閉歸檔Oracle
- Oracle RAC 啟動與關閉Oracle
- Oracle10g RAC開啟關閉時候究竟在關閉什麼Oracle
- 11g rac ASM下最簡單歸檔開啟/關閉方法ASM
- 【RAC】使用crsctl工具控制Oracle RAC叢集的啟停Oracle
- RAC常用開啟關閉命令 - CRSCTL和SRVCTL 用法
- 關閉開啟GFS檔案系統的Oracle10g RACOracle
- oracle 歸檔日誌開啟,關閉Oracle
- 批處理開啟和關閉OracleOracle
- 開啟與關閉oracle的歸檔Oracle
- 關於關閉開啟Oracle10g RAC系統步驟疑問Oracle
- MySQL 叢集的安全關閉和重啟方法MySql
- 記一次oracle 19c RAC叢集重啟單節點DB啟動異常(二)Oracle
- Oracle 11g RAC的啟動、關閉及修改歸檔總結Oracle
- Mongodb開啟與關閉MongoDB
- Oracle10g RAC (ASM) 資料庫及服務開啟關閉OracleASM資料庫
- 關閉開啟Oracle10g RAC(OCFS2)系統步驟Oracle
- linux 中oracle 10g rac 關閉crs開機自啟動LinuxOracle 10g
- Oracle11g RAC (ASM) 及Active Dataguard開啟與關閉 [final]OracleASM
- Oracle10g RAC (OCFS) 開啟關閉及日常檢查(總結)Oracle
- ORACLE 歸檔日誌開啟關閉方法Oracle
- Oracle回收站功能開啟與關閉Oracle
- Oracle 10g RAC 啟動與關閉Oracle 10g
- ORACLE RAC 的啟動和關閉順序Oracle
- Oracle10g RAC 關閉及啟動Oracle
- ORACLE RAC開啟防火牆Oracle防火牆
- 關於Oracle10g RAC 的開啟關閉標準步驟問題Oracle
- nginx 開啟、關閉、重啟常用操作Nginx
- oracle 11g rac 叢集操作命令Oracle
- oracle 11g 開啟 em後,High CPU after DB Console start in 11gOracle