Home » SQL & PL/SQL » SQL & PL/SQL » ALERT LOGS
ALERT LOGS [message #294138] Wed, 16 January 2008 10:39 Go to next message
uma1
Messages: 3
Registered: January 2008
Junior Member
Can someone tell me how to extract error messages alone from alert logs into another file?
Re: ALERT LOGS [message #294144 is a reply to message #294138] Wed, 16 January 2008 10:44 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
What do you mean?
Alert log is itself a file.

Re: ALERT LOGS [message #294147 is a reply to message #294138] Wed, 16 January 2008 10:48 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
cat alert.log |grep "ORA-" >another_file


would be one way.
Re: ALERT LOGS [message #294149 is a reply to message #294138] Wed, 16 January 2008 10:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Since last messages are more important
tail alert_sid.log | grep ORA > file.txt
Re: ALERT LOGS [message #294160 is a reply to message #294138] Wed, 16 January 2008 11:18 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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"?
Re: ALERT LOGS [message #294162 is a reply to message #294160] Wed, 16 January 2008 11:20 Go to previous messageGo to next message
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?
Re: ALERT LOGS [message #294163 is a reply to message #294149] Wed, 16 January 2008 11:22 Go to previous messageGo to next message
uma1
Messages: 3
Registered: January 2008
Junior Member
Any environment is ok. As long as I am able to just notified of the error messages alone?
Re: ALERT LOGS [message #294166 is a reply to message #294138] Wed, 16 January 2008 11:29 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1352202934074
Previous Topic: SYSDATE Minus Minutes
Next Topic: Populate A Table Prior to Select
Goto Forum:
  


Current Time: Sat Dec 03 00:57:58 CST 2016

Total time taken to generate the page: 0.20738 seconds