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 get this error when doing certain things like deploying via SDM or KM imports.

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

[Former Member]

Hi,

Refer 129439 & 553854 SAP notes.

Regards,

Sachin Rane.

[markus_doehr2]

What shell do you use?

check the output of

csh: limit

sh: ullimit -a

(for both <sid>adm and ora<SID>)

Markus

[Former Member]

What was the resolution of this issue?

Cheers

Kunal