Home » RDBMS Server » Server Administration » DIAGNOSTIC PROBLEMS (Oracle 12c OEM)
DIAGNOSTIC PROBLEMS [message #652475] Thu, 09 June 2016 14:26 Go to next message
krish96
Messages: 70
Registered: October 2012
Member
Hello All,

Our database daily checks shows DIAGNOSTIC PROBLEMS from ADRCI> and i tried to delete using purge command as below

ADRCI>purge -i (incident number)

and it has been removed incident files from the server physically.. now still when i use this command ADRCI>show problem those incidents where still appearing on daily checks..

EMOMS: DIAGNOSTIC PROBLEMS
ADR Home = /oracle/.../.../..../.../servers/EMGC_OMS1/adr/diag/ofm/EMGC_DOMAIN/EMOMS:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
1 DFW-99998 [java.lang.RuntimeException][oracle.sysman.core.c 1 2016-04-28 14:52:48.615000 -04:00
2 DFW-99999 [EMGC_OMS1][oracle.sysman.events.EventInitializer 2 2016-04-28 14:53:39.651000 -04:00
3 DFW-99998 [java.lang.RuntimeException][oracle.sysman.core.c 3 2016-04-28 14:53:40.077000 -04:00
5 DFW-99999 [EMGC_OMS1][oracle.sysman.emdrep.olog.ObjectLogge 5 2016-05-03 10:53:49.665000 -04:00
7 EM-03702 [EM.jobs][emdrep.jobs] 8 2016-05-03 12:29:07.907000 -04:00
4 EM-00158 [EM.jobs][emdrep.jobs] 9 2016-05-25 09:45:59.436000 -04:00
8 DFW-99999 [EMGC_OMS1][oracle.sysman.sdkImpl.core.uifwk.ui.c 11 2016-05-25 09:48:21.747000 -04:00
6 EM-00158 [EMOMS_PBS][emdrep.jobs.Dispatcher] 12 2016-05-25 09:48:40.837000 -04:00
8 rows fetched


please let me know if you have any suggestions..

Thanks

[Updated on: Thu, 09 June 2016 14:29]

Report message to a moderator

Re: DIAGNOSTIC PROBLEMS [message #652476 is a reply to message #652475] Thu, 09 June 2016 14:44 Go to previous messageGo to next message
Frank Naude
Messages: 4532
Registered: April 1998
Senior Member
Try this:
adrci> delete from problem;
adrci> commit;
adrci> show problem
Re: DIAGNOSTIC PROBLEMS [message #652477 is a reply to message #652476] Thu, 09 June 2016 14:47 Go to previous message
krish96
Messages: 70
Registered: October 2012
Member
Frank Naude wrote on Thu, 09 June 2016 14:44
Try this:
adrci> delete from problem;
adrci> commit;
adrci> show problem

Thanks a lot Frank.. it worked..
Previous Topic: Event Viewer Write Error
Next Topic: Confusion Over MOS Certification Matrix and Supported Distribution Documentation
Goto Forum:
  


Current Time: Sat Feb 17 14:34:57 CST 2018

Total time taken to generate the page: 0.05242 seconds