[20161229]linux下使用oclumon指令(rac).txt
--11G RAC下grid 存在一個指令oclumon可以了解監測群集健康.簡單了解一下.
1.環境:
SYS@+ASM1> select * from v$version where rownum<=1;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
$ oclumon version
Cluster Health Monitor (OS), Version 11.2.0.4.0 - Production Copyright 2011 Oracle. All rights reserved.
-//真不知道為什麼這樣命名這個指令, o表示oracle,clu表示cluster. mon表示monitor.我的了解不知道是否正确.
2.測試與學習:
$ oclumon -h
For help from command line : oclumon <verb> -h
For help in interactive mode : <verb> -h
Currently supported verbs are :
showobjects, dumpnodeview, manage, version, debug, quit, exit, and help
--//這裡verb我開始了解錯誤,以為是版本,實際上表示動詞或者動作的意思.也就是你要看某個指令打入 oclumon showobjects -h.
$ oclumon showobjects
Following nodes are attached to the loggerd
dm01dbadm01
dm01dbadm02
$ oclumon manage -h
MANAGE verb usage
=================
manage [[-repos {resize <time>|changesize <memsize>|reploc <new_loc> [[-maxtime <time>]|
[-maxspace <memsize>]] }]|[-get <key1> <key2>..]]
*Where
-repos = Required to specify Cluster Health Monitor repository related options
-get = Fetch manage information for one or more named keys
<key1> <key2>= <key> can be repsize, reppath, master, and replica
resize = Option for resizing Cluster Health Monitor repository
<time> = Size of Cluster Health Monitor repository in number of seconds
must be more than 3600 (1 hour) and less than 259200 (3 days)
changesize = Option for Change Cluster Health Monitor repository space limit
<memsize> = Size of Cluster Health Monitor repository in megabytes
reploc = Option for Change Repository Location
<new_loc> = Path to new directory e.g.: /opt/db
-maxtime = Option to specify Cluster Health Monitor repository size in terms of elapsed seconds of data capture for new location
-maxspace = Option to specify space limit for new Cluster Health Monitor repository location
*Requirements
The local system monitor service must be running to resize the Cluster Health Monitor repository.
The Cluster Logger Service must be running to resize Cluster Health Monitor repository.
*Example :
manage -get MASTER REPLICA
manage -repos resize 86400
manage -repos changesize 6000
manage -repos reploc /opt/oracrfdb
manage -repos reploc /opt/oracrfdb -maxtime 86400
manage -repos reploc /opt/oracrfdb -maxspace 6000
--//這個有點複雜,不敢亂用.文法怪怪的!!resize後面的應該是指時間長短. changesize後面的應該是大小.測試一下get什麼意思..
--//僅僅支援後面4個參數repsize, reppath, master, and replica.看測試例子不區分大小寫.
$ oclumon manage -get MASTER REPLICA
Master = dm01dbadm01
Replica = dm01dbadm02
Done
$ oclumon manage -get repsize reppath master replica
CHM Repository Path = /u01/app/11.2.0.4/grid/crf/db/dm01dbadm01
CHM Repository Size = 61511
--剩下dumpnodeview指令,推測應該是從CHM Repository Path = /u01/app/11.2.0.4/grid/crf/db/dm01dbadm01目錄取資訊.
$ cd /u01/app/11.2.0.4/grid/crf/db/dm01dbadm01
$ ls -l
total 254604
-rw-r--r-- 1 root root 1075900 2014-10-10 21:02:53 10-OCT-2014-21:02:53.txt
-rw-r--r-- 1 root root 1755175 2014-12-11 02:54:44 11-DEC-2014-02:54:44.txt
-rw-r--r-- 1 root root 1229318 2014-12-11 03:02:22 11-DEC-2014-03:02:22.txt
-rw-r--r-- 1 root root 2345265 2014-10-11 16:59:07 11-OCT-2014-16:59:07.txt
-rw-r--r-- 1 root root 1695640 2014-10-11 17:00:56 11-OCT-2014-17:00:56.txt
-rw-r--r-- 1 root root 1989345 2014-11-19 18:01:01 19-NOV-2014-18:01:01.txt
-rw-r--r-- 1 root root 1407927 2014-11-19 18:08:57 19-NOV-2014-18:08:57.txt
-rw-r----- 1 root root 7053312 2016-12-29 10:39:38 crfalert.bdb
-rw-r----- 1 root root 186449920 2016-12-29 10:39:38 crfclust.bdb
-rw-r----- 1 root root 8192 2014-12-11 03:02:22 crfconn.bdb
-rw-r----- 1 root root 11829248 2016-12-29 10:39:38 crfcpu.bdb
-rw-r----- 1 root root 5398528 2016-12-29 10:39:38 crfhosts.bdb
-rw-r----- 1 root root 4239360 2016-12-29 10:39:38 crfloclts.bdb
-rw-r----- 1 root root 5038080 2016-12-29 10:39:38 crfts.bdb
-rw-r----- 1 root root 24576 2014-12-11 02:54:43 __db.001
-rw-r----- 1 root root 401408 2016-12-29 10:40:23 __db.002
-rw-r----- 1 root root 2629632 2016-12-29 10:40:25 __db.003
-rw-r----- 1 root root 2162688 2016-12-29 10:40:25 __db.004
-rw-r----- 1 root root 1187840 2016-12-29 10:40:23 __db.005
-rw-r----- 1 root root 57344 2016-12-29 10:39:58 __db.006
-rw-r--r-- 1 root root 120000000 2016-12-29 10:08:26 dm01dbadm01.ldb
-rw-r----- 1 root root 16777216 2016-12-29 10:25:03 log.0000033985
-rw-r----- 1 root root 16777216 2016-12-29 10:39:38 log.0000033986
-rw-r----- 1 root root 8192 2014-12-11 02:54:43 repdhosts.bdb
--//視乎是一些類似資料庫的資訊.
$ oclumon dumpnodeview -h
dumpnodeview verb usage
=======================
The dumpnodeview command reports monitored records in the text format. The
collection of metrics for a node at a given point in time (a timestamp) is
called a node view.
* Usage
dumpnodeview [[-allnodes|-n <node1> ...] [-last <duration>|
-s <timestamp> -e <timestamp>][-v][-warning]]
-n <node1> ... = Dump node views for given nodes
-allnodes = Dump node views for all nodes
-s <timestamp> = Specify start time for range dump of node views
-e <timestamp> = Specify end time for range dump of node views
Absolute timestamp should be in "YYYY-MM-DD HH24:MI:SS"
format, for example "2007-11-12 23:05:00"
-warning = Print node views with warnings only
-last <duration> = Dump the latest node views for a specified duration
Duration should be in "HH24:MI:SS" format, for example
"00:45:00"
-v = Dump verbose node views
*Requirements and notes
To stop continuous display, use Ctrl-C on Linux or UNIX and Esc on Windows.
-s and -e need to be given together for range dumps of node views.
The local System Monitor Service (osysmond) should be running to get dumps.
The Cluster Logger Service (ologgerd) should be running to get dumps.
When -warning is used in continuous mode, the prompt waits until interrupted.
*Defaults :
Mode : Continuous mode
oclumon dumpnodeview -n node1 node2 node3 -last "12:00:00"
$ oclumon dumpnodeview -n dm01dbadm01 dm01dbadm02 -last "12:00:00"
--輸出1堆資訊.
$ oclumon dumpnodeview -n dm01dbadm01 dm01dbadm02 -last "00:01:00" > aa.txt
.. //看不懂
3.可以支援互動模式.直接輸入oclumon.
$ oclumon
query> version
query> help
query> showobjects
--//這個模式更上面差別不大.
4.補充oclumon showobjects:
]$ oclumon showobjects -h
showobjects verb usage
======================
showobjects [[-allnodes]|[-n <node> [[-disk]|[-proc]|[-nic]]]][-time <time> [-b <band>]]
-n = Show objects for given node
<node> = Node name for which objects need to be shown
-time = Time at which objects are required
<time> = Absolute time to be specified within quotes in
"YYYY-MM-DD HH24:MI:SS" format, like "2007-11-12 23:05:00"
-disk = To request list of disks
-nic = To request list of network interface cards
-proc = To request list of processes
-allnodes = Shows all the nodes which can be queried
-b = For specifying maximum look up around <time> in seconds
<band> = Size of band in seconds
Local System Monitor Service should be running to get objects.
Master loggerd should be running to get objects.
Time : Current
Option : -allnodes
showobjects -n stadn59 -disk -time "2008-02-20 02:01:48"
--//例子: -n 僅僅能輸入1個節點,不能輸入多個.後面的參數disk,nic,proc也是一樣
$ oclumon showobjects -n dm01dbadm02 -disk -time '2016-12-29 10:00:00'
List of disks on dm01dbadm02
dm-3
dm-2
dm-1
dm-0
sda
sda3
sda2
sda1
$ oclumon showobjects -n dm01dbadm02 -nic -time '2016-12-29 10:00:00'
List of nics on dm01dbadm02
lo
eth0
eth3
ib0
ib1
bondeth0
$ oclumon showobjects -n dm01dbadm02 -proc -time '2016-12-29 10:00:00'
List of processes on dm01dbadm02
105939 oracledben2
20101 java
16733 osysmond.bin
106595 oracledben2
43515 top
23410 ora_lck0_dbcn2
14171 oracledben2
23223 ora_dia0_dbcn2
23205 ora_vktm_dbcn2
25557 ora_dia0_dben2
25541 ora_vktm_dben2
21219 asm_vktm_+ASM2
15234 oracledben2
40031 oracledben2
21988 tnslsnr
106125 oracledben2
23257 ora_lgwr_dbcn2
16815 ocssd.bin
16720 orarootagent.bi
23234 ora_lms1_dbcn2
23230 ora_lms0_dbcn2
22569 oraagent.bin
22020 tnslsnr
....
![mybatis_入門程式Mybatis入門[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)