|
|||||
|
以下脚本可以用于汇总RAC诊断信息， 并非每一个输出或者每一个日志都要阅读，在问题诊断时可以有针对性地查看， 如果是远程协助的会，可以让用户收集完打包 ，这样省去多次交互的时间：
– Cluster 启动状态 – hostname – uptime – vmstat iostat nmon OS stats – /etc/sysctl.conf /etc/system vmo -a no -a – /etc/inittab – /etc/init.d/init.crs – /etc/init.d/init.crsd – /etc/init.d/init.cssd – /etc/init.d/init.evmd – olsnodes – crsctl check css – crsctl check crs status – crsctl check crsd status – crsctl check . . . → Read More: Script:收集RAC诊断信息 以下脚本可以用于收集 Oracle RAC中vip 资源或其他CRS resource的诊断信息：
action plan: ./runcluvfy.sh stage -post crsinst -n all -verbose ./runcluvfy.sh stage -pre crsinst -n all -verbose or cluvfy stage -post crsinst -n all -verbose cluvfy stage -pre crsinst -n all -verbose 1. Please upload the following logs of all two nodes: $CRS_HOME/log/<nodename>/*.log $CRS_HOME/log/<nodename>/crsd/*.log $CRS_HOME/log/<nodename>/cssd/*.log $CRS_HOME/log/<nodename>/racg/*.log $CRS_HOME/log/<nodename>/client/*.log $CRS_HOME/log/<nodename>/evmd/*.log /etc/oracle/oprocd/*.log.* or . . . → Read More: Script:Collect vip resource Diagnostic Information CRS Resource的生命周期可以通过一系列的crs_* 资源管理命令来一步步诠释：
crs_profile : Create/Edit the resource’s attributes crs_register : Add the resource crs_start : start the resource crs_stat : status of the resource crs_relocate : move the resource crs_stop : stop the resource crs_unregister : Remove the resource
GES 全称为Global Enqueue Services是RAC中重要的全局队列锁服务，V$GES_STATISTICS 动态性能视图汇聚了主要的GES STATISTICS 统计信息。为了更好地理解GES STATISTICS ，我们可以通过下表理解这些统计项的含义：
V$GES_STATISTICS Reference (10.2.0.1.0) 0 messages sent directly
Incremented when any process successfully sends a message to a remote instance without being blocked and without flow control.
1 messages flow controlled
Incremented when any process could not send a . . . → Read More: Know more about RAC GES STATISTICS 以下列出了RAC中的主要统计信息和等待事件：
1. Statistics: 1.1 V$SYSSTAT, V$SESSTAT (join to V$STATNAME) gc cr blocks served gc cr block build time gc cr block flush time gc cr block send time gc current blocks served gc current block pin time gc current block flush time gc current block send time gc cr blocks received gc cr block . . . → Read More: Know more about RAC statistics and wait event LMHB是11gR2中新引入的后台进程，官方文档的介绍是Global Cache/Enqueue Service Heartbeat Monitor，Monitor the heartbeat of LMON, LMD, and LMSn processes，LMHB monitors LMON, LMD, and LMSn processes to ensure they are running normally without blocking or spinning。 Database and ASM instances, Oracle RAC 该进程负责监控LMON、LMD、LMSn等RAC关键的后台进程，保证这些background process不被阻塞或spin。 LMHB可能是Lock Manager Heartbeat的缩写。
我们来看一下该进程的trace跟踪文件以便了解其功能： 按照 100s -> 80s -> 100s -> 80s的间隔监控并输出一次LMSn、LCKn、LMON、LMD等进程的状态及wait chain，由kjfmGCR_HBCheckAll函数控制
*** 2012-02-03 00:03:10.066 . . . → Read More: 11gR2新特性:LMHB Lock Manager Heart Beat后台进程 
之前有同学想要给11gR2的RAC添加LISTENER监听器，查看了listener.ora并发现问题:
[oracle@vrh2 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.3.0 – Production on 04-DEC-2011 02:51:40 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ———————— Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.3.0 – Production Start Date 02-DEC-2011 05:40:09 Uptime 1 days 21 hr. 11 min. 31 sec . . . → Read More: 给11gR2 RAC添加LISTENER监听器并静态注册 以下脚本可以用于收集 11gR2中 RAC DRM 动态资源管理 特性的诊断信息:
REM for 11.2 only REM written by Maclean.Liu set linesize 140 pagesize 1400 select DRMS, AVG_DRM_TIME, QUIESCE_T,FRZ_T,CLEANUP_T,REPLAY_T,FIXWRITE_T,SYNC_T from X$KJDRMAFNSTATS / select * from GV$DYNAMIC_REMASTER_STATS / select object, node, sopens, xopens, xfers from x$object_policy_statistics — where object=&object_id / select data_object_id, current_master, previous_master, remaster_cnt from gv$gcspfmaster_info / select * from . . . → Read More: Script: 收集RAC DRM 诊断信息 |
|
||||
|
Copyright © 2012 Oracle Clinic – Maclean Liu的个人技术博客 - All Rights Reserved |
|||||
最新评论