check http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScrId=993
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 10:44
PM
Subject: perl/shell script for alert
log
I am sure you guys
Yeah, I log those. Some of the db's I support run with very small redo logs
and I can't change. They get those quite frequently at times so I pretty
much ignore them. My script also reacts (log,email,page, or run some
script) in the event of startups, shutdowns and alter database structure.
It a
Hey, awesome tip! Been here, lurking. Does that generate a trace file with
more than just session id and serial# in it? Nice thing about SERVERERROR
is I can get machinename, username, osuser etc and stuff it in alert log
so I see who caused the error when I get the email, but your way is cl
Hi!
I would add a check for "Checkpoint not complete" in alert just in case as
well.
Tanel.
> One enhancement I suggest to every script is to configure the a
SERVERERROR
> trigger to throw certain errors out to the alert log. ORA-1555 is one
that
> will show up at the session level but not at t
Welcome back Ethan!
An alternative is using the following lines in init.ora:
event="1555 trace name errorstack level 3"
event="4031 trace name errorstack level 3"
event="1652 trace name processstate level 10"
This catches the dreaded 01555, out of TEMP, and shared pool allocation
errors *along*
If you use Connor's script you can modify it to send you the entire chunk of
file it is currently checking in the body of the email. Ideally you are
checking at a frequent interval so the time of the alert is usually about
the same time you get the error message.
One enhancement I suggest to ever
When I grep something from the alert log,
it never tell me the date and time of the error.
Is there a setting for appending a timestamp on each error?
-Original Message-
Sent: Wednesday, August 27, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
HTH
#!/bin/sh
# This Script search
AK - Go to Google and search on oracle alert log monitor script. This will
give you an array to select from. What you want will depend to a large
extent on your requirements:
- Something you can easily modify?
- What platforms should it run on?
- Email you alerts?
- Which errors do you wish to
http://www.oracledba.co.uk/
Check out the alert log script in the admin section. Doesn't
repeatedly check the same segment of the alert log file.
- Ethan
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 12:14
PMTo: Multipl
HTH
#!/bin/sh
# This Script search for Oracle error messages in last
100 lines in the alert log file ,
# keep log to a file.
# You should pass name of ORACLE_SID as a parameter.
#!/usr/bin/sh
#
# Comments: Script checks last 100 lines of
# the alert log for specific
# Oracle errors, e-mails dep
10 matches
Mail list logo
