ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle工具——ADRCI(二)

Oracle工具——ADRCI(二)

原创 Linux操作系统 作者:yangtingkun 时间:2009-03-31 23:53:29 0 删除 编辑

ADRCI工具是Oracle11g才推出的新工具,主要用来管理alert文件、trace文件、dump文件、健康监事报告等。

这一篇介绍ADRCI工具的一些常用命令。

Oracle工具——ADRCI(一):http://yangtingkun.itpub.net/post/468/481227

 

 

ADRCI众多命令中,比较常用的命令包括SHOW INCIDENTSHOW 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 PROBLEMSHOW 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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 流复制管理手册
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10523464