[oracle@db01 ~]$ adrci
ADRCI: Release 11.2.0.4.0 - Production on Mon Feb 29 10:16:09 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/PROD/db/11.2.0/admin/PROD_erpdb"
adrci> show home
ADR Homes:
diag/tnslsnr/erpdb01/prod
diag/rdbms/prod/PROD
diag/rdbms/prod/PROD1
adrci> set homepath diag/rdbms/prod/PROD1
adrci> show problem
ADR Home = /u01/PROD/db/tech_st/11.2.0/diag/rdbms/prod/PROD1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 7445 [qmxtr2MrkOpn()+739] 1167897 2014-03-15 21:01:07.948000 +08:00
3 ORA 7445 [opifch2()+9234] 1361151 2015-06-16 06:01:40.771000 +08:00
2 ORA 3137 [3149] 1488185 2016-01-25 17:22:10.304000 +08:00
5 ORA 7445 [sltskyg()+23] 1489281 2016-01-28 16:37:06.498000 +08:00
6 ORA 7445 [nsopenfree_nsntx()+215] 1490889 2016-02-25 15:51:59.144000 +08:00
4 ORA 7445 [nsclose()+272] 1486993 2016-02-26 10:54:03.322000 +08:00
6 rows fetched
adrci> show incident -p "problem_key='ORA 7445'"
ADR Home = /u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb/diag/rdbms/prod/PROD1:
*************************************************************************
0 rows fetched
adrci> show incident -p "problem_key='ORA 7445 [nsclose()+272]'"
ADR Home = /u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb/diag/rdbms/prod/PROD1:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
1488097 ORA 7445 [nsclose()+272] 2016-01-25 09:13:07.908000 +08:00
1488073 ORA 7445 [nsclose()+272] 2016-01-25 10:45:24.707000 +08:00
1490217 ORA 7445 [nsclose()+272] 2016-01-26 15:41:22.480000 +08:00
1488009 ORA 7445 [nsclose()+272] 2016-01-28 20:00:33.018000 +08:00
1487169 ORA 7445 [nsclose()+272] 2016-02-19 10:11:22.970000 +08:00
1486993 ORA 7445 [nsclose()+272] 2016-02-26 10:54:03.322000 +08:00
6 rows fetched
adrci> ips pack incident 1486993 in /tmp
Generated package 1 in file /tmp/ORA7445ns_20160229102129_COM_1.zip, mode complete
adrci>
概述参考:http://blog.csdn.net/eviswang/article/details/50236053
mos参考: