重启集群数据库oracle,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

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