Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle Alert
- Thread starter theinvid
- Start date
vikramkalsi
Programmer
It is quite impossible to predict a database failure. However, you can be notified if the database has gone down or crashed and even restart the database in such a scenario.
I can think of two ways for notification - A monitoring shell script (unix only) and through Oracle Enterprise Manager.
1) Monitoring Shell Script: is pretty staight forward to set up. At specified intervals check for the oracle background processes ora_pmon, ora_smon, etc. In case process(es) not found then email a notification to the DBA, you may even like to include the last 50-100 lines from the alert log. If you want, I can provide you a sample script also.
2) OEM: In OEM you can set up an EVENT and include a "UpDown Database" test in it. You will have to configure an SMTP gateway if you want to receive a notification.
Again this is very similar to the shell script approach. OEM will check the status of the Database at the specified intervals and send out an email in case the Database is down. OEM can also be configured to start the DB in such a case, through a "fixit" job. This is a note from OEM help-
+++++++++++++++START NOTE+++++++++++++++++++++++++++++++++++
UpDown Database
This event test checks whether the database being
monitored is running. If this test is triggered, other
database events are ignored.
Parameters
None
User Action
The Startup Database job task can be set up as a fixit
job for automatically correcting the problem.
Note:
If the listener serving a database is down, this event
may be triggered because the Intelligent Agent uses
the listener to communicate with the database. This
note applies to Intelligent Agents released before 8.0.5.
+++++++++++++++END NOTE++++++++++++++++++++++++++++++++++++
Hope this helps. Do let me know if it does.
Regards,
Vikram Kalsi.
I can think of two ways for notification - A monitoring shell script (unix only) and through Oracle Enterprise Manager.
1) Monitoring Shell Script: is pretty staight forward to set up. At specified intervals check for the oracle background processes ora_pmon, ora_smon, etc. In case process(es) not found then email a notification to the DBA, you may even like to include the last 50-100 lines from the alert log. If you want, I can provide you a sample script also.
2) OEM: In OEM you can set up an EVENT and include a "UpDown Database" test in it. You will have to configure an SMTP gateway if you want to receive a notification.
Again this is very similar to the shell script approach. OEM will check the status of the Database at the specified intervals and send out an email in case the Database is down. OEM can also be configured to start the DB in such a case, through a "fixit" job. This is a note from OEM help-
+++++++++++++++START NOTE+++++++++++++++++++++++++++++++++++
UpDown Database
This event test checks whether the database being
monitored is running. If this test is triggered, other
database events are ignored.
Parameters
None
User Action
The Startup Database job task can be set up as a fixit
job for automatically correcting the problem.
Note:
If the listener serving a database is down, this event
may be triggered because the Intelligent Agent uses
the listener to communicate with the database. This
note applies to Intelligent Agents released before 8.0.5.
+++++++++++++++END NOTE++++++++++++++++++++++++++++++++++++
Hope this helps. Do let me know if it does.
Regards,
Vikram Kalsi.
- Status
Similar threads
- Locked
- Question