Home » Infrastructure » Unix » oracle errors
oracle errors [message #98522] Mon, 13 December 2004 23:01 Go to next message
Alan
Messages: 68
Registered: October 1999
Member
Hello all,

I need to create a cron job to grep the oracle alert log file for ORA errors and then mail users. can anyone supply a suitable script.

many thanks in advance.

 

Alan

 

Report message to a moderator

Re: oracle errors [message #98535 is a reply to message #98522] Tue, 21 December 2004 02:48 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
This should work:

grep ORA- /app/oracle/admin/orcl/bdump/alert_orcl.log | mail you@yourcompany.com


Best regards.

Frank

Report message to a moderator

Previous Topic: Question on AT command
Next Topic: How to pass sql result set to unix shell script variable
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 15:36:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.