Re: Database Errors - How to detect

Hi Doug,

1 - If it's down, you will know soon enough 2 - If anything serious happens it will be written to the alert log. This is the first place to look for when a database becomes troubled. The alert log is located in the background dump directory as indicated in init<sid>.ora On some systems (VMS!) these alerts will be paged to the operator process automatically
3 - Use Enterprise Manager. This is capable of emailing you or paging you out of your bed, when the database goes down. Of course Enterprise Manager has it's own repository, so you need a small second database for this repository in order to monitor your production database(s).

Hth,

Sybrand Bakker, Oracle DBA

PS this is a vast area. Maybe you should consider buying the Oracle troubleshootin guide by Oracle Press/Osborne

Douglas Whitacre wrote:

> How can I detect if something has happened to my database? Is there anyway
> for me to be notified if the database goes down or has a serious problem?
> Thanks in advance from someone trying to quickly learn the ropes. If you
> can reply to this email I would greatly appreciate it.
>
> Thanks,
>
> Doug

Received on Mon Mar 08 1999 - 12:40:04 CST