Hi all,
I am writing a script that can grep ORA- from alert log.
I think it will be good if I can grep the time of the error occur, can you please help
me?
If you are lazy to type please introduce me any related unix function, I will do man
the function myself.
Thanks
Sinardy
--
Please
Hi all,
I am writing a script that can grep ORA- from
alert log.
I think it will be good if I can grep the time of
the error occur, can you please help me?
If you are lazy to type please introduce me any
related unix function, I will do man the function
myself.
Thanks
Sinardy
Sinardy,
Sinardy,
I've posted a shell script called chk_oerr.sh on
http://www.EvDBT.com/tools.htm;. It doesn't do exactly what you ask, but it
remembers where it left off scanning in the alert.log file. You can run
it hourly, daily, or weekly if you like, and the timing of the emails it
sends you should
Title: RE: Alert Log reporting question
Checkout http://www.zephyrus.com ... it is a very nice tool ...
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts
I have a script to do this (but not access to it at
the moment) but its basically egrep and awk to:
a) grep for ORA-, ^Mon, ^Tue, ... ^Sat
b) results piped through awk which does:
if $0 like ORA-, the print p, $0
if $0 like Mon,Tue,...Sat, then p=substr($0,12)
hth
connor
--- Sinardy