It is one of the facts that betray the American nature of Oracle Corp that
OEM envisages paging the dba, but not sending an SMS.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> wrote in message
news:JGj3c.33444$JN2.8502_at_bignews4.bellsouth.net...
> I agree about the Email not being reliable for instantaneous notification.
>
> We have an internal paging system that sends text pages to pagers/beepers.
> This has been more reliable for a quicker response.
>
> But, in our new global environment, the quicker internal paging system is
> being dropped for standardizing on Email for such things.
>
> The potentially slower response of Email is considered "less important"
when
> compared to the huge pennies we are going to save :)
>
> --
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:404d9b6b$0$22402$ed9e5944_at_reading.news.pipex.net...
> > You will find the start of this if you search google for UTL_FILE and
> > ALERT.LOG
> >
> > I'm not sure that relying on email for almost instantaneous notification
> is
> > necessarily as reliable as the OP thinks.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> > news:1078788261.888269_at_yasure...
> > > Charles Davis wrote:
> > >
> > > > All,
> > > >
> > > > I would like to be notified almost immediately if Oracle 9.2 writes
> > certain
> > > > messages to the Alert Log, such as any of the 'unable to extend'
> > messages.
> > > > An email sent at the moment of the error would be best.
> > > >
> > > > Can this be done somehow within Oracle v9.2?? If so, please
describe
> it
> > or
> > > > point me to the docs on this.
> > > >
> > > > I already have an external alert log monitor process, but am looking
> for
> > > > something more immediate that its polling interval.
> > > >
> > > > Many thanks.
> > > >
> > > > charles
> > >
> > > Capture the alert log as an external table or read it with UTL_FILE.
> > > Then have DBMS_JOB check it from time-to-time an fire of the email
> > > using UTL_SMTP.
> > >
> > > --
> > > Daniel Morgan
> > > http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> > > http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> > > damorgan_at_x.washington.edu
> > > (replace 'x' with a 'u' to reply)
> > >
> >
> >
>
>
Received on Tue Mar 09 2004 - 08:36:19 CST
