//find out ADR_HOME location
select * from V$DIAG_INFO;
//go in ADR Home
//run below command on command prompt
//run below command on command prompt
adrci
show home
show problem
//show problem list out all the incidents
show home
show problem
//show problem list out all the incidents
*************************************************************************
PROBLEM_ID
PROBLEM_KEY
LAST_INCIDENT
LASTINC_TIME
--------------------
-----------------------------------------------------------
-------------------- ----------------------------------------
3
ORA 600
[17286]
144063
2016-09-02 15:51:41.613000 +05:30
4
ORA 600 [16607]
134097
2016-09-03 15:44:39.985000 +05:30
5
ORA 7445
[kkxcrc()+945]
134287
2016-09-15 21:32:25.985000 +05:30
2
ORA 600
[kqldafl1]
170213
2016-10-20 12:12:21.930000 +05:30
1
ORA 600
[17023]
170214
2016-10-20 12:12:23.936000 +05:30
6
ORA 600
[kghfrf1]
230937
2016-12-07
17:12:48.040000 +05:30
6 rows fetched
//find out a particular incident
show incident -p "problem_key='ORA 1578'"
//pack incident detail so that these information can be sent to oracle support
ips pack incident 18147 in /tmp
ips pack incident 18147 in /tmp
