Skip to Content
Former Member
Dec 03, 2009 at 06:15 PM

ORA-27092 when running startsap


Hi All,

We have a weird one. Following a reboot of out AIX 6.1 box, we are unable to start SAP as it fails when starting the database:

Caused by: java.sql.SQLException: ORA-01116: error in opening database file 5

ORA-01110: data file 5: '/oracle/EPD/sapdata4/sr3db_2/sr3db.data2'

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

Additional information: 131071

Additional information: 256001

Now, a few points that make this an odd issue.

sidadm has unlimited ulimits on this box:

time(seconds) unlimited

file(blocks) unlimited

data(kbytes) unlimited

stack(kbytes) unlimited

memory(kbytes) unlimited

coredump(blocks) unlimited

nofiles(descriptors) unlimited

threads(per process) unlimited

processes(per user) unlimited

And with the SIDADM user, I can run SQLplus and start/stop the database without issue. However, SAP is not startable for the reason above and an R3trans -d run returns the same error code.

Any thoughts? Thanks!