RE: OEM 10g ORA-00001 mystery

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Wed, 2 Apr 2008 09:06:59 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E3604705B38@CWYMSX04.Corp.Acxiom.net>

Oracle got back to me and stated that if when loading data they get an ORA-00001, they then perform an update. Doesn't make sense why only a few nodes would cause this behavior, but I'm fine ignoring this for now.

Dave

---

Dave Herring, DBA | A c x i o m M I C S / C S O

630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yong Huang Sent: Tuesday, April 01, 2008 10:30 AM
To: oracle-l_at_freelists.org
Subject: Re: OEM 10g ORA-00001 mystery

> 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


***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.
****************************************************************************

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

Received on Wed Apr 02 2008 - 09:06:59 CDT