RE: ora-27092

From: Anthony Molinaro <amolinaro_at_wgen.net>
Date: Sat, 21 Aug 2004 11:40:41 -0400
Message-ID: <D17DB304A9F42B4787B68861F9DAE61C51D2BB@wgdc02.wgenhq.net>

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.

-----Original Message-----

From: Ehresmann, David [mailto:David.Ehresmann_at_ps.net]=20 Sent: Friday, August 20, 2004 6:44 PM
To: 'oracle-l_at_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_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


-----------------------------------------------------------------

----------------------------------------------------------------

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 Sat Aug 21 2004 - 10:36:20 CDT