We moved to Google Code!

We have decided to move OraAlertCheck to Google Code: http://code.google.com/p/oraalertcheck/

We can now offer the source code in a versioning system and a good issue tracker to submit bugs or improvements.

We won't be updating this blog anymore, but the Announce and Development mailing lists will still be opened and reviewed.

Regards,
Jose Canciani.

Development list has been created

Since blog comments are not a suitable way of giving support I've created a new Mailing List for Development and Support. The current mailing list will only have Announcements like new versions of the script or important messages.

Regards,
Jose.

OraAlertCheck 0.1.5 released

Thanks Fayyaz for the feedback!

OraAlertCheck now is fully functional in AIX (tested on 5.3).

New features:

• Corrections on the way the script treats filenames. When the oracle error was ORA-00600 and had special characters on the arguments the script created temporary files with spaces or : characters which made the script failed.
  

Regards,
Jose.

OraAlertCheck is back! Version 0.1.4

Thanks to Raghu Maddula for the feedback!


OraAlertCheck now is functional in HPUX and Solaris.

New features:

• oratab file location can be specified in the Config file (in case you don't have root access to modify /etc or you SA is too slow ;) )
• The tail command needs to support the -n flag. In Solaris the default one did not, so I add a new config parameter to specify a new location (/usr/xpg4/bin/tail for Solaris).
• The "test" run of the script will not only show if it find the alert.log but also will let you now if that instance won't be checked becouse the startup parameter in oratab is "N".
• Finally we add the "encountered when generating server alert" message detection (althought I'm not sure if we should print the first ORA- or the server alert error...).

Have fun!

Jose.

Version 0.1.3

Only one annoying fix:

• The script now detects "caused by" and "signalled by" errors and alert them accordingly.

Version 0.1.2 is out

Only minor changes.

• GNU GPL License text added to the files
• Simpler config file lookup (just leave on the same directory as the run file)
• Run it from any directory
• Show the line error in the alert mails, not only the error code.

OraAlertCheck 0.1.1 is out

A couple of changes, I've add an automatic alert.log truncation: the script moves the file and then compress it in the same bdump directory. Just add TRUNCATE_BYTES="nnn" in the config file to enable, "0" to disable.

Also now the script send different alerts to reflect different ORA-00600 parameters instead of sending only one mail.