ORA-27092: size of file exceeds file size limit of the process

[Former Member]

Hi,

We have a NetWeaver 2004S portal running on AIX 5.3 and Oracle 10.2.0.2. We only get this error when doing certain things like deploying via SDM or KM imports - the portal starts and runs as normal with data files over 2 GB.

The hard & soft file size limits are set to -1 for both ORA<SID> and <SID>ADM and the file system is jfs2.

Any idea why I'm getting this error, or where else this limit could be set?

Many thanks

Jane

Example from SDM log:

Jan 24, 2008 4:31:39 AM com.sap.sl.util.cvers.impl.CVersManager: stack trace:

EXCEPTION

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

ORA-01116: error in opening database file 2

ORA-01110: data file 2: '/oracle/<SID>/sapdata2/undo_1/undo.data1'

ORA-27092: size of file exceeds file size limit of the process

Additional information: 262143

Additional information: 309761

[stefan_koehler · Accepted solution]

Hello Jane,

how big is your file of the undo tablespace?

> SQL> SELECT BYTES, BLOCKS, MAXBYTES, MAXBLOCKS, AUTOEXTENSIBLE FROM DBA_DATA_FILES WHERE FILE_NAME = '/oracle/<SID>/sapdata2/undo_1/undo.data1';

And please post the limits with:

> SHELL> ulimit -a

> SHELL> limit

Regards

Stefan

[Former Member]

Hi Jane,

We also faced similar issue.

Important thing we have to consider is the ulimits when we start the database.

If you know that ulimits are unlimited, then just restarting the database should solve the problem.

Regards,

Abhishek Thota

[Former Member]

Hello Jane,

The user who started up the database, also should have the ulimit set to unlimited. Try giving the unlimited clause for all the users.

Setting ulimit to unlimited by adding the following to /etc/security/limits

fsize = -1

core = -1

data = -1

stack = -1

res = -1

Cheers,

Nisch

[Former Member]

Increase the size of undo tablespace by loging into oracle through sqlplus.

and then retry...it will work.

Regards,

Rohit

[Former Member]

Hi Jane,

ORA-27092: size of file exceeds file size limit of the process

Cause: an attempt was made to open a file that exceeds the process's file size limit (ulimit), additional information shows the current limit (logical blocks) and the size of the file (logical blocks)

Action: increase the processes file size limit (ulimit) and retry .

for error : -ORA-01116

ORA-01116: error in opening database file string

Cause: Usually the file is not accessible.

Action: Restore the database file.

Regards,

Rohit