Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ora-27092

ora-27092

From: Ehresmann, David <David.Ehresmann_at_ps.net>
Date: Fri, 20 Aug 2004 17:44:21 -0500
Message-ID: <27C3FCA54F61C34389325FD99A0D60CC080E0A@pscdalpexch50.perotsystems.net>

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 
ORA-01116: error in opening database file 54 
ORA-01110: data file 54 '/.../.../.../undotbs03.dbf' 
ORA-27092: skgfofi: size of file exceeds file size limit of the process 
Additional information: 131071
Additional information: 256001

thanks,

David Ehresmann



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 Fri Aug 20 2004 - 17:40:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US