Friday, December 30, 2016

Oracle database, Identify problem/issue from alert file

//find out ADR_HOME location
select * from V$DIAG_INFO;
//go in ADR Home
//run below command on command prompt
adrci
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

No comments:

Post a Comment