[OraAlertCheck, an Oracle alert.log watchdog] Quick Howto
0 views
Skip to first unread message
Jose Luis Canciani
Feb 12, 2005, 5:16:43 PM2/12/05
to oraale...@googlegroups.com
Download the latest release and uncompress on your unix oracle account home directory.
Move the OraAlertCheck_config.sh.sample to either:
OraAlertCheck look for your instances on /etc/oratab by default, so if this does not exists you should create it or link it to the real path.
Check to see if the script can find your alert.log files running:
$ ./OraAlertCheck.sh test
You should see the ORACLE_SID followed by the alert.log path. If you can't and you discover a bug in the program, let me know.
Now that the log file was found you can run the script with no parameters. NOTE: Since it's the first time, it will run through all your log file and email you with a lot of errors. The script will generate a hidden file where it will set the current line number so next time it will start just where it finished.
If all worked fine, you can add the script to your crontab, every five minutes should be fine.
The script needs some work yet so please don't hesitate to send me your opinions.
--
Posted by Jose Luis Canciani to OraAlertCheck, an Oracle alert.log watchdog at 2/12/2005 06:58:00 PM
Move the OraAlertCheck_config.sh.sample to either:
- $HOME/etc
- /etc
- $HOME
- or the path from you will be executing the main script.
OraAlertCheck look for your instances on /etc/oratab by default, so if this does not exists you should create it or link it to the real path.
Check to see if the script can find your alert.log files running:
$ ./OraAlertCheck.sh test
You should see the ORACLE_SID followed by the alert.log path. If you can't and you discover a bug in the program, let me know.
Now that the log file was found you can run the script with no parameters. NOTE: Since it's the first time, it will run through all your log file and email you with a lot of errors. The script will generate a hidden file where it will set the current line number so next time it will start just where it finished.
If all worked fine, you can add the script to your crontab, every five minutes should be fine.
The script needs some work yet so please don't hesitate to send me your opinions.
--
Posted by Jose Luis Canciani to OraAlertCheck, an Oracle alert.log watchdog at 2/12/2005 06:58:00 PM
Reply all
Reply to author
Forward
0 new messages