oracle 之ADR(AUTOMATIC DIAGNOSTIC REPOSITORY)

最新推荐文章于 2021-04-08 04:21:43 发布

Rhys-Oracle

最新推荐文章于 2021-04-08 04:21:43 发布

阅读量2.1k

点赞数

分类专栏： ORACLE 之 error 诊断

本文链接：https://blog.csdn.net/rhys_oracle/article/details/8986807

版权

ORACLE 之 error 诊断专栏收录该内容

35 篇文章 0 订阅

订阅专栏

oracle 之ADR(AUTOMATIC DIAGNOSTIC REPOSITORY)

oracle@oracle:~> adrci -help
Syntax:
   adrci [-help] [script=script_filename] 
         [exec = "one_command [;one_command;...]"]

Options      Description                     (Default)
-----------------------------------------------------------------
script       script file name                (None)           
help         help on the command options     (None)           
exec         exec a set of commands          (None)           
-----------------------------------------------------------------
oracle@oracle:~> adrci exec='show homes;show incident';
ADR Homes: 
diag/rdbms/orcl/orcl
diag/rdbms/dummy/orcl
diag/rdbms/orcl01/ORCL01
diag/rdbms/orcl01/orcl01
diag/tnslsnr/oracle/listener
diag/tnslsnr/oracle/listener01
diag/clients/user_unknown/host_411310321_11
diag/clients/user_oracle/host_2310821773_11

ADR Home = /opt/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                              
-------------------- ----------------------------------------------------------- ---------------------------------------- 
258380               KUP 600                                                     2013-05-09 22:33:26.149065 +08:00       
193203               ORA 4031                                                    2013-04-02 21:27:53.805370 +08:00       
193099               ORA 4031                                                    2013-04-02 21:27:42.048063 +08:00       
193021               ORA 4031                                                    2013-04-02 21:27:56.587413 +08:00       
193020               ORA 4031                                                    2013-04-02 21:27:53.230146 +08:00       
193019               ORA 4031                                                    2013-04-02 21:27:41.712141 +08:00       
6 rows fetched

oracle@oracle:~> adrci exec='set homepath diag/rdbms/orcl/orcl;set editor vi;show alert -V';
DIA-48415: Syntax error found in string [show alert -V] at column [13]

oracle@oracle:~> adrci exec="set homepath diag/rdbms/orcl/orcl;set editor vi;show alert -V"
DIA-48415: Syntax error found in string [show alert -V] at column [13]

oracle@oracle:~> adrci exec="set homepath diag/rdbms/orcl/orcl;set editor vi;"
oracle@oracle:~> adrci

ADRCI: Release 11.1.0.6.0 - Beta on 星期二 5月 28 20:53:29 2013

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

ADR base = "/opt/oracle"
adrci> set homepath diag/rdbms/orcl/orcl
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 show alert

  Usage: SHOW ALERT [-p <predicate_string>]  [-term]
                    [ [-tail [num] [-f]] | [-file <alert_file_name>] ]
  Purpose: Show alert messages.

  Options:
    [-p <predicate_string>]: The predicate string must be double quoted.
    The fields in the predicate are the fields:
        ORIGINATING_TIMESTAMP         timestamp
        NORMALIZED_TIMESTAMP          timestamp
        ORGANIZATION_ID               text(65)
        COMPONENT_ID                  text(65)
        HOST_ID                       text(65)
        HOST_ADDRESS                  text(17)
        MESSAGE_TYPE                  number
        MESSAGE_LEVEL                 number
        MESSAGE_ID                    text(65)
        MESSAGE_GROUP                 text(65)
        CLIENT_ID                     text(65)
        MODULE_ID                     text(65)
        PROCESS_ID                    text(33)
        THREAD_ID                     text(65)
        USER_ID                       text(65)
        INSTANCE_ID                   text(65)
        DETAILED_LOCATION             text(161)
        UPSTREAM_COMP_ID              text(101)
        DOWNSTREAM_COMP_ID            text(101)
        EXECUTION_CONTEXT_ID          text(101)
        EXECUTION_CONTEXT_SEQUENCE    number
        ERROR_INSTANCE_ID             number
        ERROR_INSTANCE_SEQUENCE       number
        MESSAGE_TEXT                  text(2049)
        MESSAGE_ARGUMENTS             text(129)
        SUPPLEMENTAL_ATTRIBUTES       text(129)
        SUPPLEMENTAL_DETAILS          text(129)
        PROBLEM_KEY                   text(65)

    [-tail [num] [-f]]: Output last part of the alert messages and 
    output latest messages as the alert log grows. If num is not specified, 
    the last 10 messages are displayed. If "-f" is specified, new data
    will append at the end as new alert messages are generated.

    [-term]: Direct results to terminal. If this option is not specified,
    the results will be open in an editor. 
    By default, it will open in emacs, but "set editor" can be used
    to set other editors.

    [-file <alert_file_name>]: Allow users to specify an alert file which 
    may not be in ADR. <alert_file_name> must be specified with full path.
    Note that this option cannot be used with the -tail option

  Examples:  
    show alert 
    show alert -p "message_text like '%incident%'"
    show alert -tail 20

adrci> exit
oracle@oracle:~> adrci exec="set homepath diag/rdbms/orcl/orcl;set editor vi;show alert"

ADR Home = /opt/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
DIA-48216: Field Len Exceeds Max Field Length [5] [0] [20] [20]

oracle@oracle:~> adrci

ADRCI: Release 11.1.0.6.0 - Beta on 星期二 5月 28 20:54:30 2013

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

ADR base = "/opt/oracle"
adrci> set homepath diag/rdbms/orcl/orcl
adrci> show alert

ADR Home = /opt/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
DIA-48216: Field Len Exceeds Max Field Length [5] [0] [20] [20]

adrci> show home
ADR Homes: 
diag/rdbms/orcl/orcl
adrci> exit
oracle@oracle:~> adrci exec="show homes"
ADR Homes: 
diag/rdbms/orcl/orcl
diag/rdbms/dummy/orcl
diag/rdbms/orcl01/ORCL01
diag/rdbms/orcl01/orcl01
diag/tnslsnr/oracle/listener
diag/tnslsnr/oracle/listener01
diag/clients/user_unknown/host_411310321_11
diag/clients/user_oracle/host_2310821773_11
oracle@oracle:~> adrci exec='set home diag/rdbms/orcl01/ORCL01;set editor vi;show alert'

