Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: To set events or not set events, that is the question
Sure, your quite welcome
I'm trying to trap the code because on some DBs we get thousands of errors and really wonder if an application is working. We put out a daily summary of all errors and an explanation Like below I want to see why we have 5000 900s for the ERP user
On a couple I'm getting 1000s of 1017 invalid username/password; logon denied
These are coming from Web Logic and I don't know who's executing the
CONNECT
You know anyway to trap that?
Thanks Larry
Created at 15-JUN-2004 14 00 00
NAME ERROR COUNT(*) OSUSER USERNAME ------- ------------------------------ ---------- ------------ ------------ HERO 1 88 dzedm ALL$USER HERO 1 321 newwk ERPSUSER HERO 1 725 opesveer ERPSUSER HERO 1 117 zervcluz ERPSUSER HERO 1400 2 newwk ERPSUSER HERO 1401 1 newwk ERPSUSER HERO 1722 2 112273 ERPSUSER HERO 1722 2 112292 ERPSUSER HERO 20101 85 newwk ERPSUSER HERO 20101 13 zervcluz ERPSUSER HERO 2291 125 newwk ERPSUSER HERO 2292 2 zervcluz ERPSUSER HERO 900 1 112292 ERPSUSER HERO 900 4963 zervcluz ERPSUSER HERO 904 3 112273 ERPSUSER HERO 904 7 112292 ERPSUSER HERO 923 1 szezhedr ALL$USER HERO 933 2 112292 ERPSUSER HERO 942 2 109050 ERPSUSER HERO 942 4 112273 ERPSUSER HERO 942 4 112292 ERPSUSER HERO 942 3 szezhedr ALL$USER HERO 942 1 bcurtkam MANAGER HERO 942 6 dzedm EDMREAD HERO 942 386 dzedm ALL$USER
25 rows selected.
00001, 00000, "unique constraint (%s.%s) violated"
// *Cause: An UPDATE or INSERT statement attempted to insert a duplicate
key.
// For Trusted Oracle configured in DBMS MAC mode, you may see // this message if a duplicate entry exists at a different level.
01400, 00000, "cannot insert NULL into (%s)"
// *Cause:
// *Action:
01401, 00000, "inserted value too large for column"
// *Cause:
// *Action:
01722, 00000, "invalid number"
// *Cause:
// *Action:
02291, 00000,"integrity constraint (%s.%s) violated - parent key not found"
// *Cause: A foreign key value has no matching primary key value.
// *Action: Delete the foreign key or add a matching primary key.
02292, 00000,"integrity constraint (%s.%s) violated - child record found"
// *Cause: attempted to delete a parent key value that had a foreign
// key dependency.
// *Action: delete dependencies first then parent or disable constraint.
00900, 00000, "invalid SQL statement"
// *Cause:
// *Action:
00904, 00000, "invalid column name"
// *Cause:
// *Action:
00923, 00000, "FROM keyword not found where expected"
// *Cause:
// *Action:
00933, 00000, "SQL command not properly ended"
// *Cause:
// *Action:
00942, 00000, "table or view does not exist"
// *Cause:
// *Action:
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Niall Litchfield
Sent: Tuesday, June 15, 2004 2:32 PM
To: oracle-l_at_freelists.org
Subject: Re: To set events or not set events, that is the question
Thanks Larry
I'll update the code with some error handling (if there's an error in the error logging....) and make a note about the issue.
Cheers
On Tue, 15 Jun 2004 14:01:50 -0500, Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com> wrote:
> > Niall, > There's a bug(3124081)in 9 that can cause dumps and abends when you > get an error that doesn't refer to any text like 1017 etc.
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ********************************************************************** 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 re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jun 15 2004 - 15:54:34 CDT