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!