ADR Home = /opt/oracle/diag/rdbms/orcl01/ORCL01:
*************************************************************************
Output the results to file: /tmp/alert_7818_47210_ORCL01_1.ado
2013-03-20 22:18:23.172000 +08:00
Starting ORACLE instance (normal)
2013-03-20 22:18:24.436000 +08:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
2013-03-20 22:18:25.562000 +08:00
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/product/10.2/db_1/dbs/arch
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
2013-03-20 22:18:28.698000 +08:00
LICENSE_MAX_USERS = 0
SYS auditing is disabled
2013-03-20 22:18:30.354000 +08:00
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in client-side pfile /opt/oracle/admin/ORCL01/pfile/init.ora on machine oracle
System parameters with non-default values:
  processes                = 150
  sga_target               = 300M
  control_files            = "/opt/oracle/oradata/ORCL01/ORCL01/control01.ctl"
  control_files            = "/opt/oracle/oradata/ORCL01/ORCL01/control02.ctl"
  control_files            = "/opt/oracle/oradata/ORCL01/ORCL01/control03.ctl"
  db_block_size            = 8192
  compatible               = "11.1.0.0.0"
  db_recovery_file_dest    = "/opt/oracle/ORCL01/flash_recovery_area"
  db_recovery_file_dest_size= 2G
  undo_tablespace          = "UNDOTBS1"
oracle@oracle:~> adrci <<EOF
> SET HOME diag/rdbms/orcl01/ORCL01
> SHOW ALERT -TAIL 20
> EOF

ADRCI: Release 11.1.0.6.0 - Beta on 星期二 5月 28 20:56:36 2013

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

ADR base = "/opt/oracle"
adrci> adrci> 2013-03-21 01:34:09.560000 +08:00
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
Opening with internal Resource Manager plan
2013-03-21 01:34:10.672000 +08:00
Starting background process FBDA
Starting background process SMCO
SMCO started with pid=20, OS id=22892 
FBDA started with pid=19, OS id=22890 
2013-03-21 01:34:12.992000 +08:00
replication_dependency_tracking turned off (no async multimaster replication found)
2013-03-21 01:34:14.228000 +08:00
Starting background process QMNC
QMNC started with pid=22, OS id=22897 
2013-03-21 01:34:24.775000 +08:00
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
2013-03-21 01:35:13.740000 +08:00
Completed: ALTER DATABASE OPEN
2013-03-21 01:35:34.445000 +08:00
Starting background process CJQ0
CJQ0 started with pid=30, OS id=23000 
2013-03-21 01:39:09.074000 +08:00
Thread 1 advanced to log sequence 56
  Current log# 2 seq# 56 mem# 0: /opt/oracle/oradata/ORCL01/ORCL01/redo02.log
2013-03-21 01:49:53.837000 +08:00


***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:
TNS for Linux: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.6.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.6.0 - Production
  Time: 21-3月 -2013 01:49:54
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
    
2013-03-21 01:49:55.277000 +08:00
TNS-12535: TNS: 操作超时
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=33227))
WARNING: inbound connection timed out (ORA-3136)
2013-03-21 02:22:52.917000 +08:00
Shutting down instance (abort)
License high water mark = 21
2013-03-21 02:22:54.238000 +08:00
USER (ospid: 29068): terminating the instance
2013-03-21 02:22:55.419000 +08:00
Instance terminated by USER, pid = 29068
Instance shutdown complete
adrci> oracle@oracle:~> ADRCI
bash: ADRCI: command not found
oracle@oracle:~> adrci

ADRCI: Release 11.1.0.6.0 - Beta on 星期二 5月 28 20:56:57 2013

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

ADR base = "/opt/oracle"
adrci> show base
ADR base is "/opt/oracle"
adrci> show homepath
ADR Homes: 
diag/rdbms/orcl/orcl
diag/rdbms/dummy/orcl
diag/rdbms/orcl01/ORCL01
diag/rdbms/orcl01/orcl01
diag/tnslsnr/oracle/listener
diag/tnslsnr/oracle/listener01
diag/clients/user_unknown/host_411310321_11
diag/clients/user_oracle/host_2310821773_11
adrci> show tracefile
     diag/rdbms/orcl/orcl/trace/orcl_fbda_6563.trc
     diag/rdbms/orcl/orcl/trace/alert_orcl.log
     diag/rdbms/orcl/orcl/trace/orcl_mmon_6434.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_7054.trc
     diag/rdbms/orcl/orcl/trace/orcl_arc2_6556.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_7165.trc
     diag/rdbms/orcl/orcl/trace/orcl_j002_6762.trc
     diag/rdbms/orcl/orcl/trace/orcl_cjq0_6752.trc
     diag/rdbms/orcl/orcl/trace/orcl_dbrm_6414.trc
     diag/rdbms/orcl/orcl/trace/orcl_ora_6486.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_7301.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_6779.trc
     diag/rdbms/orcl/orcl/trace/orcl_m002_7173.trc
     diag/rdbms/orcl/orcl/incident/incdir_193019/orcl_mmon_5136_i193019.trc
     diag/rdbms/orcl/orcl/incident/incdir_193020/orcl_mmon_5136_i193020.trc
     diag/rdbms/orcl/orcl/incident/incdir_193021/orcl_mmon_5136_i193021.trc
     diag/rdbms/orcl/orcl/incident/incdir_193099/orcl_ora_5162_i193099.trc
     diag/rdbms/orcl/orcl/incident/incdir_193203/orcl_m000_5254_i193203.trc
     diag/rdbms/orcl/orcl/incident/incdir_258380/orcl_ora_18226_i258380.trc
     diag/rdbms/dummy/orcl/trace/orcl_ora_6166.trc
     diag/rdbms/dummy/orcl/trace/alert_orcl.log
     diag/rdbms/dummy/orcl/trace/orcl_ora_6308.trc
     diag/rdbms/dummy/orcl/trace/orcl_vktm_5265.trc
     diag/rdbms/dummy/orcl/trace/orcl_ora_5260.trc
     diag/rdbms/dummy/orcl/trace/orcl_ora_5298.trc
     diag/rdbms/dummy/orcl/trace/orcl_vktm_6035.trc
     diag/rdbms/dummy/orcl/trace/orcl_ora_6029.trc
     diag/rdbms/dummy/orcl/trace/orcl_ora_6105.trc
     diag/rdbms/dummy/orcl/trace/orcl_vktm_6171.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_m000_21254.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_22821.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_18829.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_22841.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_20308.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_29068.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_22882.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_18876.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_22888.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_mmon_22872.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_19499.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_m000_27703.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_20388.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_18929.trc
     diag/rdbms/orcl01/ORCL01/trace/alert_ORCL01.log
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_m000_22760.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_vktm_22846.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_vktm_18838.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_m000_20339.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_m003_27792.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_ora_21251.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_m000_20468.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_m000_19610.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_dbrm_22852.trc
     diag/rdbms/orcl01/ORCL01/trace/ORCL01_m002_27773.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_14539.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_dbrm_551.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_441.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_pmon_26295.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_25318.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_vktm_24300.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_25532.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_15927.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_fbda_5345.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m002_6719.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_13449.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_14043.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_8971.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_615.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_15330.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_mmnl_5330.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_25637.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_vktm_26297.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m001_11806.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_26254.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_fbda_26342.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_j001_13171.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_32645.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_7771.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_25019.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_14829.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_9657.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_cjq0_5401.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_24981.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_24294.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m001_8260.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_mmon_5328.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_j004_26575.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_13632.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_11775.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m001_8985.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_24334.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_25634.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m001_13169.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_vktm_544.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_24383.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_7239.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_w000_8967.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_26281.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_26291.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_5411.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_vktm_5302.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_dbrm_26304.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_q001_5357.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_26332.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_26339.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_10692.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_13144.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_26591.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_dbrm_5308.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m003_13004.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m001_16499.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_10722.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_13185.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_25152.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_5296.trc
     diag/rdbms/orcl01/orcl01/trace/alert_orcl01.log
     diag/rdbms/orcl01/orcl01/trace/orcl01_smon_5324.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m001_10243.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_11356.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m001_6705.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_ora_5341.trc
     diag/rdbms/orcl01/orcl01/trace/orcl01_m000_8767.trc
     diag/tnslsnr/oracle/listener/trace/ora_6079_46915655062352.trc
     diag/tnslsnr/oracle/listener/trace/listener.log
     diag/tnslsnr/oracle/listener01/trace/listener01.log
     diag/clients/user_unknown/host_411310321_11/trace/sqlnet.log
     diag/clients/user_oracle/host_2310821773_11/trace/sqlnet.log
