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...).
Jose.
3 comments:
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...
Check my question on the other post "Why a korn shell". Please reply only to one of them. Thanks! Jose.
Can I become an Oracle professional if i now start Oracle certification course at age of 32?
Post a Comment