[20130217]11GR2 adrci的学习.txt
春节放假,学习一下adrci的使用.adrci (Automatic Diagnostic Repository Command Interpreter).
ADRCI: Release 11.2.0.1.0 - Production on Tue Aug 21 16:35:06 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle11g"
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> HELP EXTENDED
HELP [topic]
Available Topics:
BEGIN BACKUP
CD
CREATE STAGING XMLSCHEMA
CREATE VIEW
DDE
DEFINE
DELETE
DESCRIBE
DROP VIEW
END BACKUP
INSERT
LIST DEFINE
MERGE ALERT
MERGE FILE
MIGRATE
QUERY
REPAIR
SELECT
SET COLUMN
SHOW CATALOG
SHOW DUMP
SHOW SECTION
SHOW TRACE
SHOW TRACEMAP
SWEEP
UNDEFINE
UPDATE
VIEW
1.定义别名,便于使用上下键以及历史功能以及设置编辑器,不过我感觉使用rlwrap效果更好.
adrci> set editor vim
--set browser mozilla
2.显示home
adrci> show home
ADR Homes:
diag/tnslsnr/hisdg/listener
diag/rdbms/test/test1
diag/rdbms/test/test
4.设置home:
adrci> set home diag/rdbms/test/test
5.查看alert.log
adrci> show alert -tail -f
adrci> show alert -tail 100 -f
--显示alert*.log的最后100行
6.显示问题problem,show incident
adrci> show problem
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
6 ORA 7445 [qcdlaucn()+201] 112993 2012-09-06 15:59:33.894000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
17 rows fetched
7.显示incident:
adrci> show incident
incident
n.
(政治性)事故; 事变
偶发事件, 小事件
(剧情的)枝节, (小说的)插话;【律】财产所附带的权利[义务]
差错
【数】关联
without incident
平安无事
--可以使用help show problem ,查看帮助。记不住这个单词incident :-)
adrci> show incident
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
123878 ORA 1578 2012-09-14 12:07:51.517000 +08:00
123879 ORA 1578 2012-09-14 12:07:55.899000 +08:00
123880 ORA 1578 2012-09-14 12:08:02.896000 +08:00
123881 ORA 1578 2012-09-14 12:08:15.585000 +08:00
123882 ORA 1578 2012-09-14 12:08:28.882000 +08:00
314580 ORA 600 [18062] 2012-09-28 08:53:19.926000 +08:00
321804 ORA 600 [25027] 2012-09-28 09:51:18.676000 +08:00
321805 ORA 600 [25027] 2012-09-28 09:51:45.021000 +08:00
321806 ORA 600 [25027] 2012-09-28 09:53:02.917000 +08:00
321884 ORA 600 [25027] 2012-09-28 10:30:05.316000 +08:00
321885 ORA 600 [25027] 2012-09-28 10:30:43.402000 +08:00
368586 ORA 1578 2012-10-08 09:40:41.261000 +08:00
368587 ORA 1578 2012-10-08 09:40:45.020000 +08:00
368588 ORA 1578 2012-10-08 09:40:52.570000 +08:00
408189 ORA 1578 2012-10-09 15:29:32.280000 +08:00
408190 ORA 1578 2012-10-09 15:29:34.240000 +08:00
422591 ORA 600 [18062] 2012-10-09 15:52:32.680000 +08:00
444191 ORA 600 [18062] 2012-10-10 15:24:46.238000 +08:00
519791 ORA 1578 2012-10-16 16:34:25.789000 +08:00
519792 ORA 1578 2012-10-16 16:34:27.715000 +08:00
527041 ORA 1578 2012-10-16 16:53:27.971000 +08:00
527042 ORA 1578 2012-10-16 16:53:29.987000 +08:00
527043 ORA 1578 2012-10-16 16:55:00.769000 +08:00
537796 ORA 1578 2012-10-17 08:31:25.789000 +08:00
537797 ORA 1578 2012-10-17 08:31:37.265000 +08:00
537798 ORA 1578 2012-10-17 08:31:53.318000 +08:00
537799 ORA 1578 2012-10-17 08:31:54.925000 +08:00
537800 ORA 1578 2012-10-17 08:32:07.053000 +08:00
563059 ORA 7445 [rpidrv()+670] 2012-10-17 15:51:38.496000 +08:00
663924 ORA 600 [2162] 2012-11-05 11:51:46.058000 +08:00
667413 ORA 600 [2162] 2012-11-05 12:00:56.063000 +08:00
671013 ORA 600 [2162] 2012-11-05 12:01:45.227000 +08:00
678286 ORA 600 [2162] 2012-11-05 14:37:13.509000 +08:00
678287 ORA 600 [2162] 2012-11-05 14:40:20.825000 +08:00
825872 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 2012-11-22 08:06:35.396000 +08:00
861817 ORA 25319 2012-11-23 12:01:37.610000 +08:00
865418 ORA 25319 2012-11-23 12:03:49.730000 +08:00
869019 ORA 25319 2012-11-23 12:08:48.159000 +08:00
905020 ORA 25319 2012-11-23 15:36:29.440000 +08:00
908621 ORA 25319 2012-11-26 10:13:50.136000 +08:00
912222 ORA 25319 2012-11-26 10:14:57.514000 +08:00
912190 ORA 445 2012-11-26 10:19:52.839000 +08:00
912191 ORA 445 2012-11-26 10:19:55.803000 +08:00
912192 ORA 445 2012-11-26 10:22:54.878000 +08:00
912193 ORA 445 2012-11-26 10:23:54.968000 +08:00
912194 ORA 445 2012-11-26 10:24:54.978000 +08:00
912511 ORA 25319 2012-11-26 10:59:53.853000 +08:00
913712 ORA 25319 2012-11-27 09:11:43.331000 +08:00
914913 ORA 25319 2012-11-27 09:14:46.498000 +08:00
914977 ORA 1578 2012-11-27 09:15:03.140000 +08:00
First 50 rows fetched (*** more available ***)
--仅仅显示50行,而且最近的看不见.
adrci> help show incident
Usage: SHOW INCIDENT [-p ]
[-mode BASIC|BRIEF|DETAIL]
[-last | -all]
[-orderby (field1, field2, ...) [ASC|DSC]]
Purpose: Show the incident information. By default, this command will
only show the last 50 incidents which are not flood controlled.
Options:
[-p ]: The predicate string must be double-quoted.
[-mode BASIC|BRIEF|DETAIL]: The different modes of showing incidents.
BASIC will show the basic information of non-flooded controlled
incidents, which is the default mode. In this mode, only the following
fields can be used in the predicate clause:
INCIDENT_ID number
PROBLEM_KEY text(550)
CREATE_TIME timestamp
BRIEF will display incident information from the incident relation.
In this mode, the fields can appear in the predicate are:
INCIDENT_ID number
PROBLEM_ID number
CREATE_TIME timestamp
CLOSE_TIME timestamp
STATUS number
FLAGS number
FLOOD_CONTROLLED number
ERROR_FACILITY text(10)
ERROR_NUMBER number
ERROR_ARG1 text(64)
ERROR_ARG2 text(64)
ERROR_ARG3 text(64)
ERROR_ARG4 text(64)
ERROR_ARG5 text(64)
ERROR_ARG6 text(64)
ERROR_ARG7 text(64)
ERROR_ARG8 text(64)
SIGNALLING_COMPONENT text(64)
SIGNALLING_SUBCOMPONENT text(64)
SUSPECT_COMPONENT text(64)
SUSPECT_SUBCOMPONENT text(64)
ECID text(64)
IMPACT number
DETAIL will display all incident-related information, such as incident
files. The fields can appear in the predicate is the same as the ones
in the brief mode.
[-last | -all]: This option allows users to either select
the last of qualified incidents to show or to show all the
qualified incidents. If this option is not specified, this command
will only show 50 incidents.
[-orderby (field1, field2, ...) [ASC|DSC]]: If specified, the results
will be ordered by the specified fields' values. By default, it will be
in the ascending order unless "DSC" is specified. Note that the field
names that can be specified here are from the "INCIDENT" relation.
Examples:
show incident
show incident -mode detail
show incident -mode detail -p "incident_id=123"
adrci> show incident -last 10
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
123878 ORA 1578 2012-09-14 12:07:51.517000 +08:00
123879 ORA 1578 2012-09-14 12:07:55.899000 +08:00
123880 ORA 1578 2012-09-14 12:08:02.896000 +08:00
123881 ORA 1578 2012-09-14 12:08:15.585000 +08:00
123882 ORA 1578 2012-09-14 12:08:28.882000 +08:00
314580 ORA 600 [18062] 2012-09-28 08:53:19.926000 +08:00
321804 ORA 600 [25027] 2012-09-28 09:51:18.676000 +08:00
321805 ORA 600 [25027] 2012-09-28 09:51:45.021000 +08:00
321806 ORA 600 [25027] 2012-09-28 09:53:02.917000 +08:00
321884 ORA 600 [25027] 2012-09-28 10:30:05.316000 +08:00
First 10 rows fetched (*** more available ***)
adrci> show incident -mode detail -p "incident_id=321804"
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 321804
STATUS ready
CREATE_TIME 2012-09-28 09:51:18.676000 +08:00
PROBLEM_ID 9
CLOSE_TIME
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 600
ERROR_ARG1 25027
ERROR_ARG2 4
ERROR_ARG3 1
ERROR_ARG4
ERROR_ARG5
ERROR_ARG6
ERROR_ARG7
ERROR_ARG8
ERROR_ARG9
ERROR_ARG10
ERROR_ARG11
ERROR_ARG12
SIGNALLING_COMPONENT
SIGNALLING_SUBCOMPONENT
SUSPECT_COMPONENT
SUSPECT_SUBCOMPONENT
ECID
IMPACTS 0
PROBLEM_KEY ORA 600 [25027]
FIRST_INCIDENT 321804
FIRSTINC_TIME 2012-09-28 09:51:18.676000 +08:00
LAST_INCIDENT 321886
LASTINC_TIME 2012-09-28 10:32:07.660000 +08:00
IMPACT1 0
IMPACT2 0
IMPACT3 0
IMPACT4 0
KEY_NAME Client ProcId
KEY_VALUE oracle@hisdg (TNS V1-V3).4078_182918269152
KEY_NAME SID
KEY_VALUE 361.40
KEY_NAME ProcId
KEY_VALUE 22.14
KEY_NAME PQ
KEY_VALUE (0, 1348797078)
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle11g/diag/rdbms/test/test/incident/incdir_321804/test_ora_4078_i321804.trc
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle11g/diag/rdbms/test/test/trace/test_ora_4078.trc
1 rows fetched
8. 建立包或者zip文件,发送给oracle(Creation of Packages & ZIP files to send to Oracle Support)
例子:
adrci> help ips create package
Usage: IPS CREATE PACKAGE
[INCIDENT | PROBLEM | PROBLEMKEY |
SECONDS | TIME TO ]
[CORRELATE BASIC | TYPICAL | ALL]
Purpose: Create a package, and optionally select contents for the package.
Arguments:
: ID of incident to use for selecting package contents.
: ID of problem to use for selecting package contents.
: Problem key to use for selecting package contents.
: Number of seconds before now for selecting package contents.
: Start of time range to look for incidents in.
: End of time range to look for incidents in.
Options:
CORRELATE BASIC: The package will include the incident dumps, and the
incident process trace files.
Additional incidents can be included automatically,
if they share relevant correlation keys.
CORRELATE TYPICAL: The package will include the incident dumps, and all
trace files that were modified in a time window around
each incident.
Additional incidents can be included automatically,
if they share relevant correlation keys, or occurred
in a time window around the main incidents.
CORRELATE ALL: The package will include the incident dumps, and all
trace files that were modified between the first
selected incident and the last selected incident.
Additional incidents can be included automatically,
if they occurred in the same time range.
Notes:
If no package contents are specified (incident, problem, etc), an empty
package will be created. Files and incidents can be added later.
If no correlation level is specified, the default level is used.
The default is normally TYPICAL, but it can be changed using the command
IPS SET CONFIGURATION.
Example:
ips create package incident 861;
ips create package time '2006-12-31 23:59:59.00 -07:00' to
'2007-01-01 01:01:01.00 -07:00';
ips create package problem 9 correlate all
ips create package incident 321805 correlate all
adrci> ips create package problem 9 correlate all
Created package 4 based on problem id 9, correlation level all
adrci> ips create package incident 321805 correlate all
Created package 5 based on incident id 321805, correlation level all
adrci> ips generate package 4 in "/home/oracle11g"
Generated package 4 in file /home/oracle11g/IPSPKG_20130217152553_COM_1.zip, mode complete
$ unzip -t IPSPKG_20130217152553_COM_1.zip
Archive: IPSPKG_20130217152553_COM_1.zip
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_CONFIGURATION.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_INCIDENT.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_FILE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_HISTORY.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_FILE_METADATA.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_FILE_COPY_LOG.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_DEF.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_PARAMETER_DEF.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_PARAMETER.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_INCIDENT_TYPE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_INCIDENT_ACTION_MAP.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCIDENT.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCCKEY.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCIDENT_FILE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/PROBLEM.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/HM_RUN.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/EM_USER_ACTIVITY.dmp OK
testing: diag/rdbms/test/test/alert/log.xml OK
testing: diag/rdbms/test/test/trace/alert_test.log OK
testing: diag/rdbms/test/test/trace/test_lgwr_5731.trc OK
testing: diag/rdbms/test/test/trace/test_lgwr_5731.trm OK
testing: diag/rdbms/test/test/trace/test_vktm_5713.trc OK
testing: diag/rdbms/test/test/trace/test_vktm_5713.trm OK
testing: diag/rdbms/test/test/trace/test_ckpt_5733.trc OK
testing: diag/rdbms/test/test/trace/test_ckpt_5733.trm OK
testing: diag/rdbms/test/test/trace/test_mman_5727.trc OK
testing: diag/rdbms/test/test/trace/test_mman_5727.trm OK
testing: diag/rdbms/test/test/trace/test_ora_5763.trc OK
testing: diag/rdbms/test/test/trace/test_ora_5763.trm OK
testing: diag/rdbms/test/test/trace/test_dbrm_5721.trc OK
testing: diag/rdbms/test/test/trace/test_dbrm_5721.trm OK
testing: diag/rdbms/test/test/trace/test_arc0_5765.trc OK
testing: diag/rdbms/test/test/trace/test_arc0_5765.trm OK
testing: diag/rdbms/test/test/trace/test_arc3_5771.trc OK
testing: diag/rdbms/test/test/trace/test_arc3_5771.trm OK
testing: diag/rdbms/test/test/trace/test_ora_5659.trc OK
testing: diag/rdbms/test/test/trace/test_ora_5659.trm OK
testing: diag/rdbms/test/test/trace/test_j003_5795_local.trc OK
testing: diag/rdbms/test/test/trace/test_j003_5795_local.trm OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/crs/crsdiag.log OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/metadata.xml OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.xml OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.html OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.txt OK
testing: metadata.xml OK
No errors detected in compressed data of IPSPKG_20130217152553_COM_1.zip.
9.维护: Managing, especially purging of tracefiles
adrci> show tracefile -rt
17-FEB-13 15:04:10 diag/rdbms/test/test/trace/test_ckpt_5733.trc
17-FEB-13 14:57:53 diag/rdbms/test/test/trace/alert_test.log
17-FEB-13 14:53:00 diag/rdbms/test/test/trace/test_j003_5795_local.trc
17-FEB-13 14:52:53 diag/rdbms/test/test/trace/test_ora_5763.trc
17-FEB-13 14:52:52 diag/rdbms/test/test/trace/test_dbrm_5721.trc
17-FEB-13 14:52:46 diag/rdbms/test/test/trace/test_mman_5727.trc
17-FEB-13 14:52:45 diag/rdbms/test/test/trace/test_ora_5659.trc
17-FEB-13 14:52:45 diag/rdbms/test/test/trace/test_vktm_5713.trc
07-FEB-13 17:33:55 diag/rdbms/test/test/trace/test_vktm_28511.trc
07-FEB-13 17:33:55 diag/rdbms/test/test/trace/test_ora_32041_local.trc
07-FEB-13 17:15:18 diag/rdbms/test/test/trace/test_ckpt_28533.trc
07-FEB-13 17:00:12 diag/rdbms/test/test/trace/test_lgwr_28529.trc
03-DEC-12 10:53:39 diag/rdbms/test/test/incident/incdir_941461/test_ora_25910_i941461.trc
....
adrci> show control
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2768052777 720 8760 2011-11-22 09:59:56.721852 +08:00 2012-11-09 22:13:03.850799 +08:00 2012-09-10 09:29:17.716986 +08:00 1 2 76 1 2011-11-22 09:59:56.721852 +08:00
1 rows fetched
The ordinary tracefiles will stay for 30 days (720 hours), while files like incident files stay one year (8760 hours) by
default. We can change that policy with for example:
adrci> set control (SHORTP_POLICY = 360)
adrci> set control (LONGP_POLICY = 2190)
adrci> show control
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2768052777 360 2190 2013-02-17 15:29:08.166801 +08:00 2012-11-09 22:13:03.850799 +08:00 2012-09-10 09:29:17.716986 +08:00 1 2 76 1 2011-11-22 09:59:56.721852 +08:00
1 rows fetched
Also, we may want to purge tracefiles manually. Following command will manually purge all tracefiles older than 2 days
(2880 minutes):
adrci> purge -age 1440 -type INCIDENT
adrci> show tracefile -rt
--实际上我们还可以在adric使用sql命令:
adrci> desc problem ;
Name Type NULL?
----------------------------- --------------- -----------
PROBLEM_ID number
PROBLEM_KEY text(550)
FIRST_INCIDENT number
FIRSTINC_TIME timestamp
LAST_INCIDENT number
LASTINC_TIME timestamp
IMPACT1 number
IMPACT2 number
IMPACT3 number
IMPACT4 number
SERVICE_REQUEST text(64)
BUG_NUMBER text(64)
adrci> select PROBLEM_ID,PROBLEM_KEY,LAST_INCIDENT,LASTINC_TIME from problem;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ---------------------------------------------------------------------------------------------------- -------------------- ----------------------------------------
6 ORA 7445 [qcdlaucn()+201] 112993 2012-09-06 15:59:33.894000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
17 rows fetched
adrci> show problem
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
6 ORA 7445 [qcdlaucn()+201] 112993 2012-09-06 15:59:33.894000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
17 rows fetched
-- 仅仅显示的宽度不同.显示没有按照PROBLEM_ID排序吧了.
adrci> column PROBLEM_KEY format a60
DIA-48415: Syntax error found in string [column PROBLEM_KEY ] at column [21]
adrci> help set column
Usage: SET COLUMN TEXT
Purpose: Set the maximum bytes to display for fields with text type.
Arguments:
: The maximum number of bytes to display.
Examples:
set column text 32
--仅仅定义一个,不能真对特定字段.
adrci> set column text 60
adrci> select PROBLEM_ID,PROBLEM_KEY,LAST_INCIDENT,LASTINC_TIME from problem;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ------------------------------------------------------------ -------------------- ----------------------------------------
6 ORA 7445 [qcdlaucn()+201] 112993 2012-09-06 15:59:33.894000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
17 rows fetched
adrci> delete from problem where problem_id=6;
1 Row Deleted
adrci> show problem
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
16 rows fetched
adrci> ips delete package 4;
Deleted package 4
adrci> ips delete package 5;
Deleted package 5
10.还可以使用select,delete 对incident,problem操作。
$ cd /u01/app/oracle11g/diag/rdbms/test/test/metadata/
$ ls -l
total 7560
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:29 ADR_CONTROL.ams
-rw-r----- 1 oracle11g oinstall 40960 Nov 22 2011 ADR_INTERNAL.mif
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 ADR_INVALIDATION.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 AMS_XACTION.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 27 16:18 DDE_USER_ACTION.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 DDE_USER_ACTION_DEF.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 27 16:18 DDE_USER_ACTION_PARAMETER.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 DDE_USER_ACTION_PARAMETER_DEF.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 DDE_USER_INCIDENT_ACTION_MAP.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 DDE_USER_INCIDENT_TYPE.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 EM_DIAG_JOB.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 EM_TARGET_INFO.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 EM_USER_ACTIVITY.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 HM_FDG_SET.ams
-rw-r----- 1 oracle11g oinstall 884736 Dec 5 22:02 HM_FINDING.ams
-rw-r----- 1 oracle11g oinstall 884736 Nov 28 10:31 HM_INFO.ams
-rw-r----- 1 oracle11g oinstall 475136 Nov 28 10:31 HM_MESSAGE.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 9 22:13 HM_RECOMMENDATION.ams
-rw-r----- 1 oracle11g oinstall 1294336 Jan 23 15:32 HM_RUN.ams
-rw-r----- 1 oracle11g oinstall 475136 Dec 3 10:53 INCCKEY.ams
-rw-r----- 1 oracle11g oinstall 475136 Feb 17 14:52 INCIDENT.ams
-rw-r----- 1 oracle11g oinstall 475136 Dec 3 10:53 INCIDENT_FILE.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 14:52 INC_METER_CONFIG.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 INC_METER_IMPT_DEF.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 14:52 INC_METER_INFO.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 INC_METER_PK_IMPTS.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 14:52 INC_METER_SUMMARY.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 IPS_CONFIGURATION.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 IPS_FILE_COPY_LOG.ams
-rw-r----- 1 oracle11g oinstall 475136 Feb 17 15:27 IPS_FILE_METADATA.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:40 IPS_PACKAGE.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:40 IPS_PACKAGE_FILE.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:40 IPS_PACKAGE_HISTORY.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:40 IPS_PACKAGE_INCIDENT.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 IPS_PACKAGE_UNPACK_HISTORY.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 IPS_REMOTE_PACKAGE.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 PICKLEERR.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:39 PROBLEM.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 SWEEPERR.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 VIEW.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 VIEWCOL.ams
--这些基本都可以按照sql命令来操作,例子:
adrci> select * from INCCKEY where rownum
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
INCIDENT_ID FLAGS KEY_NAME KEY_VALUE
-------------------- -------------------- ------------------------------------------------------------ ------------------------------------------------------------
123878 3 SID 13.378
123878 3 ProcId 32.183
123878 7 PQ (16777228, 1347595670)
123878 0 Client ProcId oracle@hisdg (TNS V1-V3).4467_182918269152
123879 3 SID 13.378
123879 3 ProcId 32.183
123879 7 PQ (16777216, 1347595675)
123879 0 Client ProcId oracle@hisdg (TNS V1-V3).4467_182918269152
123883 3 SID 13.378
123883 3 ProcId 32.183
10 rows fetched
--另外你还可以建立自己的视图,例子:
adrci> create view my_control as select SHORTP_POLICY,LONGP_POLICY,LAST_AUTOPRG_TIME,LAST_MANUPRG_TIME from ADR_CONTROL;
View MY_CONTROL Created
adrci> set column text 40
adrci> select * from view;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
OBJ_ID NAME TEXT CREATION_TIME SCOPE VERSION
-------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- --------------------
1 MY_CONTROL select SHORTP_POLICY,LONGP_POLICY,LAST_A 2013-02-17 15:46:32.664944 +08:00 0 1
1 rows fetched
adrci> select * from my_control;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
SHORTP_POLICY LONGP_POLICY LAST_AUTOPRG_TIME LAST_MANUPRG_TIME
-------------------- -------------------- ---------------------------------------- ----------------------------------------
360 2190 2012-11-09 22:13:03.850799 +08:00 2012-09-10 09:29:17.716986 +08:00
1 rows fetched
adrci> drop view my_control ;
View my_control Dropped
11.剩下这些
SHOW HM_RUN
SHOW INCDIR
SHOW REPORT
adrci> set home diag/rdbms/test/test
adrci> show incdir
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
diag/rdbms/test/test/incident/incdir_663924/test_ora_17680_i663924.trc
diag/rdbms/test/test/incident/incdir_422591/test_ora_2186_i422591.trc
diag/rdbms/test/test/incident/incdir_519791/test_ora_20154_i519791.trc
diag/rdbms/test/test/incident/incdir_519791/test_m000_20166_i519791_a.trc
diag/rdbms/test/test/incident/incdir_908621/test_ora_19397_i908621.trc
diag/rdbms/test/test/incident/incdir_321805/test_ora_4078_i321805.trc
diag/rdbms/test/test/incident/incdir_920790/test_ora_26196_i920790.trc
diag/rdbms/test/test/incident/incdir_914979/test_ora_2116_i914979.trc
adrci> SHOW HM_RUN
....
**********************************************************
HM RUN RECORD 3870
**********************************************************
RUN_ID 80541
RUN_NAME HM_RUN_80541
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2013-01-23 15:32:44.400621 +08:00
RESUME_TIME
END_TIME 2013-01-23 15:32:44.475197 +08:00
MODIFIED_TIME 2013-01-23 15:32:44.475197 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE
3870 rows fetched
adrci> set browser mozilla
adrci> SHOW REPORT hm_run HM_RUN_80541
--没有输出,也没有调用mozilla,不知道为什么,也许是 REPORT_FILE=的原因.要使用create repoer建立报告先.
adrci> create report hm_run HM_RUN_80541
adrci> show report hm_run HM_RUN_80541
<?xml version="1.0" encoding="US-ASCII"?>
HM Report: HM_RUN_80541
DB Structure Integrity Check
80541
HM_RUN_80541
REACTIVE
COMPLETED
0
0
0
2013-01-23 15:32:44.400621 +08:00
2013-01-23 15:32:44.475197 +08:00
adrci> show hm_run
...
**********************************************************
HM RUN RECORD 3870
**********************************************************
RUN_ID 80541
RUN_NAME HM_RUN_80541
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2013-01-23 15:32:44.400621 +08:00
RESUME_TIME
END_TIME 2013-01-23 15:32:44.475197 +08:00
MODIFIED_TIME 2013-02-17 16:06:08.290391 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE /u01/app/oracle11g/diag/rdbms/test/test/hm/HMREPORT_HM_RUN_80541.hm
3870 rows fetched
--ok现在REPORT_FILE=/u01/app/oracle11g/diag/rdbms/test/test/hm/HMREPORT_HM_RUN_80541.hm
adrci> set home diag/rdbms/test/test
adrci> select * from hm_run where check_name'DB Structure Integrity Check';
DIA-48415: Syntax error found in string [check_name] at column [12]
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
0 rows fetched
--居然不能这样使用.
adrci> set column text 20
adrci> select * from hm_run where check_name!='DB Structure Integrity Check';
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
RUN_ID RUN_NAME CHECK_NAME NAME_ID MODE START_TIME RESUME_TIME END_TIME MODIFIED_TIME TIMEOUT FLAGS STATUS SRC_INCIDENT_ID NUM_INCIDENTS ERR_NUMBER REPORT_FILE
-------------------- -------------------- -------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -----------
33561 HM_RUN_33561 Data Block Integrity 3 2 2012-09-14 12:07:56.205270 +08:00 2012-09-14 12:07:59.201758 +08:00 2012-09-14 12:07:59.201758 +08:00 0 0 5 123878 0 0
35281 HM_RUN_35281 Data Block Integrity 3 2 2012-10-08 09:40:45.144143 +08:00 2012-10-08 09:40:49.222838 +08:00 2012-10-08 09:40:49.222838 +08:00 0 0 5 368586 0 0
35321 HM_RUN_35321 Data Block Integrity 3 2 2012-10-09 15:29:34.406506 +08:00 2012-10-09 15:29:34.917051 +08:00 2012-10-09 15:29:34.917051 +08:00 0 0 5 408189 0 0
35521 HM_RUN_35521 Data Block Integrity 3 2 2012-10-16 16:34:27.859199 +08:00 2012-10-16 16:34:28.447665 +08:00 2012-10-16 16:34:28.447665 +08:00 0 0 5 519791 0 0
35561 HM_RUN_35561 Data Block Integrity 3 2 2012-10-16 16:53:30.266296 +08:00 2012-10-16 16:53:31.040454 +08:00 2012-10-16 16:53:31.040454 +08:00 0 0 5 527041 0 0
35621 HM_RUN_35621 Data Block Integrity 3 2 2012-10-17 08:31:28.018704 +08:00 2012-10-17 08:31:28.559434 +08:00 2012-10-17 08:31:28.559434 +08:00 0 0 5 537796 0 0
70001 HM_RUN_70001 Data Block Integrity 3 2 2012-11-27 09:15:05.167150 +08:00 2012-11-27 09:15:06.075830 +08:00 2012-11-27 09:15:06.075830 +08:00 0 0 5 914977 0 0
70761 HM_RUN_70761 Data Block Integrity 3 2 2012-11-27 09:58:13.823390 +08:00 2012-11-27 09:58:14.504569 +08:00 2012-11-27 09:58:14.504569 +08:00 0 0 5 916123 0 0
77281 HM_RUN_77281 Data Block Integrity 3 2 2012-11-27 15:39:02.685035 +08:00 2012-11-27 15:39:03.289742 +08:00 2012-11-27 15:39:03.289742 +08:00 0 0 5 918590 0 0
80201 HM_RUN_80201 Redo Integrity Check 4 2 2012-11-28 10:06:45.080614 +08:00 2012-11-28 10:06:46.586871 +08:00 2012-11-28 10:06:46.586871 +08:00 0 0 5 923369 0 0
80221 HM_RUN_80221 Redo Integrity Check 4 2 2012-11-28 10:08:39.827099 +08:00 2012-11-28 10:08:41.225542 +08:00 2012-11-28 10:08:41.225542 +08:00 0 0 5 923370 0 0
11 rows fetched
总结:
其实adrci很好用,并没有想象的这么难!