adrci> show home
ADR Homes: 
diag/rdbms/orcl/orcl
diag/rdbms/dummy/orcl
diag/rdbms/orcl01/ORCL01
diag/rdbms/orcl01/orcl01
diag/tnslsnr/oracle/listener
diag/tnslsnr/oracle/listener01
diag/clients/user_unknown/host_411310321_11
diag/clients/user_oracle/host_2310821773_11
adrci> set home diag/tnslsnr/oracle/listener01
adrci> show homepath
ADR Homes: 
diag/tnslsnr/oracle/listener01
adrci> show home
ADR Homes: 
diag/tnslsnr/oracle/listener01
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 show tracefile

  Usage: SHOW TRACEFILE [file1 file2 ...] [-rt | -t] 
                        [-i inc1 inc2 ...] [-path path1 path2 ...] 

  Purpose: List the qualified trace filenames.
  Options: 
    [file1 file2 ...]: The trace files users are interested in to search.
    If "-i" or/and "-path" is specified, the trace files are assumed
    to be under the specified incidents or paths. Otherwise, the files 
    will be searched among the trace directory and all incident directories
    of the current ADR homes. Filenames allow SQL like condition syntax.
    I.e., allowing wildcard search on filenames by using "%". For example,
    "%mmon%" means all trace files with the "mmon" substring.

    [-rt | -t]: Order the trace filenames. "-t" means in the modified 
    timestamps order; "-rt" means in the reversed modified timestamps
    order. Note that the ordering is only apply to a single directory.
    [-i inc1 inc2 ...]: The trace files produced for the listed incidents.
    If no files are listed, all trace files produced for the list 
    incidents are considered.

    [-path path1 path2 ...]: The trace files under the given paths will be 
    queried. If no files are listed, all trace files under these paths 
    are considered.

  Examples:  
    1. Show all the trace files under the current home
       "show tracefile"
    2. Show all the mmon trace files in time reverse order
       "show tracefile %mmon% -rt"
    3. Show all trace files under incidents 123 456, and /home/someone/temp
       "show tracefile -i 123 456 -path  /home/someone/temp" 

adrci> show home
ADR Homes: 
diag/tnslsnr/oracle/listener01
adrci> show alert

ADR Home = /opt/oracle/diag/tnslsnr/oracle/listener01:
*************************************************************************
Output the results to file: /tmp/alert_7827_47333_listener01_1.ado
2013-03-20 22:14:13.121000 +08:00
Create Relation ADR_CONTROL
Create Relation INC_METER_IMPT_DEF
Create Relation INC_METER_PK_IMPTS
脧碌脥鲁虏脦脢媒脦脛录镁脦陋/opt/oracle/product/10.2/db_1/network/admin/listener.ora
脨麓脠毛/opt/oracle/diag/tnslsnr/oracle/listener01/alert/log.xml碌脛脠脮脰戮脨脜脧垄
脨麓脠毛/opt/oracle/diag/tnslsnr/oracle/listener01/trace/ora_18377_47249265849168.trc碌脛赂煤脳脵脨脜脧垄
赂煤脳脵录露卤冒碌卤脟掳脦陋0

脪脭 pid=18377 驴陋脢录
录脿脤媒: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
录脿脤媒: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oracle)(PORT=2484)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
2013-03-20 22:14:14.272000 +08:00
WARNING: Subscription for node down event still pending

