Oracle工具——ADRCI（二）
ADRCI工具是Oracle11g才推出的新工具，主要用來管理alert檔案、trace檔案、dump檔案、健康監事報告等。
這一篇介紹ADRCI工具的一些常用命令。
Oracle工具——ADRCI（一）：http://yangtingkun.itpub.net/post/468/481227
在ADRCI眾多命令中，比較常用的命令包括SHOW INCIDENT和SHOW PROBLEM。
看看這兩個命令的使用：
[oracle@yangtk ~]$ adrci
ADRCI: Release 11.1.0.6.0 - Beta on Sat Feb 14 07:40:14 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "/data/oracle"
adrci> show home
ADR Homes:
diag/tnslsnr/yangtk/listener
diag/clients/user_oracle/host_1761010651_11
diag/rdbms/ora11g_p/ora11g
diag/rdbms/ora11g/ora11g
adrci> set home diag/rdbms/ora11g_p/ora11g
adrci> show incident
ADR Home = /data/oracle/diag/rdbms/ora11g_p/ora11g:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
------------ ----------------------------- ----------------------------------
178263 ORA 4031 2008-08-06 07:18:22.545029 +08:00
178247 ORA 4031 2008-08-06 07:18:34.820273 +08:00
178239 ORA 4031 2008-08-06 07:18:22.504526 +08:00
178223 ORA 4031 2008-08-06 07:18:24.815544 +08:00
178143 ORA 4031 2008-08-06 07:18:35.246630 +08:00
177075 ORA 4031 2008-08-05 14:58:35.377256 +08:00
177067 ORA 4031 2008-08-05 14:58:58.782595 +08:00
177051 ORA 4031 2008-08-05 14:58:35.422671 +08:00
177043 ORA 4031 2008-08-05 14:58:35.402265 +08:00
176939 ORA 4031 2008-08-05 14:58:54.864399 +08:00
175859 ORA 4031 2008-08-05 13:58:50.980910 +08:00
175858 ORA 4031 2008-08-05 13:58:41.125870 +08:00
175826 ORA 4031 2008-08-05 13:58:42.802084 +08:00
175738 ORA 4031 2008-08-05 13:58:44.351160 +08:00
174657 ORA 4031 2008-08-05 13:46:41.399981 +08:00
174656 ORA 4031 2008-08-05 13:46:38.378564 +08:00
172231 ORA 7445 [ksldclt_cln()+264] 2008-08-04 22:07:06.387781 +08:00
172212 ORA 4031 2008-08-04 22:03:46.338443 +08:00
172211 ORA 4031 2008-08-04 22:03:40.771874 +08:00
172204 ORA 4031 2008-08-04 22:03:46.546782 +08:00
172203 ORA 4031 2008-08-04 22:03:38.053562 +08:00
172187 ORA 4031 2008-08-04 22:03:42.360428 +08:00
169786 ORA 4031 2008-07-30 02:36:18.482753 +08:00
169785 ORA 4031 2008-07-30 02:36:15.666044 +08:00
166151 ORA 603 2008-07-27 17:21:42.556972 +08:00
166129 ORA 603 2008-07-27 15:35:11.931255 +08:00
166039 ORA 4031 2008-07-27 15:21:42.574517 +08:00
166011 ORA 600 [kebm_mmon_main_1] 2008-07-27 17:52:24.860044 +08:00
166009 ORA 4031 2008-07-27 15:21:51.290947 +08:00
166008 ORA 4031 2008-07-27 15:21:45.393293 +08:00
166007 ORA 4031 2008-07-27 15:21:42.666587 +08:00
165999 ORA 4031 2008-07-27 15:21:52.049840 +08:00
161323 ORA 4031 2008-07-01 15:20:51.038193 +08:00
161322 ORA 4031 2008-07-01 15:20:50.132755 +08:00
161321 ORA 4031 2008-07-01 15:20:44.286697 +08:00
161257 ORA 4031 2008-07-01 15:20:48.717581 +08:00
161185 ORA 4031 2008-07-01 15:20:44.285834 +08:00
160110 ORA 4031 2008-06-26 04:15:27.704828 +08:00
160102 ORA 4031 2008-06-26 04:15:25.346548 +08:00
160086 ORA 4031 2008-06-26 04:15:28.601534 +08:00
160070 ORA 4031 2008-06-26 04:15:26.756150 +08:00
159974 ORA 4031 2008-06-26 04:15:24.147550 +08:00
156469 ORA 4031 2008-05-17 05:55:11.601467 +08:00
156453 ORA 4031 2008-05-17 05:55:21.028975 +08:00
156366 ORA 600 [qerghFetch:inc] 2008-05-17 08:10:01.178942 +08:00
156365 ORA 600 [qerghFetch:inc] 2008-05-17 05:02:50.616159 +08:00
156334 ORA 4031 2008-05-17 05:55:15.819541 +08:00
156333 ORA 4031 2008-05-17 05:55:14.628802 +08:00
156317 ORA 4031 2008-05-17 05:55:11.642549 +08:00
153748 ORA 7445 [kokacau()+683] 2008-02-28 05:10:44.389655 +08:00
50 rows fetched
adrci> show problem
ADR Home = /data/oracle/diag/rdbms/ora11g_p/ora11g:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
----------- ----------------------------- -------------- ----------------------------------
7 ORA 4031 178240 2008-08-06 07:18:43.590263 +08:00
12 ORA 7445 [ksldclt_cln()+264] 172231 2008-08-04 22:07:06.387781 +08:00
11 ORA 600 [kebm_mmon_main_1] 166011 2008-07-27 17:52:24.860044 +08:00
5 ORA 603 166151 2008-07-27 17:21:42.556972 +08:00
10 ORA 600 [qerghFetch:inc] 156366 2008-05-17 08:10:01.178942 +08:00
9 ORA 600 [qmxiUnpPacked2] 152793 2008-02-28 06:08:31.659320 +08:00
8 ORA 7445 [kokacau()+683] 153748 2008-02-28 05:10:44.389655 +08:00
6 ORA 1578 123833 2007-11-24 02:49:43.837675 +08:00
4 ORA 600 [krhpfh_03-1208] 117944 2007-11-09 00:48:49.678494 +08:00
3 ORA 600 [prssptoa2] 96380 2007-10-18 00:53:25.480274 +08:00
2 ORA 600 [kkdcacr: ptn_kxcp] 85602 2007-10-11 22:01:08.539854 +08:00
1 ORA 7445 [koioapm()+254] 14503 2007-09-06 02:50:52.122404 +08:00
12 rows fetched
Oracle將每次錯誤資訊作為一個INCIDENT，透過SHOW INCIDENT可以很方便的瞭解alert檔案中包含所有的錯誤資訊，以及發生的時間點。
而SHOW PROBLEM的結果更加清晰，它會根據Oracle的錯誤號，將相同的錯誤資訊合併到一起。透過這個結果，可以瞭解資料庫出現了哪些不同的錯誤資訊。
無論是SHOW PROBLEM、SHOW INCIDENT還是SHOW ALERT命令，Oracle都支援定製查詢結果，比如只返回ORA-600錯誤的PROBLEM：
adrci> show problem -p "problem_key like '%600%'"
ADR Home = /data/oracle/diag/rdbms/ora11g_p/ora11g:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
----------- ---------------------------- -------------- ----------------------------------
11 ORA 600 [kebm_mmon_main_1] 166011 2008-07-27 17:52:24.860044 +08:00
10 ORA 600 [qerghFetch:inc] 156366 2008-05-17 08:10:01.178942 +08:00
9 ORA 600 [qmxiUnpPacked2] 152793 2008-02-28 06:08:31.659320 +08:00
4 ORA 600 [krhpfh_03-1208] 117944 2007-11-09 00:48:49.678494 +08:00
3 ORA 600 [prssptoa2] 96380 2007-10-18 00:53:25.480274 +08:00
2 ORA 600 [kkdcacr: ptn_kxcp] 85602 2007-10-11 22:01:08.539854 +08:00
6 rows fetched
而SHOW INCIDENT還支援更詳細的顯示，比如：
adrci> show incident -mode detail -p "incident_id=166011"
ADR Home = /data/oracle/diag/rdbms/ora11g_p/ora11g:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 166011
STATUS ready
CREATE_TIME 2008-07-27 17:52:24.860044 +08:00
PROBLEM_ID 11
CLOSE_TIME
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 600
ERROR_ARG1 kebm_mmon_main_1
ERROR_ARG2 36
ERROR_ARG3
ERROR_ARG4
ERROR_ARG5
ERROR_ARG6
ERROR_ARG7
ERROR_ARG8
SIGNALLING_COMPONENT
SIGNALLING_SUBCOMPONENT
SUSPECT_COMPONENT
SUSPECT_SUBCOMPONENT
ECID
IMPACTS 0
PROBLEM_KEY ORA 600 [kebm_mmon_main_1]
FIRST_INCIDENT 166011
FIRSTINC_TIME 2008-07-27 17:52:24.860044 +08:00
LAST_INCIDENT 166011
LASTINC_TIME 2008-07-27 17:52:24.860044 +08:00
IMPACT1 0
IMPACT2 0
IMPACT3 0
IMPACT4 0
KEY_NAME SID
KEY_VALUE 157.1
KEY_NAME Client ProcId
KEY_VALUE oracle@yangtk.ytk-thinkpad (MMON).2774_13056208
KEY_NAME ProcId
KEY_VALUE 14.1
OWNER_ID 1
INCIDENT_FILE /data/oracle/diag/rdbms/ora11g_p/ora11g/trace/ora11g_mmon_2774.trc
OWNER_ID 1
INCIDENT_FILE /data/oracle/diag/rdbms/ora11g_p/ora11g/incident/incdir_166011/ora11g_mmon_2774_i166011.trc
1 rows fetched
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/4227/viewspace-582512/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle工具——ADRCI（三）Oracle
- Oracle工具——ADRCI（一）Oracle
- Oracle 11g ADRCI工具使用Oracle
- oracle 11g adrci 工具使用方法Oracle
- 【ADRCI】使用ADRCI (ADR Command Interpreter) 工具檢視Oracle alert警告日誌Oracle
- oracle 11g adrci使用Oracle
- 用oracle的ADRCI功能檢視日誌Oracle
- ORACLE：使用ADRCI顯示意外事件Oracle事件
- ADRCI命令
- adrci 命令
- ADRCI工具的SHOW ALERT TAIL返回過多的結果AI
- Oracle備份之RMAN工具（二）Oracle
- Windows下用命令列工具ADRCI跟蹤日誌檔案Windows命令列
- ADRCI基礎知識
- oracle的字符集檢查工具CSSCAN(二)OracleCSS
- Automatic Diagnostic Repository (ADR) in Oracle Database 11g Release 1 (ADRCI)OracleDatabase
- 使用Oracle 11g的adrci的ips打包一個incidentOracleIDE
- Oracle11g 中使用ADRCI 檢視alert log檔案(xml格式)OracleXML
- 無工具情況下Oracle應急診斷思路（二）Oracle
- 11g ADRCI清理trace檔案
- CLUVFY工具（二）
- ORION工具（二）
- 使用11G 的ADRCI 清除trace檔案
- 【11g】使用ADRCI工具的“show alert”命令快速檢索出alert中所有“ORA-”錯誤資訊
- 在oracle 10.2.0.4上使用字符集掃描工具Csscan（二）OracleCSS
- 【Oracle】一款非常好用的trace檔案分析工具之二Oracle
- oracle10g_impdp工具測試學習_之二_transport_tablespacesOracle
- Oracle Flashback(二)Oracle
- oracle 程式（二）Oracle
- Oracle梳理二Oracle
- Oracle工具——csscanOracleCSS
- Oracle工具——WRAPOracle
- Oracle工具——ORAPWDOracle
- Oracle工具——DBVERIFYOracle
- Excel通用類工具(二)Excel
- 【工具】git筆記（二）Git筆記
- 【Oracle】Oracle常用EVENT之二Oracle
- Oracle工具(Oracle Tools) – SQLT(SQLTXPLAIN)OracleSQLAI