oracle 11g R2 RAC检查
1.检查集群栈的信息
[root@orclrac2 ~]# crsctl check cluster -all
**************************************************************
orclrac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
orclrac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
2.检查rac下实例的状态
[grid@orclrac2 ~]$ srvctl status database -d orcl
实例 orcl1 正在节点 orclrac1 上运行
实例 orcl2 正在节点 orclrac2 上运行
3.检查rac下某个实例状态
[grid@orclrac2 ~]$ srvctl status instance -d orcl -i orcl1
实例 orcl1 正在节点 orclrac1 上运行
[grid@orclrac2 ~]$ srvctl status instance -d orcl -i orcl2
实例 orcl2 正在节点 orclrac2 上运行
[grid@orclrac2 ~]$
4.检查rac各个节点应用程序状态(vip,network,gsd,ons,eons)
[grid@orclrac2 ~]$ srvctl status nodeapps
VIP orclrac1-vip 已启用
VIP orclrac1-vip 正在节点上运行: orclrac1
VIP orclrac2-vip 已启用
VIP orclrac2-vip 正在节点上运行: orclrac2
网络已启用
网络正在节点上运行: orclrac1
网络正在节点上运行: orclrac2
GSD 已禁用
GSD 没有运行的节点: orclrac1
GSD 没有运行的节点: orclrac2
ONS 已启用
ONS 守护程序正在节点上运行:orclrac1
ONS 守护程序正在节点上运行:orclrac2
[grid@orclrac2 ~]$
5.检查rac下的数据库配置
[grid@orclrac2 ~]$ srvctl config database -d orcl -a
数据库唯一名称: orcl
数据库名: orcl
Oracle 主目录: /oracle/oracle/app/oracle/product/11.2.0/dbhome_1
Oracle 用户: oracle
Spfile: +DATADG/orcl/spfileorcl.ora
域:
启动选项: open
停止选项: immediate
数据库角色: PRIMARY
管理策略: AUTOMATIC
服务器池: orcl
数据库实例: orcl1,orcl2
磁盘组: DATADG,SYSTEMDG
装载点路径:
服务:
类型: RAC
数据库已启用
数据库是管理员管理的
6.检查rac下的ASM状态以及ASM配置
[grid@orclrac2 ~]$ srvctl config asm -a
ASM 主目录: /oracle/grid/11ggrid/app/11.2.0/grid
ASM 监听程序: LISTENER
ASM 已启用。
7.检查rac下的TNS监听器状态以及配置
[grid@orclrac2 ~]$ srvctl status listener
监听程序 LISTENER 已启用
监听程序 LISTENER 正在节点上运行: orclrac2,orclrac1
8.检查rac下的SCAN状态以及配置
[grid@orclrac2 ~]$ srvctl status scan
SCAN VIP scan1 已启用
SCAN VIP scan1 正在节点 orclrac2 上运行
scan ip地址的实际分布
[grid@orclrac2 ~]$ srvctl config scan
SCAN 名称: orclrac-cluster-scan, 网络: 1/172.19.0.0/255.255.255.0/eth0
SCAN VIP 名称: scan1, IP: /orclrac-cluster-scan/172.19.0.107
[grid@orclrac2 ~]$
9.检查rac下的VIP各个节点的状态以及配置
[grid@orclrac2 ~]$ srvctl status vip -n orclrac1
VIP orclrac1-vip 已启用
VIP orclrac1-vip 正在节点上运行: orclrac1
[grid@orclrac2 ~]$ srvctl status vip -n orclrac2
VIP orclrac2-vip 已启用
VIP orclrac2-vip 正在节点上运行: orclrac2
10.检查rac下各个节点应用程序配置情况 (VIP、GSD、ONS、监听器)
[grid@orclrac2 ~]$ srvctl config nodeapps -a -g -s
网络存在: 1/172.19.0.0/255.255.255.0/eth0, 类型 static
VIP 存在: /orclrac1-vip/172.19.0.105/172.19.0.0/255.255.255.0/eth0, 托管节点 orclrac1
VIP 存在: /orclrac2-vip/172.19.0.106/172.19.0.0/255.255.255.0/eth0, 托管节点 orclrac2
GSD 已存在
ONS 存在: 本地端口 6100, 远程端口 6200, EM 端口 2016
[grid@orclrac2 ~]$
11.检查rac下的各个节点间的时钟同步情况
[grid@rac1 ~]$ cluvfy comp clocksync -verbose
12.集群资源
[grid@orclrac2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
ora.LISTENER.lsnr
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
ora.SYSTEMDG.dg
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
ora.asm
ONLINE ONLINE orclrac1 Started
ONLINE ONLINE orclrac2 Started
ora.gsd
OFFLINE OFFLINE orclrac1
OFFLINE OFFLINE orclrac2
ora.net1.network
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
ora.ons
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE orclrac2
ora.cvu
1 ONLINE ONLINE orclrac2
ora.oc4j
1 ONLINE ONLINE orclrac2
ora.orcl.db
1 ONLINE ONLINE orclrac1 Open
2 ONLINE ONLINE orclrac2 Open
ora.orclrac1.vip
1 ONLINE ONLINE orclrac1
ora.orclrac2.vip
1 ONLINE ONLINE orclrac2
ora.scan1.vip
1 ONLINE ONLINE orclrac2
后台资源也列出来
[grid@orclrac2 ~]$ crsctl status res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE orclrac2 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE orclrac2
ora.crf
1 ONLINE ONLINE orclrac2
ora.crsd
1 ONLINE ONLINE orclrac2
ora.cssd
1 ONLINE ONLINE orclrac2
ora.cssdmonitor
1 ONLINE ONLINE orclrac2
ora.ctssd
1 ONLINE ONLINE orclrac2 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE orclrac2
ora.gipcd
1 ONLINE ONLINE orclrac2
ora.gpnpd
1 ONLINE ONLINE orclrac2
ora.mdnsd
1 ONLINE ONLINE orclrac2
13.集群名字
[grid@orclrac2 ~]$ cemutlo -n
orclrac-cluster
[grid@orclrac2 ~]$
1.检查集群栈的信息
[root@orclrac2 ~]# crsctl check cluster -all
**************************************************************
orclrac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
orclrac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
2.检查rac下实例的状态
[grid@orclrac2 ~]$ srvctl status database -d orcl
实例 orcl1 正在节点 orclrac1 上运行
实例 orcl2 正在节点 orclrac2 上运行
3.检查rac下某个实例状态
[grid@orclrac2 ~]$ srvctl status instance -d orcl -i orcl1
实例 orcl1 正在节点 orclrac1 上运行
[grid@orclrac2 ~]$ srvctl status instance -d orcl -i orcl2
实例 orcl2 正在节点 orclrac2 上运行
[grid@orclrac2 ~]$
4.检查rac各个节点应用程序状态(vip,network,gsd,ons,eons)
[grid@orclrac2 ~]$ srvctl status nodeapps
VIP orclrac1-vip 已启用
VIP orclrac1-vip 正在节点上运行: orclrac1
VIP orclrac2-vip 已启用
VIP orclrac2-vip 正在节点上运行: orclrac2
网络已启用
网络正在节点上运行: orclrac1
网络正在节点上运行: orclrac2
GSD 已禁用
GSD 没有运行的节点: orclrac1
GSD 没有运行的节点: orclrac2
ONS 已启用
ONS 守护程序正在节点上运行:orclrac1
ONS 守护程序正在节点上运行:orclrac2
[grid@orclrac2 ~]$
5.检查rac下的数据库配置
[grid@orclrac2 ~]$ srvctl config database -d orcl -a
数据库唯一名称: orcl
数据库名: orcl
Oracle 主目录: /oracle/oracle/app/oracle/product/11.2.0/dbhome_1
Oracle 用户: oracle
Spfile: +DATADG/orcl/spfileorcl.ora
域:
启动选项: open
停止选项: immediate
数据库角色: PRIMARY
管理策略: AUTOMATIC
服务器池: orcl
数据库实例: orcl1,orcl2
磁盘组: DATADG,SYSTEMDG
装载点路径:
服务:
类型: RAC
数据库已启用
数据库是管理员管理的
6.检查rac下的ASM状态以及ASM配置
[grid@orclrac2 ~]$ srvctl config asm -a
ASM 主目录: /oracle/grid/11ggrid/app/11.2.0/grid
ASM 监听程序: LISTENER
ASM 已启用。
7.检查rac下的TNS监听器状态以及配置
[grid@orclrac2 ~]$ srvctl status listener
监听程序 LISTENER 已启用
监听程序 LISTENER 正在节点上运行: orclrac2,orclrac1
8.检查rac下的SCAN状态以及配置
[grid@orclrac2 ~]$ srvctl status scan
SCAN VIP scan1 已启用
SCAN VIP scan1 正在节点 orclrac2 上运行
scan ip地址的实际分布
[grid@orclrac2 ~]$ srvctl config scan
SCAN 名称: orclrac-cluster-scan, 网络: 1/172.19.0.0/255.255.255.0/eth0
SCAN VIP 名称: scan1, IP: /orclrac-cluster-scan/172.19.0.107
[grid@orclrac2 ~]$
9.检查rac下的VIP各个节点的状态以及配置
[grid@orclrac2 ~]$ srvctl status vip -n orclrac1
VIP orclrac1-vip 已启用
VIP orclrac1-vip 正在节点上运行: orclrac1
[grid@orclrac2 ~]$ srvctl status vip -n orclrac2
VIP orclrac2-vip 已启用
VIP orclrac2-vip 正在节点上运行: orclrac2
10.检查rac下各个节点应用程序配置情况 (VIP、GSD、ONS、监听器)
[grid@orclrac2 ~]$ srvctl config nodeapps -a -g -s
网络存在: 1/172.19.0.0/255.255.255.0/eth0, 类型 static
VIP 存在: /orclrac1-vip/172.19.0.105/172.19.0.0/255.255.255.0/eth0, 托管节点 orclrac1
VIP 存在: /orclrac2-vip/172.19.0.106/172.19.0.0/255.255.255.0/eth0, 托管节点 orclrac2
GSD 已存在
ONS 存在: 本地端口 6100, 远程端口 6200, EM 端口 2016
[grid@orclrac2 ~]$
11.检查rac下的各个节点间的时钟同步情况
[grid@rac1 ~]$ cluvfy comp clocksync -verbose
12.集群资源
[grid@orclrac2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
ora.LISTENER.lsnr
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
ora.SYSTEMDG.dg
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
ora.asm
ONLINE ONLINE orclrac1 Started
ONLINE ONLINE orclrac2 Started
ora.gsd
OFFLINE OFFLINE orclrac1
OFFLINE OFFLINE orclrac2
ora.net1.network
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
ora.ons
ONLINE ONLINE orclrac1
ONLINE ONLINE orclrac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE orclrac2
ora.cvu
1 ONLINE ONLINE orclrac2
ora.oc4j
1 ONLINE ONLINE orclrac2
ora.orcl.db
1 ONLINE ONLINE orclrac1 Open
2 ONLINE ONLINE orclrac2 Open
ora.orclrac1.vip
1 ONLINE ONLINE orclrac1
ora.orclrac2.vip
1 ONLINE ONLINE orclrac2
ora.scan1.vip
1 ONLINE ONLINE orclrac2
后台资源也列出来
[grid@orclrac2 ~]$ crsctl status res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE orclrac2 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE orclrac2
ora.crf
1 ONLINE ONLINE orclrac2
ora.crsd
1 ONLINE ONLINE orclrac2
ora.cssd
1 ONLINE ONLINE orclrac2
ora.cssdmonitor
1 ONLINE ONLINE orclrac2
ora.ctssd
1 ONLINE ONLINE orclrac2 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE orclrac2
ora.gipcd
1 ONLINE ONLINE orclrac2
ora.gpnpd
1 ONLINE ONLINE orclrac2
ora.mdnsd
1 ONLINE ONLINE orclrac2
13.集群名字
[grid@orclrac2 ~]$ cemutlo -n
orclrac-cluster
[grid@orclrac2 ~]$