20-3脭脗 -2013 22:14:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=oracle)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTadrci> help show alert

  Usage: SHOW ALERT [-p <predicate_string>]  [-term]
                    [ [-tail [num] [-f]] | [-file <alert_file_name>] ]
  Purpose: Show alert messages.

  Options:
    [-p <predicate_string>]: The predicate string must be double quoted.
    The fields in the predicate are the fields:
        ORIGINATING_TIMESTAMP         timestamp
        NORMALIZED_TIMESTAMP          timestamp
        ORGANIZATION_ID               text(65)
        COMPONENT_ID                  text(65)
        HOST_ID                       text(65)
        HOST_ADDRESS                  text(17)
        MESSAGE_TYPE                  number
        MESSAGE_LEVEL                 number
        MESSAGE_ID                    text(65)
        MESSAGE_GROUP                 text(65)
        CLIENT_ID                     text(65)
        MODULE_ID                     text(65)
        PROCESS_ID                    text(33)
        THREAD_ID                     text(65)
        USER_ID                       text(65)
        INSTANCE_ID                   text(65)
        DETAILED_LOCATION             text(161)
        UPSTREAM_COMP_ID              text(101)
        DOWNSTREAM_COMP_ID            text(101)
        EXECUTION_CONTEXT_ID          text(101)
        EXECUTION_CONTEXT_SEQUENCE    number
        ERROR_INSTANCE_ID             number
        ERROR_INSTANCE_SEQUENCE       number
        MESSAGE_TEXT                  text(2049)
        MESSAGE_ARGUMENTS             text(129)
        SUPPLEMENTAL_ATTRIBUTES       text(129)
        SUPPLEMENTAL_DETAILS          text(129)
        PROBLEM_KEY                   text(65)

    [-tail [num] [-f]]: Output last part of the alert messages and 
    output latest messages as the alert log grows. If num is not specified, 
    the last 10 messages are displayed. If "-f" is specified, new data
    will append at the end as new alert messages are generated.

    [-term]: Direct results to terminal. If this option is not specified,
    the results will be open in an editor. 
    By default, it will open in emacs, but "set editor" can be used
    to set other editors.

    [-file <alert_file_name>]: Allow users to specify an alert file which 
    may not be in ADR. <alert_file_name> must be specified with full path.
    Note that this option cannot be used with the -tail option

  Examples:  
    show alert 
    show alert -p "message_text like '%incident%'"
    show alert -tail 20

adrci> show alert -tail 20
2013-03-21 02:22:32.894000 +08:00
21-3月 -2013 02:22:32 * service_update * ORCL01 * 0
2013-03-21 02:22:55.245000 +08:00
21-3月 -2013 02:22:54 * service_died * ORCL01 * 12537
2013-03-21 02:22:57.821000 +08:00
21-3月 -2013 02:22:57 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29776)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
21-3月 -2013 02:22:58 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29777)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:22:59.182000 +08:00
21-3月 -2013 02:22:59 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29778)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:23:06.227000 +08:00
21-3月 -2013 02:23:06 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29780)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:23:07.674000 +08:00
21-3月 -2013 02:23:07 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29781)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:23:08.900000 +08:00
21-3月 -2013 02:23:08 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29782)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:23:28.801000 +08:00
21-3月 -2013 02:23:28 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29788)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
21-3月 -2013 02:23:29 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29789)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
21-3月 -2013 02:23:29 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29790)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:23:32.839000 +08:00
21-3月 -2013 02:23:32 * service_update * orcl * 0
21-3月 -2013 02:23:33 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29792)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:23:33.821000 +08:00
21-3月 -2013 02:23:33 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29793)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:23:41.846000 +08:00
21-3月 -2013 02:23:41 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29794)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:24:05.185000 +08:00
21-3月 -2013 02:24:05 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29798)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:24:22.905000 +08:00
21-3月 -2013 02:24:22 * service_update * orcl * 0
2013-03-21 02:24:41.786000 +08:00
21-3月 -2013 02:24:41 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29804)) * establish * ORCL01 * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
2013-03-21 02:25:05.941000 +08:00
21-3月 -2013 02:25:05 * (CONNECT_DATA=(SID=ORCL01)(CID=(PROGRAM=emagent)(HOST=oracle)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.4)(PORT=29811)) * establish * ORCL01 * 12505
2013-03-21 02:25:06.975000 +08:00
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
adrci> show alert -p "message_text like '%ORA%' 
adrci> help spool
adrci> help
adrci> show home
adrci> exit
adrci> q
adrci> exit
adrci> exit
adrci> ?
adrci> help
adrci> host;
adrci> exit
adrci> 
adrci> 
adrci> 

adrci> 
adrci> 
adrci> 
adrci> 
adrci> 
adrci> 
adrci> exit
adrci> exit
adrci> 
adrci> 
adrci>

oracle@oracle:~> adrci

ADRCI: Release 11.1.0.6.0 - Beta on 星期二 5月 28 21:35:19 2013

ADR base = "/opt/oracle"
adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl
diag/rdbms/dummy/orcl
diag/rdbms/orcl01/ORCL01
diag/rdbms/orcl01/orcl01
diag/tnslsnr/oracle/listener
diag/tnslsnr/oracle/listener01
diag/clients/user_unknown/host_411310321_11
diag/clients/user_oracle/host_2310821773_11
adrci> set home diag/rdbms/orcl/orcl
adrci> help show alert

Usage: SHOW ALERT [-p <predicate_string>] [-term]
[ [-tail [num] [-f]] | [-file <alert_file_name>] ]
Purpose: Show alert messages.

Options:
    [-p <predicate_string>]: The predicate string must be double quoted.
    The fields in the predicate are the fields:
        ORIGINATING_TIMESTAMP         timestamp
        NORMALIZED_TIMESTAMP          timestamp
        ORGANIZATION_ID               text(65)
        COMPONENT_ID                  text(65)
        HOST_ID                       text(65)
        HOST_ADDRESS                  text(17)
        MESSAGE_TYPE                  number
        MESSAGE_LEVEL                 number
        MESSAGE_ID                    text(65)
        MESSAGE_GROUP                 text(65)
        CLIENT_ID                     text(65)
        MODULE_ID                     text(65)
        PROCESS_ID                    text(33)
        THREAD_ID                     text(65)
        USER_ID                       text(65)
        INSTANCE_ID                   text(65)
        DETAILED_LOCATION             text(161)
        UPSTREAM_COMP_ID              text(101)
        DOWNSTREAM_COMP_ID            text(101)
        EXECUTION_CONTEXT_ID          text(101)
        EXECUTION_CONTEXT_SEQUENCE    number
        ERROR_INSTANCE_ID             number
        ERROR_INSTANCE_SEQUENCE       number
        MESSAGE_TEXT                  text(2049)
        MESSAGE_ARGUMENTS             text(129)
        SUPPLEMENTAL_ATTRIBUTES       text(129)
        SUPPLEMENTAL_DETAILS          text(129)
        PROBLEM_KEY                   text(65)

    [-tail [num] [-f]]: Output last part of the alert messages and
    output latest messages as the alert log grows. If num is not specified,
    the last 10 messages are displayed. If "-f" is specified, new data
    will append at the end as new alert messages are generated.

    [-term]: Direct results to terminal. If this option is not specified,
    the results will be open in an editor.
    By default, it will open in emacs, but "set editor" can be used
    to set other editors.

    [-file <alert_file_name>]: Allow users to specify an alert file which
    may not be in ADR. <alert_file_name> must be specified with full path.
    Note that this option cannot be used with the -tail option

