Friday, August 04, 2006

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.

3 comments:

Fayyaz said...

I have run the latest utility 0.1.4 on AIX 5.3 having 4 Oracle 10g databases. THe utility works fine and it has send mails to specified e-mail address but I got below messages on my terminal. How to resolve these messages?
[ora10g] /home/ora10g/OraAlertCheck > OraAlertCheck.sh

Usage: oerr facility error

Facility is identified by the prefix string in the error message.
For example, if you get ORA-7300, "ora" is the facility and "7300"
is the error. So you should type "oerr ora 7300".

If you get LCD-111, type "oerr lcd 111", and so on.
cat: 0652-050 Cannot open /home/ora10g/OraAlertCheck/.tmp.ORA-00600-pfri.c:.
No recipient addresses found in header
cat: 0652-050 Cannot open pfri8:.
No recipient addresses found in header
cat: 0652-050 Cannot open plio.
No recipient addresses found in header
cat: 0652-050 Cannot open mismatch.
No recipient addresses found in header
cat: Not a recognized flag: .
Usage: cat [-qrSsu] [-n[b]] [-v[et]] [-|File ...]
No recipient addresses found in header
rm: Not a recognized flag: .
Usage: rm [-firRe] [--] File...
cat: 0652-050 Cannot open /home/ora10g/OraAlertCheck/.tmp.ORA-00600-pfri.c:.
No recipient addresses found in header
cat: 0652-050 Cannot open pfri8:.
No recipient addresses found in header
cat: 0652-050 Cannot open plio.
No recipient addresses found in header
cat: 0652-050 Cannot open mismatch.
No recipient addresses found in header
cat: Not a recognized flag: .
Usage: cat [-qrSsu] [-n[b]] [-v[et]] [-|File ...]
No recipient addresses found in header
rm: Not a recognized flag: .
Usage: rm [-firRe] [--] File...
cat: 0652-050 Cannot open /home/ora10g/OraAlertCheck/.tmp.ORA-00600-pfri.c:.
No recipient addresses found in header
cat: 0652-050 Cannot open pfri8:.
No recipient addresses found in header
cat: 0652-050 Cannot open plio.
No recipient addresses found in header
cat: 0652-050 Cannot open mismatch.
No recipient addresses found in header
cat: Not a recognized flag: .
Usage: cat [-qrSsu] [-n[b]] [-v[et]] [-|File ...]
No recipient addresses found in header
rm: Not a recognized flag: .
Usage: rm [-firRe] [--] File...

Jose Canciani said...

Check my question on the other post "Why a korn shell". Please reply only to one of them. Thanks! Jose.

best way to lose belly fat for men said...

Can I become an Oracle professional if i now start Oracle certification course at age of 32?