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 <NULL>
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 600
ERROR_ARG1 kebm_mmon_main_1
ERROR_ARG2 36
ERROR_ARG3 <NULL>
ERROR_ARG4 <NULL>
ERROR_ARG5 <NULL>
ERROR_ARG6 <NULL>
ERROR_ARG7 <NULL>
ERROR_ARG8 <NULL>
SIGNALLING_COMPONENT <NULL>
SIGNALLING_SUBCOMPONENT <NULL>
SUSPECT_COMPONENT <NULL>
SUSPECT_SUBCOMPONENT <NULL>
ECID <NULL>
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