alert log - keywords to monitor?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: alert log - keywords to monitor?

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    alert log - keywords to monitor?

    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?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You should look at every word.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2001
    Posts
    73
    There is a new article posted
    "Manipulating Oracle Files with UTL_FILE" . It talks about monitoring alert_log. Have a look at it.
    OCP 7.3,8.0,8i,9i

  4. #4
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  5. #5
    Join Date
    May 2001
    Posts
    73
    More info: That only works when you configure OEM with OMS (oracle management server) and install Oracle intelligent agent on the server.
    OCP 7.3,8.0,8i,9i

  6. #6
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    OMS and Intelligent are installed automatically when you install oracle. You need to create a repository for OMS which is not a big deal.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    May 2001
    Posts
    73
    Thats right if OMS is on the same server as database.But its not a good practice though.
    OCP 7.3,8.0,8i,9i

  9. #9
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    ????????????????

    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.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  10. #10
    Join Date
    May 2001
    Posts
    73
    What I meant was...its not good practice to have a OMS running on any of the production and QA database servers.
    OCP 7.3,8.0,8i,9i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width