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
Copyright (c) 1982, 2007, Oracle. All rights reserved.
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
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 basic -p "INCIDENT_ID=193020"
ADR Home = /opt/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
193020 ORA 4031 2013-04-02 21:27:53.230146 +08:00
1 rows fetched
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
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> 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
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> 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
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> help ips incremental
DIA-48433: Unknown help topic
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
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
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
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
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
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
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
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
PARAMETER INFORMATION:
PARAMETER_ID 6
NAME DEFAULT_CORRELATION_LEVEL
DESCRIPTION Default correlation level for packages
UNIT Number
VALUE 2
DEFAULT_VALUE 2
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
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
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
adrci> show 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
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> set configuration
DIA-48470: Unknown "SET" command
adrci> ips set configuration
DIA-48415: Syntax error found in string [ips set configuration
] at column [22]
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
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
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
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
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
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
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
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
PARAMETER INFORMATION:
PARAMETER_ID 6
NAME DEFAULT_CORRELATION_LEVEL
DESCRIPTION Default correlation level for packages
UNIT Number
VALUE 2
DEFAULT_VALUE 2
----------------------------------------------------------
**********************************************************
IPS CONFIGURATION PARAMETER
**********************************************************
----------------------------------------------------------
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> exit
oracle@oracle:~> sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 5月 28 22:01:12 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
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
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "/opt/oracle"
adrci>
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
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
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 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