Oracle comes with a product called Oracle Enterprise Manager. You can purchase a "Module" for it that allows you to configure events as you specified. It will notify you by email or pager if an event occurs.