From oracle-l-bounce@freelists.org Sat Aug 21 10:36:20 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i7LFaJT20276 for ; Sat, 21 Aug 2004 10:36:19 -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 i7LFaJI20270 for ; Sat, 21 Aug 2004 10:36:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 06DA772C307; Sat, 21 Aug 2004 10:40:50 -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 12623-94; Sat, 21 Aug 2004 10:40:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3DAF872C30F; Sat, 21 Aug 2004 10:40:49 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 21 Aug 2004 10:39:25 -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 403C272C22A for ; Sat, 21 Aug 2004 10:39:24 -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 12623-70 for ; Sat, 21 Aug 2004 10:39:24 -0500 (EST) Received: from exchange.wgen.net (exchange.wgen.net [216.194.17.194]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D38D072C275 for ; Sat, 21 Aug 2004 10:39:23 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: ora-27092 Date: Sat, 21 Aug 2004 11:40:41 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ora-27092 Thread-Index: AcSHB2Nw+bDfGh2SRsOxWb1QxKrvNAAjWBUg From: "Anthony Molinaro" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 8033 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: amolinaro@wgen.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Dave, ulimit unlimited will fix that, are you sure it's unlimited? When you receive the error, in that same session check ulimit it might not be unlimited. - a -----Original Message----- From: Ehresmann, David [mailto:David.Ehresmann@ps.net]=20 Sent: Friday, August 20, 2004 6:44 PM To: 'oracle-l@freelists.org' Subject: ora-27092 Has anybody seen this error before, and yes I have read all over metalink. This is a new dev db 9.2.0.4.0 on aix 5.1L, copied from a prod db. It has 6gb of undo tablespace. The original prod db is 8i and had 12 gb of rollback. This error is generated from a 3rd party product that basically inserts into tables in the app schema. I have checked the limits on the OS with the admin and they are unlimited for oracle. This error is not consistent. Some times it does not happen at all. And it will reference different datafiles, i.e. undotbs01.dbf, undotbs02.dbf, ... The 3rd party product uses a unix account, should its limits be unlimited? Or is it just the size of the undo tablespace? ORA-00604: error occurred at recursive SQL level 1=20 ORA-01116: error in opening database file 54=20 ORA-01110: data file 54 '/.../.../.../undotbs03.dbf'=20 ORA-27092: skgfofi: size of file exceeds file size limit of the process=20 Additional information: 131071 Additional information: 256001 thanks, David Ehresmann =20 ---------------------------------------------------------------- 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 -----------------------------------------------------------------