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