Oracle 11GR2 RAC 在RHEL5.8 主机重启后数据库不能随集群件自启动

1.查看数据库的自启动方式是自动的

 

$srvctl config database -d orcl

Database unique name: orcl
Database name: orcl
Oracle home: /app/database/product/11.2.0/db
Oracle user: oracle
Spfile: +DATAVG/orcl/spfileorcl.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2
Disk Groups: DATAVG
Services: 
Database is administrator managed
 

重新设置开启自启动也报错:

 

$srvctl enable database -d orcl
PRCC-1010 : orcl was already enabled

开启单个实例的自启动

$srvctl enable instance -d orcl -i orcl1
$srvctl enable instance -d orcl -i orcl2

 

重启之后仍然不能自启动。

 

2.查看数据库资源的相关属性

查看属性发现AUTO_START=restore,将这个属性更改为always。

#crs_stat -p 

NAME=ora.orcl.db
TYPE=ora.database.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AUTO_START=restore
CHECK_INTERVAL=1
DESCRIPTION=Oracle Database resource
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_USR_ORA_INST_NAME@SERVERNAME(11grac1)=orcl1
GEN_USR_ORA_INST_NAME@SERVERNAME(11grac2)=orcl2
HOSTING_MEMBERS=
PLACEMENT=restricted
RESTART_ATTEMPTS=2
SCRIPT_TIMEOUT=60
START_TIMEOUT=600
STOP_TIMEOUT=600
UPTIME_THRESHOLD=1h
USR_ORA_INST_NAME@SERVERNAME(11grac1)=orcl1
USR_ORA_INST_NAME@SERVERNAME(11grac2)=orcl2

注意这个命令:

$crsctl modify resource ora.orcl.db -attr AUTO_START=always

 

3.重新启动主机

$crsctl stat res -t 

ora.orcl.db
      1        ONLINE  ONLINE       11grac1                  Open                
      2        ONLINE  ONLINE       11grac2                  Open  

经过更改确实能够重启了。 

©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页