RE: How to test if OEM12c (12.1.0.5) detect and alert archiver hung without actually create a archive hung - production database
Date: Tue, 19 Jul 2016 12:30:54 -0700
Message-ID: <015a01d1e1f4$11a5bf80$34f13e80$_at_comcast.net>
It writes to both locations.
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
<mailto:Dimensional.dba_at_comcast.net> Dimensional.dba_at_comcast.net
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew
Parker's profile on LinkedIn
<http://www.dimensionaldba.com/> www.dimensionaldba.com
From: Le, Binh T. [mailto:Binh.Le_at_lfg.com]
Sent: Tuesday, July 19, 2016 9:09 AM
To: Dimensional DBA; oracle-l_at_freelists.org
Subject: RE: How to test if OEM12c (12.1.0.5) detect and alert archiver hung
without actually create a archive hung - production database
Thanks Matthew,
The command you sent only write into both alert_instance_name.log under trace directory and log.xml under alert directory?
EM 12c, EM 13c: Database Alert Log Monitoring in Enterprise Manager Cloud Control and Alert Log Metrics Explained (Doc ID 1538482.1)
If I read the document correctly:
Alert Log > Archiver Hung Alert Log Error using alert_instance_name.log
DB Alert Log > Archiver Hung Alert Log Error using log.xml
From: Dimensional DBA [mailto:dimensional.dba_at_comcast.net]
Sent: Tuesday, July 19, 2016 11:44 AM
To: Le, Binh T. <Binh.Le_at_lfg.com>; oracle-l_at_freelists.org
Subject: RE: How to test if OEM12c (12.1.0.5) detect and alert archiver hung
without actually create a archive hung - production database
exec dbms_system.ksdwrt(2, 'ORA-00600: XXX');
or whichever error message you wish to test.
You can also generate trace files.
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
<mailto:Dimensional.dba_at_comcast.net> Dimensional.dba_at_comcast.net
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew
Parker's profile on LinkedIn
<http://www.dimensionaldba.com/> www.dimensionaldba.com
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Le, Binh T.
Sent: Tuesday, July 19, 2016 8:38 AM
To: oracle-l_at_freelists.org
Subject: How to test if OEM12c (12.1.0.5) detect and alert archiver hung
without actually create a archive hung - production database
Dear List,
I setup the oracle database instance target with metric DB Alert Log > Archiver Hung Alert Log Error with Critical Threshold as ORA-.
As Oracle document says that it "should" alert when log.xml under alert directory content the error.
Is there the way to inject the error so that OEM will detect and send out the alert.
It is production database so I can't not actually cause archive hung without getting fired.
I copied the error from other database log over but doesn't seem alert.
Thanks,
Binh
Notice of Confidentiality: **This E-mail and any of its attachments may
contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation family
of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this E-mail,
you are
hereby notified that any dissemination, distribution, copying, or action
taken in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please
notify the
sender immediately and permanently delete the original and any copy of this
E-mail
and any printout. Thank You.**
Notice of Confidentiality: **This E-mail and any of its attachments may
contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation family
of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this E-mail,
you are
hereby notified that any dissemination, distribution, copying, or action
taken in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please
notify the
sender immediately and permanently delete the original and any copy of this
E-mail
and any printout. Thank You.**
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 19 2016 - 21:30:54 CEST