Examples:
    show alert
    show alert -p "message_text like '%incident%'"
    show alert -tail 20

adrci> spool /opt/oracle/adrci.log
adrci> show alert -tail 20
2013-05-27 22:11:47.701000 +08:00
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
2013-05-27 22:11:51.866000 +08:00
Database Characterset is AL32UTF8
2013-05-27 22:11:56.475000 +08:00
Opening with Resource Manager plan: DEFAULT_MAINTENANCE_PLAN
2013-05-27 22:12:08.281000 +08:00
Starting background process FBDA
2013-05-27 22:12:10.058000 +08:00
Starting background process SMCO
FBDA started with pid=31, OS id=6563
2013-05-27 22:12:17.928000 +08:00
SMCO started with pid=32, OS id=6565
2013-05-27 22:12:27.230000 +08:00
replication_dependency_tracking turned off (no async multimaster replication found)
2013-05-27 22:12:42.887000 +08:00
Starting background process QMNC
2013-05-27 22:12:45.268000 +08:00
QMNC started with pid=34, OS id=6569
2013-05-27 22:14:54.746000 +08:00
Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_6486.trc:
ORA-04098: 瑙﹀彂鍣YS.TR_EMP' 鏃犳晥涓旀湭閫氳繃閲嶆柊楠岃瘉
2013-05-27 22:14:55.888000 +08:00
Completed: alter database open
2013-05-27 22:18:53.536000 +08:00
Starting background process CJQ0
CJQ0 started with pid=37, OS id=6752
2013-05-27 22:19:00.370000 +08:00
Setting Resource Manager plan SCHEDULER[0x2C09]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2013-05-27 22:19:33.559000 +08:00
Mon May 27 22:19:33 2013
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 4657446
2013-05-27 22:20:24.145000 +08:00
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2013-05-27 22:21:24.380000 +08:00
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2013-05-27 22:51:20.851000 +08:00
Beginning log switch checkpoint up to RBA [0x60.2.10], SCN: 4672336
Thread 1 advanced to log sequence 96
Current log# 3 seq# 96 mem# 0: /opt/oracle/oradata/ORCL/onlinelog/o1_mf_3_8np02j56_.log
Current log# 3 seq# 96 mem# 1: /opt/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_3_8np02l6x_.log
2013-05-27 22:56:27.354000 +08:00
Completed checkpoint up to RBA [0x60.2.10], SCN: 4672336
2013-05-28 19:50:47.606000 +08:00
Clearing Resource Manager plan via parameter
adrci> spool off
adrci> !
DIA-48415: Syntax error found in string [!
] at column [2]

adrci> host
oracle@oracle:~> ls -ltr
total 12619
drwxr-xr-x 3 oracle oinstall       72 2012-03-27 01:27 product
drwxr-x--- 5 oracle oinstall      120 2012-03-27 02:11 cfgtoollogs
drwxr-xr-x 2 oracle oinstall       48 2012-03-30 01:21 Desktop
drwx------ 2 oracle oinstall      120 2012-03-30 01:21 Documents
drwxr-x--- 3 oracle oinstall       72 2012-03-30 02:42 flash_recovery_area
drwxr-xr-x 2 oracle oinstall      112 2012-05-18 23:27 bak
-rw-r--r-- 1 oracle oinstall       72 2012-07-29 09:02 xiaohai.sql
drwxr-xr-x 2 oracle oinstall       80 2013-02-26 20:46 xiaohai
drwxr-x--- 2 oracle oinstall      368 2013-03-20 22:04 arch_log
drwxr-x--- 3 oracle oinstall       88 2013-03-20 22:17 ORCL01
-rw-r----- 1 oracle oinstall   260468 2013-03-21 01:28 install2013-03-21_00-47-48.log
drwxr-x--- 3 oracle oinstall       80 2013-03-21 12:21 ora_bak_test
drwxr-x--- 2 oracle oinstall       80 2013-03-21 13:24 redo_bak
-rw-r----- 1 oracle oinstall     5472 2013-03-21 20:58 pfile.bak
drwxr-x--- 2 oracle oinstall       48 2013-03-27 22:05 oradata_test
-rw-r----- 1 oracle oinstall    42644 2013-03-28 21:48 hello.lst
-rw-r----- 1 oracle oinstall    42644 2013-03-28 21:53 ll.lst
drwxrwxr-x 11 oracle oinstall      264 2013-03-31 19:43 diag
-rw-r----- 1 oracle oinstall      202 2013-04-03 23:42 mybook.sql
-rw-r----- 1 oracle oinstall      191 2013-04-03 23:58 mybook4.sql
-rw-r----- 1 oracle oinstall      117 2013-04-05 11:09 books_01.sql
drwxr-x--- 3 oracle oinstall       72 2013-04-05 15:15 orabak
-rw-r----- 1 oracle oinstall      346 2013-04-15 20:39 index.sql
-rw-r----- 1 oracle oinstall      197 2013-04-15 21:11 cursor.sql
-rw-r----- 1 oracle oinstall      277 2013-04-15 22:46 update.sql
-rw-r----- 1 oracle oinstall      326 2013-04-15 23:46 a.sql
-rw-r----- 1 oracle oinstall      218 2013-04-16 22:56 de.sql
-rw-r----- 1 oracle oinstall      638 2013-04-16 23:14 w.sql
-rw-r----- 1 oracle oinstall      356 2013-04-16 23:18 as.sql
drwxr-x--- 5 oracle oinstall      120 2013-04-21 11:56 admin
-rw-r----- 1 oracle oinstall   260468 2013-04-21 14:29 install2013-04-21_14-11-18.log
-rw-r----- 1 oracle oinstall    16384 2013-05-01 14:24 expdat.dmp
-rw-r----- 1 oracle oinstall   114688 2013-05-01 14:29 SCOTT_TABLES.dmp
drwxr-xr-x 2 oracle oinstall      224 2013-05-04 21:26 test
-rw-r----- 1 oracle oinstall      125 2013-05-04 22:02 test.sql
-rw-r----- 1 oracle oinstall     5612 2013-05-08 21:41 pfile.ora
-rw-r----- 1 oracle oinstall   191868 2013-05-09 21:33 sequence.txt
-rw-r----- 1 oracle oinstall      236 2013-05-09 23:09 csdn.sql
drwxr-x--- 6 oracle oinstall      320 2013-05-18 12:14 oradata
-rw-r----- 1 oracle oinstall      104 2013-05-26 20:58 p.sql
-rw-r----- 1 oracle oinstall   266303 2013-05-28 20:22 oci245501_20130528201949_COM_1.zip
-rw-r----- 1 oracle oinstall    16655 2013-05-28 21:17 adr.log
-rw-r----- 1 oracle oinstall 11600384 2013-05-28 21:35 block_tracking.log
-rw-r----- 1 oracle oinstall     2235 2013-05-28 21:35 adrci.log
oracle@oracle:~> exit
exit
adrci> show tracefile
     diag/rdbms/orcl/orcl/trace/orcl_fbda_6563.trc
     diag/rdbms/orcl/orcl/trace/alert_orcl.log
     diag/rdbms/orcl/orcl/trace/orcl_mmon_6434.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_7054.trc
     diag/rdbms/orcl/orcl/trace/orcl_arc2_6556.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_7840.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_7165.trc
     diag/rdbms/orcl/orcl/trace/orcl_j002_6762.trc
     diag/rdbms/orcl/orcl/trace/orcl_cjq0_6752.trc
     diag/rdbms/orcl/orcl/trace/orcl_dbrm_6414.trc
     diag/rdbms/orcl/orcl/trace/orcl_ora_6486.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_7301.trc
     diag/rdbms/orcl/orcl/trace/orcl_m000_6779.trc
     diag/rdbms/orcl/orcl/trace/orcl_m002_7173.trc
     diag/rdbms/orcl/orcl/trace/orcl_d000_6438.trc
     diag/rdbms/orcl/orcl/incident/incdir_193019/orcl_mmon_5136_i193019.trc
     diag/rdbms/orcl/orcl/incident/incdir_193020/orcl_mmon_5136_i193020.trc
     diag/rdbms/orcl/orcl/incident/incdir_193021/orcl_mmon_5136_i193021.trc
     diag/rdbms/orcl/orcl/incident/incdir_193099/orcl_ora_5162_i193099.trc
     diag/rdbms/orcl/orcl/incident/incdir_193203/orcl_m000_5254_i193203.trc
     diag/rdbms/orcl/orcl/incident/incdir_258380/orcl_ora_18226_i258380.trc
