ulimit and ORA-27092 (457 Views)
Reply
Frequent Advisor
Leam Hall
Posts: 39
Registered: ‎03-02-2010
Message 1 of 5 (457 Views)
Accepted Solution

ulimit and ORA-27092

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)

I read the ulimit threads I could find but none seemed to reference the file size limit change. I know that it can be done in the /etc/profile or user's .profile. Just need the switch, or how to get the man page that actually has the flags.

Thanks!

Leam
Acclaimed Contributor
James R. Ferguson
Posts: 21,184
Registered: ‎07-06-2000
Message 2 of 5 (457 Views)

Re: ulimit and ORA-27092

Hi Leam:

The options to 'ulimit' (as viewable and settable) by a shell are documented in the 'sh-posix(1)' manpages.

http://bizsupport.austin.hp.com/bc/docs/support/SupportManual/c02267598/c02267598.pdf

Regards!

...JRF...
Honored Contributor
Alex Glennie
Posts: 4,068
Registered: ‎05-07-2000
Message 3 of 5 (457 Views)

Re: ulimit and ORA-27092

[ Edited ]

any chance on reporting on youe o/s env, shell etc oh and what you were doing at the time of the error ?

fyi http://h30499.www3.hp.com/t5/Databases/skgfofi-size-of-file-exceeds-file-size-limit-of-the-process/m...

Email : alex_glennie@hotmail.com
Acclaimed Contributor
Dennis Handly
Posts: 25,206
Registered: ‎03-06-2006
Message 4 of 5 (457 Views)

Re: ulimit and ORA-27092

What does "ulimit -a" show?
For file you probably want "unlimited", which is the default.

So you need to look at /etc/profile or ~/.profile to find where it is restricted.
Frequent Advisor
Leam Hall
Posts: 39
Registered: ‎03-02-2010
Message 5 of 5 (457 Views)

Re: ulimit and ORA-27092

Actually, the DBA may have found a different error. The *.dbf file is 9G plus a little in size, and set to grow as needed. However, it's growth step is 2G and it's on a 10G filesystem. They're checking it out now.

However, I do like the answers! My forte is not HP/UX, as you might guess. :)

Leam
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.