alert log - keywords to monitor?

[JMac]

Automating my alert log checking and I'm trawling round for keywords or phrases that I can monitor as and when they appear in the log file.

Can anyone suggest words or phrases that I should be picking up?

[marist89]

You should look at every word.

[rad_jen]

There is a new article posted
"Manipulating Oracle Files with UTL_FILE" . It talks about monitoring alert_log. Have a look at it.

[kris109]

Are you familiar with OEM? All the events that trigger error messages in Alert log can be managed by OEM event management. Alterts can be sent to a pager whenever an error condition/event occurs. I suggest that is the way to go.

[rad_jen]

More info: That only works when you configure OEM with OMS (oracle management server) and install Oracle intelligent agent on the server.

[kris109]

OMS and Intelligent are installed automatically when you install oracle. You need to create a repository for OMS which is not a big deal.

[slimdave]

A nice technique is to have the alert log from your important database(s) spooled to fast, pretty noisy impact printers in the office space the db staff work in.

Not only do you get instant access to the recent alert log history, but you're also the first to know when something funny is going on.

[rad_jen]

Thats right if OMS is on the same server as database.But its not a good practice though.

[kris109]

????????????????

In an enterprise, with test, integration, qa and production servers, one of the servers can be used for OMS. A small entity with a single database can configure OMS on the same machine as the DB server.

[rad_jen]

What I meant was...its not good practice to have a OMS running on any of the production and QA database servers.