Re: ora-27092
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 21 Aug 2004 16:47:45 +0800
hi,Ehresmann, David
please check your os kernel parameters ?
it looks like that the process can not operator on a large file which
is biger than 131071 blocks (1G ?).
Best regards
yahoo id: feng_chunpei
A new dba from china
---- from the mail-----
>
>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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
