Oracle 11g RAC crs_stat 命令结果完整显示(一)

2014-11-24 17:50:58 · 作者: · 浏览: 2

1、安装crsstat
通常情况下,建议使用root用户或者oracle用户来安装到 /usr/local/bin 目录
当脚本首次运行时,会在安装目录产生一个 crsstat.env 文件,该文件用于描述crs的位置信息
安装crsstat前,应启动crs,其次对于crsstat脚本所在的安装路径应当具有写的权限


crsstat.v1.2.2.zip 源文件下载:


具体下载目录在 /2013年资料/7月/25日/Oracle 11g RAC crs_stat 命令结果完整显示


----------------------------------------------------------------------------------------


下面是安装步骤
# cd /usr/local/bin
# unzip crsstat.v1.2.1.zip
# mv crsstat.v1.2.2 crsstat
# chmod 755 crsstat
# ./crsstat

# chmod 644 crsstat.env
校验crsstat.env文件配置是否正确
# more crsstat.env
GRID_HOME=/u01/app/11.2.0/grid
GRID_VER=11.2


2、演示用法
crsstat用法比较简单,直接在提示符下执行crsstat命令即可,也可以使用crsstat -h 输出crsstat的帮助信息


a、crsstat的帮助信息
[grid@linux1 ~]$ crsstat -h

Usage: crsstat [-h] [-c] [search term]

-h => print this message
-c => output the resources by cluster or local

Examples:
crsstat # show all resources
crsstat listener # only show listener resources
crsstat database # only show database resources
crsstat -c listener # only show database resources sorted by cluster/local

Output Contains the following fields:
Resource Name
Resource Type, which includes an identifier C-Cluster and L-Local
Target State
Current State
Current Node (11gR2: or the last node in paraenthesis if the resource is Offline)
Failure Count (11gR2 only)
Restart Count (11gR2 only)
State Details (11gR2 only)



b、使用crsstat查看集群资源
#显示所有的资源
[oracle@linux1 bin]$ crsstat
Resource Name Resource Type Target State Node FC RC State Details
---------------------------------------- ---------------- ---------- ------------ --------------- -- -- ---------------
ora.ASM_DATA.dg diskgroup L ONLINE ONLINE linux1 0
ora.ASM_DATA.dg diskgroup L ONLINE ONLINE linux2 0
ora.FRA_DATA.dg diskgroup L ONLINE ONLINE linux1 0
ora.FRA_DATA.dg diskgroup L ONLINE ONLINE linux2 0
ora.LISTENER.lsnr Listener L ONLINE ONLINE linux1 0
ora.LISTENER.lsnr Listener L ONLINE ONLINE linux2 0
ora.LISTENER_SCAN1.lsnr SCAN Listener C ONLINE ONLINE linux1 0
ora.LISTENER_SCAN2.lsnr SCAN Listener C ONLINE ONLINE linux2 0
ora.OCR_VOTE.dg diskgroup L ONLINE ONLINE linux1 0
ora.OCR_VOTE.dg diskgroup L ONLINE ONLINE linux2 0
ora.asm ASM L ONLINE ONLINE linux1 0 Started
ora.asm ASM L ONLINE ONLINE linux2 0 Started
ora.eons eons L ONLINE ONLINE linux1 0
ora.eons eons L ONLINE ONLINE linux2 0
ora.gsd Gbl Svc Daemon L OFFLINE OFFLINE (linux1) 0
ora.gsd Gbl Svc Daemon L OFFLINE OFFLINE (linux2) 0
ora.linux1.vip Cluster VIP C ONLINE ONLINE linux1 0
ora.linux2.vip Cluster VIP C ONLINE ONLINE linux2 0
ora.mmbo.db database C ONLINE ONLINE linux1 0 Open
ora.mmbo.db database C ONLINE ONLINE linux2 0 Open
ora.mmbo11g.db database C ONLINE ONLINE l