- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ulimit problem
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2001 08:58 AM
06-29-2001 08:58 AM
ulimit problem
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2001 09:10 AM
06-29-2001 09:10 AM
Re: ulimit problem
You need to run ulimit as the user in question and with the same shell. There is a 2GB limit if running ksh.
Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2001 09:12 AM
06-29-2001 09:12 AM
Re: ulimit problem
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2001 09:19 AM
06-29-2001 09:19 AM
Re: ulimit problem
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2001 09:46 AM
06-29-2001 09:46 AM
Re: ulimit problem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2001 10:07 AM
06-29-2001 10:07 AM
Re: ulimit problem
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