1833489 Members
2847 Online
110052 Solutions
New Discussion

ulimit problem

 
Gerald Taylor
Frequent Advisor

ulimit problem

I have HPUX 10.20 running oracle. We recieved some errors:
ERROR MESSAGE:
ORA-00600- internal error code, arguments: [3509], [2], [], [], [], [], [], []

oerr ORA 00600
00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
// *Cause: This is the generic internal error number for Oracle program
// exceptions. This indicates that a process has encountered an
// exceptional condition.
// *Action: Report as a bug - the first argument is the internal error number


My dba tells me that the oracle users can not open a file that is greater than one GB I have run the ulimit and ulimit -a command in order to find out if there were any limits on the file size. Here is output:
# ulimit
unlimited

# ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 65536
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 2048

# ulimit -aH
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 65536
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 2048

I believe the file segment is the important one that describes how large a file a user can open. Am I wrong or is there another place to set the limit on the file size a user can open?
5 REPLIES 5
A. Clay Stephenson
Acclaimed Contributor

Re: ulimit problem

Hi Gerald,

You need to run ulimit as the user in question and with the same shell. There is a 2GB limit if running ksh.

Clay
If it ain't broke, I can fix that.
A. Clay Stephenson
Acclaimed Contributor

Re: ulimit problem

Hi again,

You may also need to enable largefiles using fsadm but this limit does no appear until 2GB not 1GB. 1GB has to be a quota or ulimit restriction.

Regards, Clay
If it ain't broke, I can fix that.
A. Clay Stephenson
Acclaimed Contributor

Re: ulimit problem

Hi Gerald,

One more thought, anyone can open a file of any size; they just can't write a record that will grow the file beyond the ulimit/quota size. The other limit that can cause appends to fail is the amount of free and reserved space in the filesystem itself.

I learned long ago to pay very little attention to DBA's (and I'm pretty good with Oracle myself) when dealing with OS problems.
I think you need to get an accurate statement of the problem.

Hopefully, I have all my thoughts together now.


Clay
If it ain't broke, I can fix that.
Gerald Taylor
Frequent Advisor

Re: ulimit problem

I have checked that quota's and they are not on the VxFS filesystem. Is is possible I need to change parameters in the Kernal to increase the data subcatagory of the ulimit output. I am not sure what that means or how to change it but it seems pretty low.
A. Clay Stephenson
Acclaimed Contributor

Re: ulimit problem

Hi Gerald,

No kernel parameters are not your problem although maxdsiz and maxssiz are low for an Oracle server. These are related to memory and are not file size limits. It does appear that you ran ulimit as root. Run it as user oracle
(both -aS and -aH) and also determine that you are running the same shell. Please post those values and I think someone can spot the problem. I would do one more thing, if you have the room, write/copy or cat together a file a >1GB non-database file in the filesystem in question as an oracle user and see if that works. If it does, the problem is not is the OS/filesystem but in the database or oracle code itself. One other thing that could do this (and it is a guess) it that it the is Pro/C or Pro/XXX the application itself may be doing a ulimit(). You definitely need to find out what 'can't open a file > 1GB' really means.

Hope this helps, Clay
If it ain't broke, I can fix that.