- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle error HP-UX error 27
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
Discussions
Discussions
Forums
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
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
тАО09-05-2001 09:30 AM
тАО09-05-2001 09:30 AM
KCF: write/open error dba=0x6c01a2f9 block=0x1a2f9 online=0 file=27 /u08/ORACLE/fbs_prod/wip_index01.dbf error=7376 txt: 'HP-UX Error: 27: File too large
We are running HPUX 10.20 Oracle 10.7 and database 7.3.4 I have check the oracle meta link and all information points toward the ulimit. Result of ulimit by oracle user:$ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 65536
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 2048
Any help would be useful. If anyone is familiar with these types of messages perhaps an explanation of fields in the error message would be helpful. What is KCF, dba, block and file actually talking about. Thanks in advance.
Gerald
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2001 09:52 AM
тАО09-05-2001 09:52 AM
Re: oracle error HP-UX error 27
Unless large files is enabled, there is a 2GB limit.
...jcd...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2001 10:01 AM
тАО09-05-2001 10:01 AM
Re: oracle error HP-UX error 27
Gerald
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2001 10:15 AM
тАО09-05-2001 10:15 AM
Re: oracle error HP-UX error 27
Autoextend on the datafile could be the cause of the problem. It may be attempting to increase the size larger than the 2GB limit to allow for the index rebuild.
Unsure??
...jcd...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2001 10:27 AM
тАО09-05-2001 10:27 AM
Re: oracle error HP-UX error 27
My best guess is that you have autoextend on and maxsize set to > 2GB or unlimited. I seem to remember that the filesize limit is 2GB in Oracle 7.3 on 10.20. If Oracle can create a file larger than 2GB then you also need to enable largefiles when you mount the filesystem
or with fsadm. Do an ls -l on this file and let us know the current size. I'm betting it is somewhere near the limit now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2001 01:59 PM
тАО09-05-2001 01:59 PM
Re: oracle error HP-UX error 27
you could try this to see if the problem related to next extent, login as system to the database and issue this sql statement.
select owner, index_name, next_extent, pct_increase from dba_indexes
where next_extent > 1073741824;
This will tell you if any index will try to extend more than 1GB, you could lower the number. One of the reason that may cause this problem is pctincrease is not 0. If you see one with pctincrease not set to 0, change it to 0 then change next to something reasonable.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2001 08:55 PM
тАО09-05-2001 08:55 PM
SolutionUNIX errno values are associated with a symbolic name (like 5, EIO). The association between numeric value and symbol is defined in the include file /usr/include/sys/errno.h (see table below). The errno man page (which can be obtained with man 3 errno) provides an explanation for each errno symbol.
HP-UX error are usually caused by insufficient kernel parameters (and more seldom, index file corruption). If you encounter one of this ERRORs, you should get further information form the console or the syslog.
HP-UX errno values Errno value Symbol Description
1
EPERM
Not super-user (root).
2
ENOENT
No such file or directory
3
ESRCH
No such process
4
EINTR
interrupted system call
5
EIO
I/O error
6
ENXIO
No such device or address
7
E2BIG
Arg list too long
8
ENOEXEC
Exec format error
9
EBADF
Bad file number
10
ECHILD
No children
11
EAGAIN
No more processes
12
ENOMEM
Not enough core
13
EACCES
Permission denied
14
EFAULT
Bad address
16
EBUSY
Mount device busy
17
EEXIST
File exists
18
EXDEV
Cross-device link
19
ENODEV
No such device
20
ENOTDIR
Not a directory
21
EISDIR
Is a directory
22
EINVAL
Invalid argument
23
ENFILE
File table overflow
24
EMFILE
Too many open files
25
ENOTTY
Not a typewriter
27
EFBIG
File too large
28
ENOSPC
No space left on device
29
ESPIPE
Illegal seek
30
EROFS
Read only file system
31
EMLINK
Too many links
32
EPIPE
Broken pipe
45
EDEADLK
A deadlock would occur
46
ENOLCK
System record lock table was full
47
EILSEQ
Illegal byte sequence
Thanks
G Manikandan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2001 09:22 PM
тАО09-05-2001 09:22 PM
Re: oracle error HP-UX error 27
KCF errors are from the oracle kernel sub systems.
write/open error tells that the your datafile could not be opened and it gives the block no.
It could be that the specific file is locked by some backup utility at OS level.
Some non-Oracle process is locking portions of the datafiles at the O/S level.
or
you check your kernel parameters.
Thanks
G Manikandan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-06-2001 07:07 AM
тАО09-06-2001 07:07 AM
Re: oracle error HP-UX error 27
Autoextend is off on this datafile.
Here is the current size:
917512192 Sep 6 06:17 wip_index01.dbf
There are no indexes with next extent bigger than 2433024.
Thanks for all the current help. We still are having the same problem if anyone would like to add more I am all ears. Thanks