shell scripting: sweep logfile for a string but ignore certain substrings
I wish to sweep a log file and email an alert if errors are found. Basic logic is to search the Oracle listener log for strings having a "TNS-" prefix. If the word count is positive, throw the alert. Certain TNS strings are benign, therefore we generate a whole lot of garbage email.
The target, then, is to exempt the benign ones -- but my Bash skills aren't up to it, Can anyone teach me how to count "TNS-" but not include "TNS-12456", etc.?
The target, then, is to exempt the benign ones -- but my Bash skills aren't up to it, Can anyone teach me how to count "TNS-" but not include "TNS-12456", etc.?
An example:
if [ -f $LISTENER_LOG_FILE ]; then
# if [ `grep "TNS-" $LISTENER_LOG_FILE | wc -l` -ne 0 ]; then
if [ `grep "TNS-12546" $LISTENER_LOG_FILE | wc -l` -ne 0 ]; then
echo -e "\nThe $LISTENER_LOG_FILE file contains errors." > $LOG_FILE
echo -e " " >> $LOG_FILE
grep "TNS-12546" $LISTENER_LOG_FILE >> $LOG_FILEASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Actually you need the script to monitor only for the latest entries after the previous monitoring event.
You can choose one of the many scripts posted in the internet that do this.
You can choose one of the many scripts posted in the internet that do this.
You could actually even set up your listener.log as an external table and query it from within SQLPLUS.
René Nyffenegger's site has an example of how to do it with the alert log, shouldn't be too hard to tweak it for what you need with the listener.log.
See this page for the full scripting behind it: http://www.adp-gmbh.ch/ora/admin/scripts/read_alert_log.html
René Nyffenegger's site has an example of how to do it with the alert log, shouldn't be too hard to tweak it for what you need with the listener.log.
See this page for the full scripting behind it: http://www.adp-gmbh.ch/ora/admin/scripts/read_alert_log.html
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was able to find my own solution, and documented it. Notice, however, that I distributed my points to the two fellow experts who best assisted my thought process.
ASKER