OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » ALERT LOGS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ALERT LOGS [message #294138]

Wed, 16 January 2008 10:39

uma1
Messages: 3
Registered: January 2008

Junior Member

Can someone tell me how to extract error messages alone from alert logs into another file?

Report message to a moderator

Re: ALERT LOGS [message #294144 is a reply to message #294138]

Wed, 16 January 2008 10:44

varu123
Messages: 754
Registered: October 2007

Senior Member

What do you mean?
Alert log is itself a file.

Report message to a moderator

Re: ALERT LOGS [message #294147 is a reply to message #294138]

Wed, 16 January 2008 10:48

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

cat alert.log |grep "ORA-" >another_file

would be one way.

Report message to a moderator

Re: ALERT LOGS [message #294149 is a reply to message #294138]

Wed, 16 January 2008 10:49

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In which environment?
SQL? PL/SQL?
shell? which one?
Program?

Maybe something like "grep ORA- alert.log >errors"

Regards
Michel

[Updated on: Wed, 16 January 2008 10:50]

Report message to a moderator

Re: ALERT LOGS [message #294156 is a reply to message #294138]

Wed, 16 January 2008 10:58

varu123
Messages: 754
Registered: October 2007

Senior Member

Since last messages are more important
tail alert_sid.log | grep ORA > file.txt

Report message to a moderator

Re: ALERT LOGS [message #294160 is a reply to message #294138]

Wed, 16 January 2008 11:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there a way where i can just capture error messages and ignore normal ones?
How do you plan on programatically differentiating between "normal" and "error"?

Report message to a moderator

Re: ALERT LOGS [message #294162 is a reply to message #294160]

Wed, 16 January 2008 11:20

uma1
Messages: 3
Registered: January 2008

Junior Member

I am not sure. But is there a way to automate the process of monitoring alert logs so that oone gets notified automatically of commonly occuring errors? can UTL_FILE package be used for this?

Report message to a moderator