`
longgangbai
  • 浏览: 7377820 次
  • 性别: Icon_minigender_1
  • 来自: 上海
社区版块
存档分类
最新评论

Oracle 问题诊断工具ADRCI(ADRCI: ADR Command Interpreter)

 
阅读更多
ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database 11g. ADRCI enables you to:

View diagnostic data within the Automatic Diagnostic Repository (ADR).


View Health Monitor reports.


Package incident and problem information into a zip file for transmission to Oracle Support.

Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more.
ADR data is secured by operating system permissions on the ADR directories, hence there is no need to log in to ADRCI.
ADRCI has a rich command set, and can be used in interactive mode or within scripts.
 
 
<WEBDB2>$adrci

ADRCI: Release 11.1.0.7.0 - Production on Mon Oct 17 17:36:25 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ADR base = "/u01/app/oracle/product/11.1.0/db_1"
adrci> help

HELP [topic]
   Available Topics:
        CREATE REPORT
        ECHO
        EXIT
        HELP
        HOST
        IPS
        PURGE
        RUN
        SET BASE
        SET BROWSER
        SET CONTROL
        SET ECHO
        SET EDITOR
        SET HOMES | HOME | HOMEPATH
        SET TERMOUT
        SHOW ALERT
        SHOW BASE
        SHOW CONTROL
        SHOW HM_RUN
        SHOW HOMES | HOME | HOMEPATH
        SHOW INCDIR
        SHOW INCIDENT
        SHOW PROBLEM
        SHOW REPORT
        SHOW TRACEFILE
        SPOOL

There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list

adrci> show base
ADR base is "/u01/app/oracle/product/11.1.0/db_1"
adrci> show control 

ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME                            LAST_AUTOPRG_TIME                        LAST_MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION      ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME                             
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
3545744540           720                  8760                 2011-04-06 18:59:03.590638 +08:00        2011-10-11 08:07:11.574095 +08:00                                                 1                    2                    65                   1                    2011-04-06 18:59:03.590638 +08:00      
1 rows fetched

adrci> show hm_run

ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************

**********************************************************
HM RUN RECORD 1
**********************************************************
   RUN_ID                        1
   RUN_NAME                      HM_RUN_1
   CHECK_NAME                    DB Structure Integrity Check
   NAME_ID                       2
   MODE                          2
   START_TIME                    2011-04-06 19:17:51.312986 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2011-04-06 19:17:51.675983 +08:00
   MODIFIED_TIME                 2011-04-06 19:17:51.675983 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>

**********************************************************
HM RUN RECORD 2
**********************************************************
   RUN_ID                        41
   RUN_NAME                      HM_RUN_41
   CHECK_NAME                    DB Structure Integrity Check
   NAME_ID                       2
   MODE                          2
   START_TIME                    2011-04-06 19:39:27.010743 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2011-04-06 19:39:27.032734 +08:00
   MODIFIED_TIME                 2011-04-06 19:39:27.032734 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>

**********************************************************
HM RUN RECORD 3
**********************************************************
   RUN_ID                        61
   RUN_NAME                      HM_RUN_61
   CHECK_NAME                    DB Structure Integrity Check
   NAME_ID                       2
   MODE                          2
   START_TIME                    2011-04-06 19:42:13.069254 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2011-04-06 19:42:13.091718 +08:00
   MODIFIED_TIME                 2011-04-06 19:42:13.091718 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>

**********************************************************
HM RUN RECORD 4
**********************************************************
   RUN_ID                        81
   RUN_NAME                      HM_RUN_81
   CHECK_NAME                    DB Structure Integrity Check
   NAME_ID                       2
   MODE                          2
   START_TIME                    2011-04-06 19:45:41.549000 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2011-04-06 19:45:41.571990 +08:00
   MODIFIED_TIME                 2011-04-06 19:45:41.571990 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>

**********************************************************
HM RUN RECORD 5
**********************************************************
   RUN_ID                        101
   RUN_NAME                      HM_RUN_101
   CHECK_NAME                    DB Structure Integrity Check
   NAME_ID                       2
   MODE                          2
   START_TIME                    2011-04-06 19:48:36.347418 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2011-04-06 19:48:36.370444 +08:00
   MODIFIED_TIME                 2011-04-06 19:48:36.370444 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>

**********************************************************
HM RUN RECORD 6
**********************************************************
   RUN_ID                        201
   RUN_NAME                      HM_RUN_201
   CHECK_NAME                    DB Structure Integrity Check
   NAME_ID                       2
   MODE                          2
   START_TIME                    2011-10-05 10:00:02.241269 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2011-10-05 10:00:02.382005 +08:00
   MODIFIED_TIME                 2011-10-05 10:00:02.382005 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   <NULL>
6 rows fetched


adrci> show homepath
ADR Homes:
diag/rdbms/ticket/ticket
adrci> show homes
ADR Homes:
diag/rdbms/ticket/ticket
adrci> show incdir

ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
adrci> show incident

ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
0 rows fetched

adrci> show problem

ADR Home = /u01/app/oracle/product/11.1.0/db_1/diag/rdbms/ticket/ticket:
*************************************************************************
0 rows fetched
adrci> ips show files
adrci> ips pack
Generated package 1 in file /home/oracle/IPSPKG_20111017174127_COM_1.zip, mode complete
adrci> ips show configuration
PARAMETER INFORMATION:
   PARAMETER_ID                   1
   NAME                           CUTOFF_TIME
   DESCRIPTION                    Maximum age for an incident to be considered for inclusion
   UNIT                           Days
   VALUE                          90
   DEFAULT_VALUE                  90
   MINIMUM                        1
   MAXIMUM                        4294967295
   FLAGS                          0

PARAMETER INFORMATION:
   PARAMETER_ID                   2
   NAME                           NUM_EARLY_INCIDENTS
   DESCRIPTION                    How many incidents to get in the early part of the range
   UNIT                           Number
   VALUE                          3
   DEFAULT_VALUE                  3
   MINIMUM                        1
   MAXIMUM                        4294967295
   FLAGS                          0

PARAMETER INFORMATION:
   PARAMETER_ID                   3
   NAME                           NUM_LATE_INCIDENTS
   DESCRIPTION                    How many incidents to get in the late part of the range
   UNIT                           Number
   VALUE                          3
   DEFAULT_VALUE                  3
   MINIMUM                        1
   MAXIMUM                        4294967295
   FLAGS                          0

PARAMETER INFORMATION:
   PARAMETER_ID                   4
   NAME                           INCIDENT_TIME_WINDOW
   DESCRIPTION                    Incidents this close to each other are considered correlated
   UNIT                           Minutes
   VALUE                          5
   DEFAULT_VALUE                  5
   MINIMUM                        1
   MAXIMUM                        4294967295
   FLAGS                          0

PARAMETER INFORMATION:
   PARAMETER_ID                   5
   NAME                           PACKAGE_TIME_WINDOW
   DESCRIPTION                    Time window for content inclusion is from x hours before first included incident to x hours after last incident
   UNIT                           Hours
   VALUE                          24
   DEFAULT_VALUE                  24
   MINIMUM                        1
   MAXIMUM                        4294967295
   FLAGS                          0

PARAMETER INFORMATION:
   PARAMETER_ID                   6
   NAME                           DEFAULT_CORRELATION_LEVEL
   DESCRIPTION                    Default correlation level for packages
   UNIT                           Number
   VALUE                          2
   DEFAULT_VALUE                  2
   MINIMUM                        1
   MAXIMUM                        4
   FLAGS                          0

PARAMETER INFORMATION:
   PARAMETER_ID                   7
   NAME                           PURGE_ENABLED
   DESCRIPTION                    If automatic purging is allowed for the IPS schema
   UNIT                           Number
   VALUE                          1
   DEFAULT_VALUE                  1
   MINIMUM                        0
   MAXIMUM                        1
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   8
   NAME                           MAX_FILE_SIZE
   DESCRIPTION                    Maximum size for included files
   UNIT                           Bytes
   VALUE                          2097152000
   DEFAULT_VALUE                  2097152000
   MINIMUM                        1
   MAXIMUM                        2097152000
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   9
   NAME                           MAX_ARCHIVE_SIZE
   DESCRIPTION                    Maximum size for a physical file
   UNIT                           Bytes
   VALUE                          2097152000
   DEFAULT_VALUE                  2097152000
   MINIMUM                        1
   MAXIMUM                        2097152000
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   10
   NAME                           MAX_METADATA_SIZE
   DESCRIPTION                    Maximum size for metadata in a physical file
   UNIT                           Bytes
   VALUE                          209715200
   DEFAULT_VALUE                  209715200
   MINIMUM                        1
   MAXIMUM                        2097152000
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   11
   NAME                           MAX_SPLIT_SEQS
   DESCRIPTION                    Maximum number of sequences for split package
   UNIT                           Number
   VALUE                          5
   DEFAULT_VALUE                  5
   MINIMUM                        1
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   12
   NAME                           MAX_METADATA_SEQS
   DESCRIPTION                    Maximum number of sequences for split package
   UNIT                           Number
   VALUE                          1
   DEFAULT_VALUE                  1
   MINIMUM                        0
   MAXIMUM                        1
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   13
   NAME                           DISABLE_COMPONENT
   DESCRIPTION                    Disable IPS callbacks for specified components
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   14
   NAME                           DISABLE_CALLBACKS_AMI
   DESCRIPTION                    Disable specified callbacks for component AMI
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   15
   NAME                           DISABLE_CALLBACKS_IPS
   DESCRIPTION                    Disable specified callbacks for component IPS
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   16
   NAME                           DISABLE_CALLBACKS_DDE
   DESCRIPTION                    Disable specified callbacks for component DDE
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   17
   NAME                           DISABLE_CALLBACKS_HM
   DESCRIPTION                    Disable specified callbacks for component HM
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   18
   NAME                           DISABLE_CALLBACKS_EM
   DESCRIPTION                    Disable specified callbacks for component EM
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   19
   NAME                           DISABLE_CALLBACKS_GC
   DESCRIPTION                    Disable specified callbacks for component GC
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   20
   NAME                           DISABLE_CALLBACKS_CRS
   DESCRIPTION                    Disable specified callbacks for component CRS
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   21
   NAME                           DISABLE_CALLBACKS_OCM
   DESCRIPTION                    Disable specified callbacks for component OCM
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   22
   NAME                           DISABLE_CALLBACKS_RDA
   DESCRIPTION                    Disable specified callbacks for component RDA
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1

PARAMETER INFORMATION:
   PARAMETER_ID                   23
   NAME                           DISABLE_CALLBACKS_OSS
   DESCRIPTION                    Disable specified callbacks for component OSS
   UNIT                           Number
   VALUE                          0
   DEFAULT_VALUE                  0
   MINIMUM                        0
   MAXIMUM                        4294967295
   FLAGS                          1
查看alert log
adrci> show alert

分享到:
评论

相关推荐

    oracle11g 中adrci的使用

    Oracle 11g 中的 ADRCI(Automatic Diagnostic Repository Command Interpreter)是一种命令行工具,用于查看和管理 Oracle 数据库的诊断日志和跟踪信息。ADRCI 工具可以帮助 DBA 快速了解数据库的健康状况,对问题...

    Oracle 11g自动诊断信息库(Automatic Diagnostic Repository,ADR)概述

    通过ADR的命令行接口ADRCI (Automatic Diagnostic Repository Command Interpreter),管理员可以方便地管理这些诊断信息。例如,可以设置控制策略来决定不同类型的文件保留多久,如上面示例中的SHORTP_POLICY和LONGP...

    Oracle11g_新特性及常用维护工具详解

    - **2.2.3 ADR Command Interpreter(ADRCI)介绍及使用** ADRCI是一个命令行工具,用于管理和查询自动诊断存储库(Automatic Diagnostic Repository, ADR)中的日志和跟踪文件。它可以用来查看数据库的健康状况、定位...

    instantclient-11-2

    6. **adrci.exe**: ADRCI (Automatic Diagnostic Repository Command Interpreter) 是Oracle的一个命令行工具,用于诊断和性能监控。它提供了对自动诊断存储库(ADR)的访问,可以用来查看错误报告、收集诊断信息以及...

    Oracle11g_新特性及常用维护工具详解.pdf

    **2.2.3 ADR Command Interpreter (ADRCI) 介绍及使用** ADRCI 是一个命令行工具,用于管理 ADR。它支持多种命令,如查看诊断信息、生成诊断报告等。 **2.3 Oracle11g 逻辑备份和恢复** **2.3.1 DataPump 导出** ...

    oracle 11g的警告日志和监听日志的删除方法

    为了查看警告日志,可以使用Oracle的ADR Command Interpreter (adrci) 工具。在命令行输入`adrci`启动工具,然后使用`show alert`命令来查看日志。根据提示选择要查看的目录(1 for `diag/rdbms/db1/db1`,2 for `...

Global site tag (gtag.js) - Google Analytics