From oracle-l-bounce@freelists.org Wed Jun 16 12:54:54 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5GHsSv26266 for ; Wed, 16 Jun 2004 12:54:38 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5GHsF626169 for ; Wed, 16 Jun 2004 12:54:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8EE3072CE53; Wed, 16 Jun 2004 12:37:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11017-30; Wed, 16 Jun 2004 12:37:20 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C6A0C72CAFA; Wed, 16 Jun 2004 12:36:15 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 16 Jun 2004 12:34:32 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 73ED372C881 for ; Wed, 16 Jun 2004 12:34:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09425-55 for ; Wed, 16 Jun 2004 12:34:31 -0500 (EST) Received: from cwysmtp02.acxiom.com (cwysmtp02.acxiom.com [198.160.100.129]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1692672CEC3 for ; Wed, 16 Jun 2004 12:34:30 -0500 (EST) Received: from relay.Corp.Acxiom.net (unverified [139.61.199.171]) by cwysmtp02.acxiom.com (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Wed, 16 Jun 2004 12:38:39 -0500 Received: from dngmsc01.Corp.Acxiom.net (unverified [10.76.40.237]) by relay.Corp.Acxiom.net (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Wed, 16 Jun 2004 12:38:38 -0500 Received: by dngmsc01.dg.acxiom.com with Internet Mail Service (5.5.2657.72) id ; Wed, 16 Jun 2004 12:38:38 -0500 Message-ID: <433A07749711884D8032B6A0AB115262C2BC2D@conmsx07.corp.acxiom.net> From: Wolfson Larry - lwolfs To: "'oracle-l@freelists.org'" Subject: RE: To set events or not set events, that is the question Date: Wed, 16 Jun 2004 12:37:54 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2821 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lawrence.wolfson@acxiom.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org OOPS! Sorry, I do get the user on the 1031 when I don't go after the text. Created at 15-JUN-2004 07 00 01 NAME ERROR COUNT(*) OSUSER USERNAME ------- ------------------------------ ---------- ------------ ------------ XPPROD 1031 4 dmirror DMIRROR1 XPPROD 1031 1 oracle EXPUSER XPPROD 1466 6 oracle EXPUSER Larry -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Wolfson Larry - lwolfs Sent: Tuesday, June 15, 2004 3:55 PM To: 'oracle-l@freelists.org' Subject: 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. // *Action: Either remove the unique restriction or do not insert the key. 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Niall Litchfield Sent: Tuesday, June 15, 2004 2:32 PM To: oracle-l@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 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@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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------