Re: OEM 10g ORA-00001 mystery

From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 1 Apr 2008 08:29:31 -0700 (PDT)
Message-ID: <856898.87747.qm@web80604.mail.mud.yahoo.com>

> From: "Herring Dave - dherri" <Dave.Herring_at_acxiom.com>
>
> I've got a mystery with OEM 10g that I'm hoping someone can help with. For
> most databases I support, I enable an ON SERVERERROR trigger and capture all
> possible ORA-* errors into a table for later analysis. After doing so on our
> OEM 10g repository, I noticed that we get anywhere between 500k and 800k
> ORA-00001 errors per day from the agent that loads data.

Herring, Bug 6676249 matches your description exactly (or they created it on your behalf?). I looked at table MGMT_METRICS_RAW in our OMS database. The primary key is on 4 columns: TARGET_GUID, METRIC_GUID, KEY_VALUE, and COLLECTION_TIMESTAMP. Is yours only on the first two columns? My database is 10.2.0.4 and most rows under version column of MGMT_VERSIONS are 10.2.0.4 as well (not sure what component I need to look at).

If that doesn't explain it, do you see unique constraint violated errors in mgmt_system_error_log?

Yong Huang

---

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 01 2008 - 10:29:31 CDT