hmaster和datanaode启动后很快停止_Oracle RAC自启动

一：CRS自启动

二：实例自启动

一：CRS自启动

默认情况下，crs是随着系统启动自动启动的。

查看版本

[root@rac01 bin]# ./crsctl query crs softwareversionOracle Clusterware version on node [rac01] is [11.2.0.4.0]

启动自启动(默认)

[root@rac01 bin]# ./crsctl enable crsCRS-4622: Oracle High Availability Services autostart is enabled.

查看

[root@rac01 bin]# cat /etc/oracle/scls_scr/rac01/root/ohasdstr enable

禁用自启动

[root@rac01 ./crsctl disable crsCRS-4621: Oracle High Availability Services autostart is disabled.

查看

[root@rac01 bin]# cat /etc/oracle/scls_scr/rac01/root/ohasdstr disable

二：实例自启动 

默认情况下,AUTO_START值为restore。

2.1 AUTO_START=restore

其中restore表示还原、恢复的含义，即将实例状态恢复到crs停止前的状态。

(1)如果crs停止前，手动通过sqlplus或srvctl停止了实例，那么在crs重启后，实例不会跟着自动启动。(2)如果crs停止前，实例处于open状态，那么重启crs(或操作系统重启)，实例会跟着crs启动而启动。注意：在没有停止实例前直接停止crs,实例是以abort方式停止的[Shutting down instance (abort)]

2.2 AUTO_START=always

将AUTO_START由restore改成always后，无论crs停止前实例是open还是close状态，实例都会跟着crs启动而启动。

2.1 AUTO_START=restore

测试AUTO_START=restore下，实例启动情况。

查看数据库信息

[root@rac01 bin]# ./crsctl start crs[root@rac01 bin]# ./srvctl config databasecjcdb[root@rac01 bin]# ./srvctl status database -d cjcdbInstance cjcdb1 is running on node rac01Instance cjcdb2 is running on node rac02

默认AUTO_START=restore 

[root@rac01 bin]# ./crsctl stat res ora.cjcdb.db -p|grep AUTO_STARTAUTO_START=restore

测试：启动crs，实例没有自动启动(srvctl停库)

[root@rac01 bin]# ./crsctl stat res ora.cjcdb.db -p|grep AUTO_STARTAUTO_START=restore[root@rac02 bin]# ./crsctl stat res ora.cjcdb.db -p|grep AUTO_STARTAUTO_START=restore手动停止实例[root@rac01 bin]# ./srvctl stop database -d cjcdb###[root@rac01 bin]# ./srvctl stop instance -d cjcdb -i cjcdb1[root@rac01 bin]# ./crsctl stop crs[root@rac02 bin]# ./crsctl stop crs[root@rac01 bin]# ./crsctl start crs[root@rac02 bin]# ./crsctl start crs

查看实例状态

[root@rac01 bin]# ./crsctl stat res ora.cjcdb.db -t--------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.cjcdb.db      1        OFFLINE OFFLINE                               Instance Shutdown         2        OFFLINE OFFLINE                               Instance Shutdown  

测试：启动crs,实例没有自动启动(SQLPLUS停库)

停止实例

SQL> shutdown immediate[root@rac01 bin]# ./crsctl stop crsSQL> shutdown immediate[root@rac02 bin]# ./crsctl stop crs

重启crs

[root@rac01 bin]# ./crsctl start crs[root@rac02 bin]# ./crsctl start crs

查看实例状态

[root@rac01 bin]# ./srvctl status database -d cjcdbInstance cjcdb1 is not running on node rac01Instance cjcdb2 is not running on node rac02

测试：启动crs，实例自动启动(srvctl)

启动实例

[root@rac01 bin]# ./srvctl start database -d cjcdb[root@rac01 bin]# ./srvctl status database -d cjcdbInstance cjcdb1 is running on node rac01Instance cjcdb2 is running on node rac02

重启crs

[root@rac01 bin]# ./crsctl stop crs[root@rac01 bin]# ./crsctl start crs[root@rac02 bin]# ./crsctl stop crs[root@rac02 bin]# ./crsctl start crs

查看实例状态

[root@rac01 bin]# ./crsctl stat res ora.cjcdb.db -t--------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.cjcdb.db      1        ONLINE  ONLINE       rac01                    Open                      2        ONLINE  ONLINE       rac02                    Open 

 查看实例状态

[root@rac01 bin]# ./srvctl status database -d cjcdbInstance cjcdb1 is running on node rac01Instance cjcdb2 is running on node rac02

启动crs，实例自动启动(sqlplus)

###节点1###SQL> startup###节点2###SQL> startup

重启crs

[root@rac01 bin]# ./crsctl stop crs[root@rac01 bin]# ./crsctl start crs[root@rac02 bin]# ./crsctl stop crs[root@rac02 bin]# ./crsctl start crs

查看实例状态

[root@rac01 bin]# ./srvctl status database -d cjcdbInstance cjcdb1 is running on node rac01Instance cjcdb2 is running on node rac02

2.2 AUTO_START=always

实例自启动 

[root@rac01 bin]# ./crsctl stat res ora.cjcdb.db -p|grep AUTO_STARTAUTO_START=restore

实例1修改AUTO_START=always

[root@rac01 bin]# ./crsctl modify resource ora.cjcdb.db -attr "AUTO_START=always"[root@rac01 bin]# ./crsctl stat res ora.cjcdb.db -p|grep AUTO_STARTAUTO_START=always

查看实例状态

[root@rac01 bin]# ./srvctl status database -d cjcdbInstance cjcdb1 is not running on node rac01Instance cjcdb2 is not running on node rac02

重启crs

[root@rac01 bin]# ./crsctl stop crs[root@rac01 bin]# ./crsctl start crs

查看实例状态

[root@rac01 bin]# ./srvctl status instance -d cjcdb -i cjcdb1,cjcdb2 -f -vInstance cjcdb1 is running on node rac01. Instance status: Open.Instance cjcdb2 is not running on node rac02[root@rac01 bin]# ./srvctl status database -d cjcdbInstance cjcdb1 is running on node rac01Instance cjcdb2 is not running on node rac02

参考：

SRVCTL : Disabled DB Instance Status Changed to Online when ASM Restarted (Doc ID 2299664.1)Instance Does not Start After 11gR2 Grid Infrastructure Restart or Node Reboot (Doc ID 1149003.1)

更多数据库相关学习资料，可以查看我的ITPUB博客，网名chenoracle：

http://blog.itpub.net/29785807/