Oracle Cluster Health Monitor(CHM)
来源:互联网 发布:2017十月经济数据公布 编辑:程序博客网 时间:2024/05/17 08:15
++查看节点1状态:
[grid@+ASM1 /home/grid]$ crsctl stat res ora.crf -init
NAME=ora.crf
TYPE=ora.crf.type
TARGET=ONLINE
STATE=ONLINE on szaa1
[grid@+ASM1 /home/grid]$
[grid@+ASM1 /home/grid]$ ps -ef|grep osysmond
grid 3131 31768 0 16:28 pts/1 00:00:00 grep osysmond
root 4499 1 2 Apr01 ? 09:18:04 /oracle/product/11.2.0/grid11g/bin/osysmond.bin
[grid@+ASM1 /home/grid]$
[grid@+ASM2 /home/grid]$ crsctl stat res ora.crf -init
NAME=ora.crf
TYPE=ora.crf.type
TARGET=ONLINE
STATE=ONLINE on szaa2
[grid@+ASM2 /home/grid]$ ps -ef|grep osysmond
grid 2012 1938 0 16:28 pts/1 00:00:00 grep osysmond
root 4345 1 2 Apr01 ? 08:48:03 /oracle/product/11.2.0/grid11g/bin/osysmond.bin
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE szaa1 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE szaa1
ora.crf
1 ONLINE ONLINE szaa1
ora.crsd
1 ONLINE ONLINE szaa1
ora.cssd
1 ONLINE ONLINE szaa1
ora.cssdmonitor
1 ONLINE ONLINE szaa1
ora.ctssd
1 ONLINE ONLINE szaa1 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE szaa1
ora.gipcd
1 ONLINE ONLINE szaa1
ora.gpnpd
1 ONLINE ONLINE szaa1
ora.mdnsd
1 ONLINE ONLINE szaa1
[grid@+ASM1 /home/grid]$
--主节点
[grid@+ASM1 /home/grid]$ ps -ef|grep ologgerd
grid 3195 31768 0 16:30 pts/1 00:00:00 grep ologgerd
root 4664 1 0 Apr01 ? 02:00:50 /oracle/product/11.2.0/grid11g/bin/ologgerd-M -d /oracle/product/11.2.0/grid11g/crf/db/szaa1
[grid@+ASM1 /home/grid]$
--备节点
[grid@+ASM2 /home/grid]$ ps -ef|grep ologgerd
grid 2047 1938 0 16:30 pts/1 00:00:00 grep ologgerd
root 23158 1 0 Apr03 ? 00:36:22 /oracle/product/11.2.0/grid11g/bin/ologgerd -m szaa1 -r -d /oracle/product/11.2.0/grid11g/crf/db/szaa2
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ oclumon manage -get reppath
CHM Repository Path = /oracle/product/11.2.0/grid11g/crf/db/szaa1
Done
[grid@+ASM1 /home/grid]$
[grid@+ASM2 /home/grid]$ oclumon manage -get reppath
CHM Repository Path = /oracle/product/11.2.0/grid11g/crf/db/szaa1
Done
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ oclumon manage -get repsize
CHM Repository Size = 61646 --单位为秒 3 小时
Done
[grid@+ASM1 /home/grid]$
[grid@+ASM2 /home/grid]$ oclumon manage -get repsize
CHM Repository Size = 61646
Done
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ oclumon manage -get master
Master = szaa1
Done
[grid@+ASM1 /home/grid]$
[grid@+ASM2 /home/grid]$ oclumon manage -get master
Master = szaa1
Done
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ oclumon manage -get master
Master = szaa1
Done
--节点1停止实验
[grid@+ASM1 /home/grid]$ crsctl stop res ora.crf -init
CRS-2673: Attempting to stop 'ora.crf' on 'szaa1'
CRS-2677: Stop of 'ora.crf' on 'szaa1' succeeded
[grid@+ASM1 /home/grid]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SZAA.dg ora....up.type ONLINE ONLINE szaa1
ora....ER.lsnr ora....er.type ONLINE ONLINE szaa1
ora....N1.lsnr ora....er.type ONLINE ONLINE szaa1
ora.OCR.dg ora....up.type ONLINE ONLINE szaa1
ora....SZAA.dg ora....up.type ONLINE ONLINE szaa1
ora.asm ora.asm.type ONLINE ONLINE szaa1
ora.cvu ora.cvu.type ONLINE ONLINE szaa1
ora.foc.db ora....se.type ONLINE ONLINE szaa1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE szaa1
ora.oc4j ora.oc4j.type ONLINE ONLINE szaa1
ora.ons ora.ons.type ONLINE ONLINE szaa1
ora.scan1.vip ora....ip.type ONLINE ONLINE szaa1
ora....SM1.asm application ONLINE ONLINE szaa1
ora....A1.lsnr application ONLINE ONLINE szaa1
ora.szaa1.gsd application OFFLINE OFFLINE
ora.szaa1.ons application ONLINE ONLINE szaa1
ora.szaa1.vip ora....t1.type ONLINE ONLINE szaa1
ora....SM2.asm application ONLINE ONLINE szaa2
ora....A2.lsnr application ONLINE ONLINE szaa2
ora.szaa2.gsd application OFFLINE OFFLINE
ora.szaa2.ons application ONLINE ONLINE szaa2
ora.szaa2.vip ora....t1.type ONLINE ONLINE szaa2
[grid@+ASM1 /home/grid]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE szaa1 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE szaa1
ora.crf
1 OFFLINE OFFLINE
ora.crsd
1 ONLINE ONLINE szaa1
ora.cssd
1 ONLINE ONLINE szaa1
ora.cssdmonitor
1 ONLINE ONLINE szaa1
ora.ctssd
1 ONLINE ONLINE szaa1 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE szaa1
ora.gipcd
1 ONLINE ONLINE szaa1
ora.gpnpd
1 ONLINE ONLINE szaa1
ora.mdnsd
1 ONLINE ONLINE szaa1
[grid@+ASM1 /home/grid]$ oclumon manage -get master
[grid@+ASM1 /home/grid]$ oclumon manage -get master
CRS-9011-Error manage: Failed to initialize connection to the Cluster Logger Service
[grid@+ASM1 /home/grid]$
与生产环境类似
[grid@+ASM2 /home/grid]$ oclumon manage -get master
Master = szaa2
Done
节点1:
[grid@+ASM1 /home/grid]$ oclumon manage -get master
CRS-9011-Error manage: Failed to initialize connection to the Cluster Logger Service
[grid@+ASM1 /home/grid]$ top
top - 16:47:34 up 14 days, 21:49, 1 user, load average: 0.08, 0.04, 0.01
Tasks: 291 total, 1 running, 290 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.5%us, 1.6%sy, 0.0%ni, 96.5%id, 0.3%wa, 0.1%hi, 0.1%si, 0.0%st
Mem: 6120848k total, 5912804k used, 208044k free, 206232k buffers
Swap: 8159224k total, 0k used, 8159224k free, 3813656k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3768 root RT 0 245m 83m 55m S 4.0 1.4 0:05.42 osysmond.bin ################### 进程状态不正常时候cpu偏高,不一会后就正常了。
4547 grid RT 0 318m 110m 53m S 1.3 1.9 210:39.98 ocssd.bin
4478 root 20 0 355m 39m 15m S 1.0 0.7 177:13.99 orarootagent.bi
4757 grid -2 0 501m 14m 12m S 1.0 0.2 234:28.64 oracle
4982 root 20 0 1707m 25m 13m S 1.0 0.4 191:48.19 orarootagent.bi
30994 oracle 20 0 756m 33m 16m S 1.0 0.6 97:18.03 oraagent.bin
31034 oracle -2 0 731m 16m 14m S 1.0 0.3 211:18.48 oracle
3736 root 20 0 380m 50m 21m S 0.7 0.8 106:54.85 ohasd.bin
3900 grid 20 0 12888 1264 828 R 0.7 0.0 0:00.10 top
4481 grid 20 0 244m 30m 12m S 0.7 0.5 74:27.10 gipcd.bin
++ 结果明显:grid user
oclumon dumpnodeview -allnodes -v -s "2015-04-16 04:20:00" -e "2015-04-16 04:30:00" > 1.txt
++ 收集可能有问题:root user
/oracle/product/11.2.0/grid11g/bin/diagcollection.pl -collect -crshome /oracle/product/11.2.0/grid11g -chmoshome /oracle/product/11.2.0/grid11g -chmos -incidenttime 04/16/2015 17:30:00 -incidentduration 00:05
[grid@+ASM1 /home/grid]$ crsctl stat res ora.crf -init
NAME=ora.crf
TYPE=ora.crf.type
TARGET=ONLINE
STATE=ONLINE on szaa1
[grid@+ASM1 /home/grid]$
[grid@+ASM1 /home/grid]$ ps -ef|grep osysmond
grid 3131 31768 0 16:28 pts/1 00:00:00 grep osysmond
root 4499 1 2 Apr01 ? 09:18:04 /oracle/product/11.2.0/grid11g/bin/osysmond.bin
[grid@+ASM1 /home/grid]$
[grid@+ASM2 /home/grid]$ crsctl stat res ora.crf -init
NAME=ora.crf
TYPE=ora.crf.type
TARGET=ONLINE
STATE=ONLINE on szaa2
[grid@+ASM2 /home/grid]$ ps -ef|grep osysmond
grid 2012 1938 0 16:28 pts/1 00:00:00 grep osysmond
root 4345 1 2 Apr01 ? 08:48:03 /oracle/product/11.2.0/grid11g/bin/osysmond.bin
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE szaa1 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE szaa1
ora.crf
1 ONLINE ONLINE szaa1
ora.crsd
1 ONLINE ONLINE szaa1
ora.cssd
1 ONLINE ONLINE szaa1
ora.cssdmonitor
1 ONLINE ONLINE szaa1
ora.ctssd
1 ONLINE ONLINE szaa1 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE szaa1
ora.gipcd
1 ONLINE ONLINE szaa1
ora.gpnpd
1 ONLINE ONLINE szaa1
ora.mdnsd
1 ONLINE ONLINE szaa1
[grid@+ASM1 /home/grid]$
--主节点
[grid@+ASM1 /home/grid]$ ps -ef|grep ologgerd
grid 3195 31768 0 16:30 pts/1 00:00:00 grep ologgerd
root 4664 1 0 Apr01 ? 02:00:50 /oracle/product/11.2.0/grid11g/bin/ologgerd-M -d /oracle/product/11.2.0/grid11g/crf/db/szaa1
[grid@+ASM1 /home/grid]$
--备节点
[grid@+ASM2 /home/grid]$ ps -ef|grep ologgerd
grid 2047 1938 0 16:30 pts/1 00:00:00 grep ologgerd
root 23158 1 0 Apr03 ? 00:36:22 /oracle/product/11.2.0/grid11g/bin/ologgerd -m szaa1 -r -d /oracle/product/11.2.0/grid11g/crf/db/szaa2
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ oclumon manage -get reppath
CHM Repository Path = /oracle/product/11.2.0/grid11g/crf/db/szaa1
Done
[grid@+ASM1 /home/grid]$
[grid@+ASM2 /home/grid]$ oclumon manage -get reppath
CHM Repository Path = /oracle/product/11.2.0/grid11g/crf/db/szaa1
Done
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ oclumon manage -get repsize
CHM Repository Size = 61646 --单位为秒 3 小时
Done
[grid@+ASM1 /home/grid]$
[grid@+ASM2 /home/grid]$ oclumon manage -get repsize
CHM Repository Size = 61646
Done
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ oclumon manage -get master
Master = szaa1
Done
[grid@+ASM1 /home/grid]$
[grid@+ASM2 /home/grid]$ oclumon manage -get master
Master = szaa1
Done
[grid@+ASM2 /home/grid]$
[grid@+ASM1 /home/grid]$ oclumon manage -get master
Master = szaa1
Done
--节点1停止实验
[grid@+ASM1 /home/grid]$ crsctl stop res ora.crf -init
CRS-2673: Attempting to stop 'ora.crf' on 'szaa1'
CRS-2677: Stop of 'ora.crf' on 'szaa1' succeeded
[grid@+ASM1 /home/grid]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SZAA.dg ora....up.type ONLINE ONLINE szaa1
ora....ER.lsnr ora....er.type ONLINE ONLINE szaa1
ora....N1.lsnr ora....er.type ONLINE ONLINE szaa1
ora.OCR.dg ora....up.type ONLINE ONLINE szaa1
ora....SZAA.dg ora....up.type ONLINE ONLINE szaa1
ora.asm ora.asm.type ONLINE ONLINE szaa1
ora.cvu ora.cvu.type ONLINE ONLINE szaa1
ora.foc.db ora....se.type ONLINE ONLINE szaa1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE szaa1
ora.oc4j ora.oc4j.type ONLINE ONLINE szaa1
ora.ons ora.ons.type ONLINE ONLINE szaa1
ora.scan1.vip ora....ip.type ONLINE ONLINE szaa1
ora....SM1.asm application ONLINE ONLINE szaa1
ora....A1.lsnr application ONLINE ONLINE szaa1
ora.szaa1.gsd application OFFLINE OFFLINE
ora.szaa1.ons application ONLINE ONLINE szaa1
ora.szaa1.vip ora....t1.type ONLINE ONLINE szaa1
ora....SM2.asm application ONLINE ONLINE szaa2
ora....A2.lsnr application ONLINE ONLINE szaa2
ora.szaa2.gsd application OFFLINE OFFLINE
ora.szaa2.ons application ONLINE ONLINE szaa2
ora.szaa2.vip ora....t1.type ONLINE ONLINE szaa2
[grid@+ASM1 /home/grid]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE szaa1 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE szaa1
ora.crf
1 OFFLINE OFFLINE
ora.crsd
1 ONLINE ONLINE szaa1
ora.cssd
1 ONLINE ONLINE szaa1
ora.cssdmonitor
1 ONLINE ONLINE szaa1
ora.ctssd
1 ONLINE ONLINE szaa1 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE szaa1
ora.gipcd
1 ONLINE ONLINE szaa1
ora.gpnpd
1 ONLINE ONLINE szaa1
ora.mdnsd
1 ONLINE ONLINE szaa1
[grid@+ASM1 /home/grid]$ oclumon manage -get master
[grid@+ASM1 /home/grid]$ oclumon manage -get master
CRS-9011-Error manage: Failed to initialize connection to the Cluster Logger Service
[grid@+ASM1 /home/grid]$
与生产环境类似
[grid@+ASM2 /home/grid]$ oclumon manage -get master
Master = szaa2
Done
节点1:
[grid@+ASM1 /home/grid]$ oclumon manage -get master
CRS-9011-Error manage: Failed to initialize connection to the Cluster Logger Service
[grid@+ASM1 /home/grid]$ top
top - 16:47:34 up 14 days, 21:49, 1 user, load average: 0.08, 0.04, 0.01
Tasks: 291 total, 1 running, 290 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.5%us, 1.6%sy, 0.0%ni, 96.5%id, 0.3%wa, 0.1%hi, 0.1%si, 0.0%st
Mem: 6120848k total, 5912804k used, 208044k free, 206232k buffers
Swap: 8159224k total, 0k used, 8159224k free, 3813656k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3768 root RT 0 245m 83m 55m S 4.0 1.4 0:05.42 osysmond.bin ################### 进程状态不正常时候cpu偏高,不一会后就正常了。
4547 grid RT 0 318m 110m 53m S 1.3 1.9 210:39.98 ocssd.bin
4478 root 20 0 355m 39m 15m S 1.0 0.7 177:13.99 orarootagent.bi
4757 grid -2 0 501m 14m 12m S 1.0 0.2 234:28.64 oracle
4982 root 20 0 1707m 25m 13m S 1.0 0.4 191:48.19 orarootagent.bi
30994 oracle 20 0 756m 33m 16m S 1.0 0.6 97:18.03 oraagent.bin
31034 oracle -2 0 731m 16m 14m S 1.0 0.3 211:18.48 oracle
3736 root 20 0 380m 50m 21m S 0.7 0.8 106:54.85 ohasd.bin
3900 grid 20 0 12888 1264 828 R 0.7 0.0 0:00.10 top
4481 grid 20 0 244m 30m 12m S 0.7 0.5 74:27.10 gipcd.bin
++ 结果明显:grid user
oclumon dumpnodeview -allnodes -v -s "2015-04-16 04:20:00" -e "2015-04-16 04:30:00" > 1.txt
++ 收集可能有问题:root user
/oracle/product/11.2.0/grid11g/bin/diagcollection.pl -collect -crshome /oracle/product/11.2.0/grid11g -chmoshome /oracle/product/11.2.0/grid11g -chmos -incidenttime 04/16/2015 17:30:00 -incidentduration 00:05
0 0
- Oracle Cluster Health Monitor(CHM)
- Oracle Cluster Health Monitor(CHM)简单介绍
- 11gR2 新特性:Oracle Cluster Health Monitor(CHM)简介
- 11gR2 新特性:Oracle Cluster Health Monitor(CHM)简介
- 如何安装独立版的CHM(Oracle Cluster Health Monitor)
- Oracle 12c Cluster Health Monitor 详解
- Cluster Health Monitor (CHM) FAQ (文档 ID 1328466.1)
- 11g 新特性 CHM(Cluster Health Monitor)
- Monitoring the Cluster in Real Time with CHM (Cluster Health Monitor)
- ORACLE:Health Monitor
- ORACLE:Health Monitor
- ORACLE:Health Monitor
- oracle Health Monitor
- oracle health monitor
- health monitor
- cluster health
- Oracle健康监控及健康检查(Health Monitor)
- Health Monitor和ADR
- leetcode 日经贴,Cpp code -Fraction to Recurring Decimal
- 参考资源_
- Android点击效果加边框
- 第五届在线编程大赛月赛第三题:石子游戏(1)
- 使用pdshell15教程
- Oracle Cluster Health Monitor(CHM)
- Android中RelativeLayout各个属性 android:layout_alignParentLeft=”true”找不到有时候
- 浅说《测试用例》----给测试新手的
- sql行列转置的实现方法
- 徐汉彬:Web系统大规模并发——电商秒杀与抢购
- Permutation Sequence
- <1> unity3d 分包与上google play 之环境搭建和各种账号注册
- A - Number Sequence HDU1005 ( kmp 算法+整数数组的应用)
- Javascript 调试利器 Firebug使用详解六