adrci> show incident

ADR Home = /opt/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
258380               KUP 600                                                     2013-05-09 22:33:26.149065 +08:00
193203               ORA 4031                                                    2013-04-02 21:27:53.805370 +08:00
193099               ORA 4031                                                    2013-04-02 21:27:42.048063 +08:00
193021               ORA 4031                                                    2013-04-02 21:27:56.587413 +08:00
193020               ORA 4031                                                    2013-04-02 21:27:53.230146 +08:00
193019               ORA 4031                                                    2013-04-02 21:27:41.712141 +08:00
6 rows fetched

adrci> show incident -mode detail -p "INCIDENT_ID=258380"

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

**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
   INCIDENT_ID                   258380
   STATUS                        ready
   CREATE_TIME                   2013-05-09 22:33:26.149065 +08:00
   PROBLEM_ID                    2
   CLOSE_TIME                    <NULL>
   FLOOD_CONTROLLED              none
   ERROR_FACILITY                KUP
   ERROR_NUMBER                  600
   ERROR_ARG1                    kudmcxgg:grfunc
   ERROR_ARG2                    <NULL>
   ERROR_ARG3                    <NULL>
   ERROR_ARG4                    <NULL>
   ERROR_ARG5                    <NULL>
   ERROR_ARG6                    <NULL>
   ERROR_ARG7                    <NULL>
   ERROR_ARG8                    <NULL>
   SIGNALLING_COMPONENT          <NULL>
   SIGNALLING_SUBCOMPONENT       <NULL>
   SUSPECT_COMPONENT             <NULL>
   SUSPECT_SUBCOMPONENT          <NULL>
   ECID                          <NULL>
   IMPACTS                       0
   PROBLEM_KEY                   KUP 600
   FIRST_INCIDENT                258380
   FIRSTINC_TIME                 2013-05-09 22:33:26.149065 +08:00
   LAST_INCIDENT                 258380
   LASTINC_TIME                  2013-05-09 22:33:26.149065 +08:00
   IMPACT1                       0
   IMPACT2                       0
   IMPACT3                       0
   IMPACT4                       0
   KEY_NAME                      ProcId
   KEY_VALUE                     34.7
   KEY_NAME                      Client ProcId
   KEY_VALUE                     oracle@oracle (TNS V1-V3).18226_47430875598432
   KEY_NAME                      SID
   KEY_VALUE                     122.18
   KEY_NAME                      PQ
   KEY_VALUE                     (16777216, 1368110004)
   OWNER_ID                      1
   INCIDENT_FILE                 /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_18226.trc
   OWNER_ID                      1
   INCIDENT_FILE                 /opt/oracle/diag/rdbms/orcl/orcl/incident/incdir_258380/orcl_ora_18226_i258380.trc
1 rows fetched

adrci> describe incident
Name                          Type            NULL?
----------------------------- --------------- -----------
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
adrci> help show incident

Usage: SHOW INCIDENT [-p <predicate_string>]
                       [-mode BASIC|BRIEF|DETAIL]
                       [-last <num> | -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 <predicate_string>]: 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 <num> | -all]: This option allows users to either select
    the last <num> 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 -mode BASIC

adrci> show incident -mode basic -p "INCIDENT_ID=193020"

adrci> show incident -mode brief -p ""INCIDENT_ID=193020"
DIA-48415: Syntax error found in string [show incident -mode brief -p ""] at column [31]

adrci> show incident -mode brief -p "incident_id=193020"

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

