This discussion is archived
6 Replies Latest reply: Sep 3, 2013 12:58 PM by user8894222 RSS

Metric Collection Error

user11985083 Newbie
Currently Being Moderated
what would cause the "Metric Collection Error" on the databases that were monitored by OEM?

thanks
  • 1. Re: Metric Collection Error
    626687 Journeyer
    Currently Being Moderated
    That can have lots of reasons, often depending on the metric affected.
    What metric do you get it for? What is the detail message to the error?
  • 2. Re: Metric Collection Error
    user11985083 Newbie
    Currently Being Moderated
    What metric do you get it for? What is the detail message to the error?
    I don't have the answers for both questions, all I know was that there were about 40 DBs on this server that were monitored by OEM last week. About 20 of them had "metric collection error" and the rest of them are fine. I am trying to find out what caused these 20 DBs to "metric collection error".

    thanks for your input.
  • 3. Re: Metric Collection Error
    626687 Journeyer
    Currently Being Moderated
    You can find detail information about metric collection errors in the alerts tab -> errors. What do you see there for your databases? A metric name and detail message should be shown.
  • 4. Re: Metric Collection Error
    Rob Zoeteweij Oracle ACE
    Currently Being Moderated
    Most common cause of Metric Collection errors on Database targets is an ilegal Monitoring User / Password.
    Perhaps this is the case in your situation as well.
    Normally you would use the DBSNMP account to monitor a database.
    When in the Database Targets overview page, press configure
    Here you will find the DBSNMP user as monitoring user.
    Make sure you have entered the correct password for it and make sure the account is unlocked.

    Regards
    Rob
    http://oemgc.wordpress.com
  • 5. Re: Metric Collection Error
    user11985083 Newbie
    Currently Being Moderated
    Thanks all for your input.

    Rob, that is the case. DBSNMP and its password, what I don't understand was what triggered the Metric error, the password didn't get changed. Basically, when it had collection metric error, I just want back and click configure and next (without enter the password since it never changed).

    I just need to find out the root cause since password nothing is changed.
  • 6. Re: Metric Collection Error
    user8894222 Newbie
    Currently Being Moderated

    But what if the metric collection error is a single instance on a two node cluster? My DBSNMP user is unlocked on the database. Both instances are up, but OEM 12C says there is a "Metric Collection Error" for one of the instances. 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points