//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
 
No comments:
Post a Comment