-
Hi,
My work environment are arround 100 DB in different SO. My question is:
Does anybody know how could I check this alert.log files from all servers and send me an e-mail when everything is wrong?
Thanks in advance
Angel
-
Is this unix env ?
If yes, then you can write a simple shell script that can grab the errors from various alert logs and combine them together.
The script can be executed through rsh from a central admin server.
svk
-
We have unix and windows database servers :-(
svk:
Could you explain how you access to every alert.log in different servers from the script ?
Thanks
Angel
-
email me.
I have some scripts for you.
LNGUYE16@YAHOO.COM
-
I can talk only @ the unix servers !!
Do you have some kind of stucture in your file system and directories ? Based on the SID, can you locate the alert log for that database ? I mean something like $HOME/admin/$SID/bdump ?
Are all the 'oracle' unix accounts have same password on all servers ?
Is there a central server that can be configured to to run a 'rsh' on all the database servers ?
If answer to 2 questions above is 'NO', you will have to run the script individually on all servers through 'cron' and each will generate a mail.
If the answer is 'YES', you can have one single mail talking about all the databases.
svk
-
send me an e-mail when everything is wrong?
When is everything wrong :-)
-
Originally posted by julian
send me an e-mail when everything is wrong?
When is everything wrong :-)
I was talking about anything :-)
Excuse for my english
svk: Thanks for your replies
Regards
Angel
-
I know, not everybody will be happy with this solution,
but I do this using Oracle Entreprise Manager.
I created an event that checks the alert-file. On alarm, a mail is sent by OEM . ( you need an SMTP avare mail system )
Regards
Gert
-
Thanks Gert I will try it too
Regards
Angel
-
OEM actually has a predefined event called 'Alert' that notifies you whenever a new error message is written to the alert log.
Why do people continue using shell scripts and CRON to do things that Oracle and OEM can do just as well, or better? It just seems like making work for yourself to me. We use SunOS, HP-UX, NT & 2000. If it weren't for OEM we would never have any sort of standardisation.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|