tag:blogger.com,1999:blog-5102441.post110824617601837935..comments2013-06-27T14:57:47.187-03:00Comments on OraAlertCheck, an Oracle alert.log watchdog: Quick HowtoJose Cancianihttp://www.blogger.com/profile/09578561231406657188noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5102441.post-53731240223549282832013-06-27T14:57:47.187-03:002013-06-27T14:57:47.187-03:00After renaming the sample config file to OraAlertC...After renaming the sample config file to OraAlertCheck_config.sh, you can edit it. This is the variable you need to change:<br /><br />export SENDMAIL_COMMAND="/usr/sbin/sendmail -t -oi"<br /><br />Change for any command that will accept a full raw email text (probably mailx accepts them somehow).<br /><br />I have not used this script for years, but anyone is welcome to improve it in Jose Cancianihttps://www.blogger.com/profile/09578561231406657188noreply@blogger.comtag:blogger.com,1999:blog-5102441.post-59864156591137233992013-06-27T14:40:11.362-03:002013-06-27T14:40:11.362-03:00Hi Jose, I don't know if this blog is active y...Hi Jose, I don't know if this blog is active yet. Anyway, I have a question. I don't have sendmail in my server (Solaris), so I have to use mailx instead of that. Where can I replace in the files that you were provide us ??<br />thanks a lotAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5102441.post-1156943589236795232006-08-30T10:13:00.000-03:002006-08-30T10:13:00.000-03:00Edit your oratab file and change the automatic sta...Edit your oratab file and change the automatic startup to Y (you should have a line like this: "comqas:/path/to/your/orahome:N", so just change N to Y.<BR/>You can use the mailing list for this questions too, more people could answer.<BR/>Jose.Jose Cancianihttps://www.blogger.com/profile/09578561231406657188noreply@blogger.comtag:blogger.com,1999:blog-5102441.post-1156938558092733242006-08-30T08:49:00.000-03:002006-08-30T08:49:00.000-03:00I have the problem:bash-2.05b$ ./OraAlertCheck.sh ...I have the problem:<BR/><BR/>bash-2.05b$ ./OraAlertCheck.sh test<BR/>Detected comqas but it won't be checked (becouse oratab startup is disabled)<BR/><BR/>Any sugestions?<BR/>Pablo Quadros<BR/>pqaudros@gmail.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5102441.post-1154616568056795852006-08-03T11:49:00.000-03:002006-08-03T11:49:00.000-03:00Hello Raghu, nice to receive some feedback. It's b...Hello Raghu, nice to receive some feedback. It's been several years since I don't modify the script... I was using it on HPUX, so that's probably why it has so many issues in Solaris.<BR/><BR/>I've stopped using it becouse in my new jobs I had since then was not necesary. Whats more in 10g there is a view where you can see each line of the alert.log as a row of the view.<BR/><BR/>Anyway, I can Jose Cancianihttps://www.blogger.com/profile/09578561231406657188noreply@blogger.comtag:blogger.com,1999:blog-5102441.post-1154559411452671632006-08-02T19:56:00.000-03:002006-08-02T19:56:00.000-03:00Jose, My name is Raghu, Oracle DBA working in Cali...Jose, <BR/><BR/>My name is Raghu, Oracle DBA working in California, USA. As i am planning to automate this alerting jon on alert log file I found this link and found looks promising because you mentioned it will maintain couple of files to track how many lines the script processed for continuation purpose which is very cool. Because the script checks only last "n" lines of alert log file ( of Anonymousnoreply@blogger.com