**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
   INCIDENT_ID                   193020
   STATUS                        ready
   CREATE_TIME                   2013-04-02 21:27:53.230146 +08:00
   PROBLEM_ID                    1
   CLOSE_TIME                    <NULL>
   FLOOD_CONTROLLED              none
   ERROR_FACILITY                ORA
   ERROR_NUMBER                  4031
   ERROR_ARG1                    32
   ERROR_ARG2                    shared pool
   ERROR_ARG3                    select snap_interval, retent...
   ERROR_ARG4                    sql area
   ERROR_ARG5                    tmp
   ERROR_ARG6                    <NULL>
   ERROR_ARG7                    <NULL>
   ERROR_ARG8                    <NULL>
   SIGNALLING_COMPONENT          KGH
   SIGNALLING_SUBCOMPONENT       <NULL>
   SUSPECT_COMPONENT             <NULL>
   SUSPECT_SUBCOMPONENT          <NULL>
   ECID                          <NULL>
   IMPACTS                       0
1 rows fetched

adrci> ips create package
Created package 1 without any contents, correlation level typical
adrci> show incident

adrci> ips add incident package 1
DIA-48415: Syntax error found in string [ips add incident package] at column [24]
DIA-48438: [package] is not a valid number

adrci> ips add incident 193099 package 1
Added incident 193099 to package 1
adrci> ips add incident 193019 package 1
Added incident 193019 to package 1
adrci> ips generate package
DIA-49401: Illegal input argument [2]

adrci> ips generate package 1
Generated package 1 in file ././IPSPKG_20130528214539_COM_1.zip, mode complete
adrci> ips generate package 1 in /opt/oracle/oradate
DIA-49428: No such directory or directory not accessible [/opt/oracle/oradate]

