ORACLE提供檢驗RAC是否健康指令碼
About Using CVU Cluster Healthchecks After Installation
ORACLE提供檢驗RAC是否健康指令碼
dwdb1:/home/grid$cluvfy comp healthcheck -collect cluster -bestpractice
Verifying OS Best Practice
Verifying availability of port 8888 ...met
Verifying Network parameter - ipqmaxlen ...met
Verifying Network parameter - rfc1323 ...met
Verifying Network parameter - sb_max ...met
Verifying Network parameter - tcp_sendspace ...met
Verifying Network parameter - tcp_recvspace ...met
Verifying Network parameter - udp_sendspace ...met
Verifying Network parameter - udp_recvspace ...met
Verifying Clusterware Best Practice
Verifying CSS misscount parameter ...met
Verifying CSS reboottime parameter ...met
Verifying CSS disktimeout parameter ...met
Verifying Ethernet Jumbo Frames ...met
******************************************************************************************
Summary of environment
******************************************************************************************
Date (mm/dd/yyyy) : 04/14/2014
Time (hh:mm:ss) : 11:53:58
Cluster name : scan-dwdoudou
Clusterware version : 11.2.0.4.0
Grid home : /oracle/rac/11.2
Grid User : grid
Operating system : AIX6.1
******************************************************************************************
System recommendations
******************************************************************************************
Verification Check : Network parameter - udp_recvspace
Verification Description : Checks if the network parameter is set correctly on the
system
Verification Result : MET
Verification Summary : Check for Network parameter - udp_recvspace passed
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 655360 en9=655360
dwdb2 PASSED 655360 en9=655360
__________________________________________________________________________________________
Verification Check : Network parameter - udp_sendspace
Verification Description : Checks if the network parameter is set correctly on the
system
Verification Result : MET
Verification Summary : Check for Network parameter - udp_sendspace passed
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 65536 en9=65536
dwdb2 PASSED 65536 en9=65536
__________________________________________________________________________________________
Verification Check : Network parameter - tcp_recvspace
Verification Description : Checks if the network parameter is set correctly on the
system
Verification Result : MET
Verification Summary : Check for Network parameter - tcp_recvspace passed
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 65536 en9=65536
dwdb2 PASSED 65536 en9=65536
__________________________________________________________________________________________
Verification Check : Network parameter - tcp_sendspace
Verification Description : Checks if the network parameter is set correctly on the
system
Verification Result : MET
Verification Summary : Check for Network parameter - tcp_sendspace passed
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 65536 en9=131072
dwdb2 PASSED 65536 en9=131072
__________________________________________________________________________________________
Verification Check : Network parameter - sb_max
Verification Description : Checks if the network parameter is set correctly on the
system
Verification Result : MET
Verification Summary : Check for Network parameter - sb_max passed
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 4194304 en9=4194304
dwdb2 PASSED 4194304 en9=4194304
__________________________________________________________________________________________
Verification Check : Network parameter - rfc1323
Verification Description : Checks if the network parameter is set correctly on the
system
Verification Result : MET
Verification Summary : Check for Network parameter - rfc1323 passed
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 1 en9=1
dwdb2 PASSED 1 en9=1
__________________________________________________________________________________________
Verification Check : Network parameter - ipqmaxlen
Verification Description : Checks if the network parameter is set correctly on the
system
Verification Result : MET
Verification Summary : Check for Network parameter - ipqmaxlen passed
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 512 en9=512
dwdb2 PASSED 512 en9=512
__________________________________________________________________________________________
Verification Check : availability of port 8888
Verification Description : availability of port 8888
Verification Result : MET
Verification Summary : Check for availability of port 8888 passed
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED true true
dwdb2 PASSED true true
__________________________________________________________________________________________
******************************************************************************************
Clusterware recommendations
******************************************************************************************
Verification Check : Ethernet Jumbo Frames
Verification Description : Checks if Jumbo Frames are configured on the system
Verification Result : MET
Verification Summary : Check for Ethernet Jumbo Frames passed
Additional Details : A performance improvement can be seen with Jumbo Frames,
check with your system and network administrator first and
if possible, configure Jumbo Frames on interconnect. See
reference for more detail specific to platform.
References (URLs/Notes) :
1002_USEN
cts_configuration_example09186a008010edab.shtml
5.html
cnt_2724?c=us&cs=04&l=en&s=bsd
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 1500 1500
dwdb2 PASSED 1500 1500
__________________________________________________________________________________________
Verification Check : CSS disktimeout parameter
Verification Description : Checks if the CSS disktimeout is set correctly on the
system
Verification Result : MET
Verification Summary : Check for CSS disktimeout parameter passed
Additional Details : The maximum amount of time allowed for a voting file I/O
to complete; if this time is exceeded the voting disk will
be marked as offline. Note that this is also the amount
of time that will be required for initial cluster
formation, i.e. when no nodes have previously been up and
in a cluster.
References (URLs/Notes) :
OT&id=294430.1
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 200 200
dwdb2 PASSED 200 200
__________________________________________________________________________________________
Verification Check : CSS reboottime parameter
Verification Description : Checks if the CSS reboottime is set correctly on the system
Verification Result : MET
Verification Summary : Check for CSS reboottime parameter passed
Additional Details : reboottime (default 3 seconds) is the amount of time
allowed for a node to complete a reboot after the CSS
daemon has been evicted.
References (URLs/Notes) :
OT&id=294430.1
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 3 3
dwdb2 PASSED 3 3
__________________________________________________________________________________________
Verification Check : CSS misscount parameter
Verification Description : Checks if the CSS misscount is set correctly on the system
Verification Result : MET
Verification Summary : Check for CSS misscount parameter passed
Additional Details : The CSS misscount parameter represents the maximum time,
in seconds, that a network heartbeat can be missed before
entering into a cluster reconfiguration to evict the node
References (URLs/Notes) :
OT&id=294430.1
Node Status Expected Value Actual Value
------------------------------------------------------------------------------------------
dwdb1 PASSED 30 30
dwdb2 PASSED 30 30
_________________________________________________________________________________________
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-1141599/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 資料庫效能健康檢查指令碼Oracle資料庫指令碼
- Oracle運維指令碼-巡檢(RAC版)Oracle運維指令碼
- Oracle 10G RAC巡檢指令碼Oracle 10g指令碼
- (轉)oracle 資料庫效能健康檢查指令碼Oracle資料庫指令碼
- RAC指令碼檢查指令碼
- oracle 資料庫效能健康檢查指令碼[轉帖]Oracle資料庫指令碼
- Linux 系統健康巡檢指令碼Linux指令碼
- Oracle運維指令碼-巡檢(RAC版本)-V1.1Oracle運維指令碼
- Oracle運維指令碼-檢視DB各時間段健康狀況Oracle運維指令碼
- 資料庫健康檢查 sqlplus 指令碼資料庫SQL指令碼
- python檢測圖片是否存在指令碼Python指令碼
- 檢視ORACLE AS 埠指令碼Oracle指令碼
- (轉)ORACLE 巡檢指令碼Oracle指令碼
- 一個簡單資料庫健康檢查指令碼資料庫指令碼
- Oracle 11g Rac清理指令碼Oracle指令碼
- 【RAC】Oracle Clusterware 診斷收集指令碼Oracle指令碼
- SHELL指令碼檢查Oracle DG備庫是否已經應用歸檔指令碼Oracle
- 檢查外來鍵是否有索引的指令碼索引指令碼
- 檢查CPU是否支援MMX指令的程式碼 (轉)
- Oracle 10g 提供的部分指令碼Oracle 10g指令碼
- Oracle 資料庫巡檢指令碼 單例項 RAC 輸出HTML格式Oracle資料庫指令碼單例HTML
- 巡檢指令碼OS+Oracle指令碼Oracle
- oracle 檢測指令碼on linuxOracle指令碼Linux
- check_postgres指令碼集檢查資料庫健康情況指令碼資料庫
- oracle健康巡檢筆記Oracle筆記
- 【SCN】Oracle檢查scn值指令碼Oracle指令碼
- oracle 巡檢指令碼(自動化)Oracle指令碼
- oracle、filesystem、backup日常巡檢指令碼Oracle指令碼
- Oracle RAC重新執行root.sh指令碼Oracle指令碼
- 批次檢查主機是否可達的ping指令碼.指令碼
- Oracle SCN健康狀態檢查Oracle
- oracle 檢視隱含引數指令碼Oracle指令碼
- (轉):oracle、filesystem、backup日常巡檢指令碼Oracle指令碼
- 【管理】Oracle 常用的V$ 檢視指令碼Oracle指令碼
- ORACLE RAC 心跳是否可以直連Oracle
- 分享實用監控指令碼:使用Shell檢查程式是否存在指令碼
- 使用CHECKSYNTAX命令檢查RMAN指令碼是否存在語法錯誤指令碼
- Oracle運維指令碼-巡檢(單機版)Oracle運維指令碼