笔记：ADRCI 告警日志查看

oracle版本 11gR2

在oracle用户下执行adrci可以进入到里面 adrci工具允许你查看问题和事件 并将它们打包传给oracle support

[oracle@oracle11g trace]$ adrci

ADRCI: Release 11.2.0.1.0 - Production on Fri Feb 28 21:04:31 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/oracle"

使用show problem查看数据库中出现的错误

adrci> show problem

ADR Home = /u01/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME                             
-------------------- ----------------------------------------------------------- -------------------- ---------------------------------------- 
1                    ORA 4031                                                    19539                2014-02-28 17:28:06.832000 +08:00       
1 rows fetched

使用show incident查看错误对哪些方面有影响

adrci> show incident

ADR Home = /u01/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                              
-------------------- ----------------------------------------------------------- ---------------------------------------- 
19449                ORA 4031                                                    2014-02-28 17:23:10.132000 +08:00       
19497                ORA 4031                                                    2014-02-28 17:23:13.665000 +08:00       
19417                ORA 4031                                                    2014-02-28 17:23:15.900000 +08:00       
19537                ORA 4031                                                    2014-02-28 17:23:27.927000 +08:00       
19545                ORA 4031                                                    2014-02-28 17:23:28.135000 +08:00       
5 rows fetched

使用show tracefile -I incident_id得出相关信息

adrci> show tracefile -I 19449
     diag/rdbms/orcl/orcl/incident/incdir_19449/orcl_ora_10475_i19449.trc

执行下面命令获得信息

adrci> show incident -mode detail -p "incident_id=19449"

ADR Home = /u01/oracle/diag/rdbms/orcl/orcl:
*************************************************************************

**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
   INCIDENT_ID                   19449
   STATUS                        ready
   CREATE_TIME                   2014-02-28 17:23:10.132000 +08:00
   PROBLEM_ID                    1
   CLOSE_TIME                    <NULL>
   FLOOD_CONTROLLED              none
   ERROR_FACILITY                ORA
   ERROR_NUMBER                  4031
   ERROR_ARG1                    424
   ERROR_ARG2                    shared pool
   ERROR_ARG3                    select shared_pool_size_for_...
   ERROR_ARG4                    Cursor Stats
   ERROR_ARG5                    kks cstat
   ERROR_ARG6                    <NULL>
   ERROR_ARG7                    <NULL>
   ERROR_ARG8                    <NULL>
   ERROR_ARG9                    <NULL>
   ERROR_ARG10                   <NULL>
   ERROR_ARG11                   <NULL>
   ERROR_ARG12                   <NULL>
   SIGNALLING_COMPONENT          KGH
   SIGNALLING_SUBCOMPONENT       <NULL>
   SUSPECT_COMPONENT             <NULL>
   SUSPECT_SUBCOMPONENT          <NULL>
   ECID                          <NULL>
   IMPACTS                       0
   PROBLEM_KEY                   ORA 4031
   FIRST_INCIDENT                19449
   FIRSTINC_TIME                 2014-02-28 17:23:10.132000 +08:00
   LAST_INCIDENT                 19539
   LASTINC_TIME                  2014-02-28 17:28:06.832000 +08:00
   IMPACT1                       34668547
   IMPACT2                       34668546
   IMPACT3                       0
   IMPACT4                       0
   KEY_NAME                      SID
   KEY_VALUE                     1.7
   KEY_NAME                      ProcId
   KEY_VALUE                     19.3
   KEY_NAME                      PQ
   KEY_VALUE                     (0, 1393579380)
   KEY_NAME                      Client ProcId
   KEY_VALUE                     oracle@oracle11g (TNS V1-V3).10475_1210048
   OWNER_ID                      1
   INCIDENT_FILE                 /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_10475.trc
   OWNER_ID                      1
   INCIDENT_FILE                 /u01/oracle/diag/rdbms/orcl/orcl/incident/incdir_19449/orcl_ora_10475_i19449.trc
1 rows fetched

adrci> 

创建包

adrci> ips create package incident 19449