adrci> host
oracle@oracle:~> mkdir test
mkdir: cannot create directory `test': File exists
oracle@oracle:~> exit
exit
adrci> ips generate package 1 in /opt/oracle/test
Generated package 1 in file /opt/oracle/test/IPSPKG_20130528214539_COM_2.zip, mode complete
adrci> host
oracle@oracle:~> pwd
/opt/oracle
oracle@oracle:~> ls -ltr
total 16146
drwxr-xr-x 3 oracle oinstall       72 2012-03-27 01:27 product
drwxr-x--- 5 oracle oinstall      120 2012-03-27 02:11 cfgtoollogs
drwxr-xr-x 2 oracle oinstall       48 2012-03-30 01:21 Desktop
drwx------ 2 oracle oinstall      120 2012-03-30 01:21 Documents
drwxr-x--- 3 oracle oinstall       72 2012-03-30 02:42 flash_recovery_area
drwxr-xr-x 2 oracle oinstall      112 2012-05-18 23:27 bak
-rw-r--r-- 1 oracle oinstall       72 2012-07-29 09:02 xiaohai.sql
drwxr-xr-x 2 oracle oinstall       80 2013-02-26 20:46 xiaohai
drwxr-x--- 2 oracle oinstall      368 2013-03-20 22:04 arch_log
drwxr-x--- 3 oracle oinstall       88 2013-03-20 22:17 ORCL01
-rw-r----- 1 oracle oinstall   260468 2013-03-21 01:28 install2013-03-21_00-47-48.log
drwxr-x--- 3 oracle oinstall       80 2013-03-21 12:21 ora_bak_test
drwxr-x--- 2 oracle oinstall       80 2013-03-21 13:24 redo_bak
-rw-r----- 1 oracle oinstall     5472 2013-03-21 20:58 pfile.bak
drwxr-x--- 2 oracle oinstall       48 2013-03-27 22:05 oradata_test
-rw-r----- 1 oracle oinstall    42644 2013-03-28 21:48 hello.lst
-rw-r----- 1 oracle oinstall    42644 2013-03-28 21:53 ll.lst
drwxrwxr-x 11 oracle oinstall      264 2013-03-31 19:43 diag
-rw-r----- 1 oracle oinstall      202 2013-04-03 23:42 mybook.sql
-rw-r----- 1 oracle oinstall      191 2013-04-03 23:58 mybook4.sql
-rw-r----- 1 oracle oinstall      117 2013-04-05 11:09 books_01.sql
drwxr-x--- 3 oracle oinstall       72 2013-04-05 15:15 orabak
-rw-r----- 1 oracle oinstall      346 2013-04-15 20:39 index.sql
-rw-r----- 1 oracle oinstall      197 2013-04-15 21:11 cursor.sql
-rw-r----- 1 oracle oinstall      277 2013-04-15 22:46 update.sql
-rw-r----- 1 oracle oinstall      326 2013-04-15 23:46 a.sql
-rw-r----- 1 oracle oinstall      218 2013-04-16 22:56 de.sql
-rw-r----- 1 oracle oinstall      638 2013-04-16 23:14 w.sql
-rw-r----- 1 oracle oinstall      356 2013-04-16 23:18 as.sql
drwxr-x--- 5 oracle oinstall      120 2013-04-21 11:56 admin
-rw-r----- 1 oracle oinstall   260468 2013-04-21 14:29 install2013-04-21_14-11-18.log
-rw-r----- 1 oracle oinstall    16384 2013-05-01 14:24 expdat.dmp
-rw-r----- 1 oracle oinstall   114688 2013-05-01 14:29 SCOTT_TABLES.dmp
-rw-r----- 1 oracle oinstall      125 2013-05-04 22:02 test.sql
-rw-r----- 1 oracle oinstall     5612 2013-05-08 21:41 pfile.ora
-rw-r----- 1 oracle oinstall   191868 2013-05-09 21:33 sequence.txt
-rw-r----- 1 oracle oinstall      236 2013-05-09 23:09 csdn.sql
drwxr-x--- 6 oracle oinstall      320 2013-05-18 12:14 oradata
-rw-r----- 1 oracle oinstall      104 2013-05-26 20:58 p.sql
-rw-r----- 1 oracle oinstall   266303 2013-05-28 20:22 oci245501_20130528201949_COM_1.zip
-rw-r----- 1 oracle oinstall    16655 2013-05-28 21:17 adr.log
-rw-r----- 1 oracle oinstall     2235 2013-05-28 21:35 adrci.log
-rw-r----- 1 oracle oinstall 3604927 2013-05-28 21:48 IPSPKG_20130528214539_COM_1.zip
-rw-r----- 1 oracle oinstall 11600384 2013-05-28 21:48 block_tracking.log
drwxr-xr-x 2 oracle oinstall      272 2013-05-28 21:49 test
oracle@oracle:~> cd test
oracle@oracle:~/test> ls -ltr
total 110512
-rw-r--r-- 1 oracle oinstall        83 2012-05-17 00:12 test.sql
-rw-r--r-- 1 oracle oinstall       410 2012-05-17 00:53 test2.sql
-rw-r--r-- 1 oracle oinstall       337 2012-05-17 01:02 test3.sql
-rw-r----- 1 oracle oinstall       209 2013-02-26 21:02 getsp.sql
-rw-r----- 1 oracle oinstall        43 2013-04-02 22:48 point.sql
-rw-r----- 1 oracle oinstall 109404160 2013-04-05 15:00 full.dmp
-rw-r----- 1 oracle oinstall   3628745 2013-05-28 21:49 IPSPKG_20130528214539_COM_2.zip
oracle@oracle:~/test> exit
exit
adrci>
adrci> help ips generate
DIA-48415: Syntax error found in string [help ips generate
] at column [18]

adrci> help ips

HELP IPS [topic]
   Available Topics:
        ADD
        ADD FILE
        ADD NEW INCIDENTS
        CHECK REMOTE KEYS
        COPY IN FILE
        COPY OUT FILE
        CREATE PACKAGE
        DELETE PACKAGE
        FINALIZE PACKAGE
        GENERATE PACKAGE
        GET MANIFEST
        GET METADATA
        GET REMOTE KEYS
        PACK
        REMOVE
        REMOVE FILE
        SET CONFIGURATION
        SHOW CONFIGURATION
        SHOW FILES
        SHOW INCIDENTS
        UNPACK FILE
        USE REMOTE KEYS
adrci> show incident

adrci> ips add incremental incident 193203 package 1
DIA-48415: Syntax error found in string [ips add incremental] at column [19]

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 ips

adrci> show problem

ADR Home = /opt/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
2                    KUP 600                                                     258380               2013-05-09 22:33:26.149065 +08:00
1                    ORA 4031                                                    193021               2013-04-02 21:27:56.587413 +08:00
2 rows fetched

adrci> ips show configuration
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************

----------------------------------------------------------
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

----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************

----------------------------------------------------------
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

----------------------------------------------------------
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

----------------------------------------------------------
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

----------------------------------------------------------
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

----------------------------------------------------------
PARAMETER INFORMATION:
   PARAMETER_ID                   6
   NAME                           DEFAULT_CORRELATION_LEVEL
   DESCRIPTION                    Default correlation level for packages
   UNIT                           Number
   VALUE                          2
   DEFAULT_VALUE                  2

----------------------------------------------------------
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

----------------------------------------------------------
adrci> ips set configuration
DIA-48415: Syntax error found in string [ips set configuration
] at column [22]

adrci> ips set CONFIGURATION
DIA-48415: Syntax error found in string [ips set CONFIGURATION
] at column [23]

adrci> help set configuration
DIA-48433: Unknown help topic

adrci> help

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

adrci> show ips
DIA-48415: Syntax error found in string [show ips] at column [8]

adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl
adrci>
adrci> help ips

adrci> ips set configuration
DIA-48415: Syntax error found in string [ips set configuration
] at column [22]

adrci> ips show configuration
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************

----------------------------------------------------------
adrci> exit
oracle@oracle:~> sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 5月 28 22:01:12 2013

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@orcl#select * from dba_hist_wr_control;

DBID
----------
SNAP_INTERVAL
---------------------------------------------------------------------------
RETENTION
---------------------------------------------------------------------------
TOPNSQL
--------------------
1307032085
+00000 01:00:00.0
+00008 00:00:00.0
DEFAULT

SYS@orcl#exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
oracle@oracle:~> adrci

ADRCI: Release 11.1.0.6.0 - Beta on 星期二 5月 28 22:04:25 2013

ADR base = "/opt/oracle"
adrci>
adrci> show problem

ADR Home = /opt/oracle/diag/clients/user_oracle/host_2310821773_11:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 oci 24550 [11] 65 2013-04-21 19:52:49.247867 +08:00
1 rows fetched

adrci> set home /opt/oracle/diag/rdbms/orcl/orcl
DIA-48447: The input path [/opt/oracle/diag/rdbms/orcl/orcl] does not contain any ADR homes

adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl
diag/rdbms/dummy/orcl
diag/rdbms/orcl01/ORCL01
diag/rdbms/orcl01/orcl01
diag/tnslsnr/oracle/listener
diag/tnslsnr/oracle/listener01
diag/clients/user_unknown/host_411310321_11
diag/clients/user_oracle/host_2310821773_11
adrci> set home diag/rdbms/orcl/orcl
adrci> show problem

adrci> ips create package problem 1
Created package 2 based on problem id 1, correlation level typical
adrci> ips generate package 2 in /opt/oracle/test
Generated package 2 in file /opt/oracle/test/ORA4031_20130528220545_COM_1.zip, mode complete
adrci> exit
oracle@oracle:~> cd test
oracle@oracle:~/test> ls -ltr
total 114039
-rw-r--r-- 1 oracle oinstall        83 2012-05-17 00:12 test.sql
-rw-r--r-- 1 oracle oinstall       410 2012-05-17 00:53 test2.sql
-rw-r--r-- 1 oracle oinstall       337 2012-05-17 01:02 test3.sql
-rw-r----- 1 oracle oinstall       209 2013-02-26 21:02 getsp.sql
-rw-r----- 1 oracle oinstall        43 2013-04-02 22:48 point.sql
-rw-r----- 1 oracle oinstall 109404160 2013-04-05 15:00 full.dmp
-rw-r----- 1 oracle oinstall   3628745 2013-05-28 21:49 IPSPKG_20130528214539_COM_2.zip
-rw-r----- 1 oracle oinstall   3605606 2013-05-28 22:06 ORA4031_20130528220545_COM_1.zip

Rhys-Oracle

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle 之ADR(AUTOMATIC DIAGNOSTIC REPOSITORY)

oracle 之ADR(AUTOMATIC DIAGNOSTIC REPOSITORY)oracle@oracle:~> adrci -helpSyntax: adrci [-help] [script=script_filename] [exec = "one_command [;one_command;...]"]Options Descripti
复制链接

扫一扫