检查数据库实例状态:
[oracle@node2 ~]$ srvctl status database -d oradb
Instance oradb1 is running on node node1
Instance oradb2 is running on node node2
查看单个数据库实例状态:
[oracle@node1 /]$ srvctl status instance -d oradb -i oradb1
Instance oradb1 is running on node node1
--------------------------------------------------------------
检查CRS:
[oracle@node1 ~]$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
[oracle@node2 ~]$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
-----------------------------------------------------------------
RAC数据库关闭顺序:
[oracle@node2 ~]$ emctl stop dbconsole //每个节点停止dbconsole
[oracle@node2 ~]$ srvctl stop database -d oradb //关闭整个数据库所有实例,也可进行单个实例关闭,等同于shutdown normal
[oracle@node2 ~]$ srvctl stop nodeapps -n node1 //停止node1节点服务 会关闭以下服务:VIP, GSD,ONS, Listener
[oracle@node2 ~]$ srvctl stop nodeapps -n node2
[oracle@node2 ~]$ srvctl stop asm -n node2 //停止ASM实例
[oracle@node2 ~]$ srvctl stop asm -n node1
关闭集群软件(需要使用ROOT用户操作):
NODE1节点操作:
[root@node1 /]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl check crs //检查crs状态
[root@node1 /]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs //关闭该节点上的crs服务
NODE2节点操作:
[root@node2 /]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl check crs //检查crs状态,建议每次操作前都做该status命令检查
[root@node2 /]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs //关闭该节点上的crs服务
-------------------------------------------------------------------
其它相关关闭的命令:
[root@node1 /]# /etc/init.d/init.crs stop //关闭该节点上的crs服务 (所有节点都要执行)
[root@node1 ~]# /etc/init.d/init.crs disable //禁用集群就绪软件,不随系统启动.(所有节点都要执行)
Usage: /etc/init.d/init.crs {stop|start|enable|disable} //相关参数命令
[root@node1 /]# /etc/init.d/init.crs stop //关闭该节点上的crs服务
[root@node1 /]# /u01/app/oracle/product/10.2.0/crs/bin/crs_stop -all //关闭所有节点CRS服务.
[root@node1 /]# srvctl stop instance -d oradb -i oradb1 //关闭oradb1 节点数据库
[root@node1 /]# srvctl stop instance -d oradb -i oradb2
[oracle@node2 ~]$ srvctl stop database -d oradb -o immediate //关闭整个数据库,记住最好用-o immediate参数,它等同于shutdown immediate,一般做完这部操作后即可进入关闭CRS操作)
--------------------------------------------------------------------
开启RAC数据库实例顺序(注意使用crs_stat -t 查看启动状态):
[root@node1 ~]# /etc/init.d/init.crs enable //启用集群就绪软件,系统启动集群软件随启动.
[root@node1 ~]# /etc/init.d/init.crs enable
[root@node1 /]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl start crs //手动启动CRS服务
[root@node2 /]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl start crs //手动启动CRS服务
[oracle@node2 ~]$ srvctl stop asm -n node2 //开启ASM实例
[oracle@node2 ~]$ srvctl stop asm -n node1
[oracle@node2 ~]$ srvctl start nodeapps -n node1 //启动node1节点服务,使用srvctl 可在任节点上面执行.
[oracle@node2 ~]$ srvctl start nodeapps -n node2
[oracle@node2 ~]$ srvctl start database -d oradb //开启整个数据库所有实例
--------------------------------------------------------------------
其它相关开启的命令:
[root@node1 /]# /etc/init.d/init.crs start //开启该节点上的crs服务 注:开启后查看启动是否成功.. 成功后往下操作...
[root@node2 /]# /etc/init.d/init.crs start
[root@node1 /]# /u01/app/oracle/product/10.2.0/crs/bin/crs_start -all //开启所有节点CRS服务.
[root@node1 /]# srvctl start instance -d oradb -i oradb1 //启动oradb1 节点数据库
[root@node1 /]# srvctl start instance -d oradb -i oradb2
srvctl 开启关闭监听器:
[oracle@node1 ~]$ srvctl stop listener -n node1
[oracle@node2 ~]$ srvctl start listener -n node1
[oracle@node2 ~]$ lsnrctl start
[oracle@node2 ~]$ emctl start dbconsole //每个节点开启dbconsole
------------------------------------------------------------------
Oracle10g RAC检查命令 :
Oracle10g RAC数据库的 nodeapps 有 VIP, GSD, Listener, ONS .
$ srvctl status nodeapps –n node1 (检查VIP, GSD,ONS, Listener 等(所有节点))
VIP is running on node: node1
GSD is not running on node: node1
Listener is not running on node: node1
ONS daemon is not running on node: node1
[oracle@node1 ~]$ /app/oracle/product/10.2.0/crs/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE node1
ora....B2.inst application ONLINE ONLINE node2
ora.oradb.db application ONLINE ONLINE node1
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
------------------------------------------------------------------------
[root@node2 ~]# /app/oracle/product/10.2.0/crs/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 196504
Used space (kbytes) : 1988
Available space (kbytes) : 194516
ID : 1273758996
Device/File Name : /dev/raw/raw4
Device/File integrity check succeeded
Device/File Name : /dev/raw/raw5
Device/File integrity check succeeded
Cluster registry integrity check succeeded
检查ASM 实例运行情况:
[oracle@node1 /]$ srvctl status asm -n node1
ASM instance +ASM1 is running on node node1.
[oracle@node1 /]$ srvctl status asm -n node2
ASM instance +ASM2 is running on node node2.