Monitoring oracle alerte file ?

[Sofiane]

Hello,

I would like to have access to Oracle alerte file via DB. In other words,
suppose that you would like to monitor the alerte file (see if there are messages like ORA-600...)
from a remote machine in which an oracle client is installed (and we can't open a telnet session).

What are the possible solutions (OEM, other solutions) ?

Thanks a lot in advance ...

Sofiane

[rlowe]

Hi,

You could do several things:
1) ssh
2) set up NFS
3) SAMBA

or, you could just write a script to monitor the file and alert you to when there is an ORA-00600.

EX:

#!/usr/bin/perl -w

$error = `grep ORA-00600 `;
if ($error)
{
system("mail -s oracle_alert ");
}

good luck

R