RE: stale ASM alert logs
From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Mon, 20 Aug 2012 15:43:52 +0000
Message-ID: <BD475CE0B3EE894DA0CAB36CE2F7DEB4E3D09BD1_at_LITIGMBCRP02.Corp.Acxiom.net>
Unfortunately that's a package and doesn't exist in ASM, since ASM has no physical presence. It'll work for dbs though and I've thought of implementing something like that to dump messages maybe weekly to alert logs of dbs, just to validate that the agent is properly monitoring the alert log. Under 10g we're finding that sometimes the agent stops monitoring the alert log and the only way we've found to detect this is to dump messages to see if they're picked up and if not, then the agent is goofed up and has to be restarted. It's always fun monitoring the monitor!
1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM
-----Original Message-----
From: rjamya [mailto:rjamya_at_gmail.com] Sent: Monday, August 20, 2012 10:40 AM
To: Jed_Walker_at_cable.comcast.com
Cc: Herring Dave - dherri; Guillermo Alan Bort; oracle-l_at_freelists.org Subject: Re: stale ASM alert logs
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
Date: Mon, 20 Aug 2012 15:43:52 +0000
Message-ID: <BD475CE0B3EE894DA0CAB36CE2F7DEB4E3D09BD1_at_LITIGMBCRP02.Corp.Acxiom.net>
Unfortunately that's a package and doesn't exist in ASM, since ASM has no physical presence. It'll work for dbs though and I've thought of implementing something like that to dump messages maybe weekly to alert logs of dbs, just to validate that the agent is properly monitoring the alert log. Under 10g we're finding that sometimes the agent stops monitoring the alert log and the only way we've found to detect this is to dump messages to see if they're picked up and if not, then the agent is goofed up and has to be restarted. It's always fun monitoring the monitor!
DAVID HERRING
DBA
Acxiom Corporation
EML dave.herring_at_acxiom.com TEL 630.944.4762 MBL 630.430.5988
1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM
-----Original Message-----
From: rjamya [mailto:rjamya_at_gmail.com] Sent: Monday, August 20, 2012 10:40 AM
To: Jed_Walker_at_cable.comcast.com
Cc: Herring Dave - dherri; Guillermo Alan Bort; oracle-l_at_freelists.org Subject: Re: stale ASM alert logs
I wonder if dbms_system.ksdwrt might have worked on asm instance to manually insert a message in alert.log
Raj
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 20 2012 - 10:43:52 CDT