- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: "HPUX-ia64 Error: 27: File too large"
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
тАО05-16-2007 12:35 AM
тАО05-16-2007 12:35 AM
"HPUX-ia64 Error: 27: File too large"
We are getting these erroe while creating indexes in the database as oracle user. The mount point to where these creation is taking place has large files enabled. I have checked ulimit as well. Is that anything i still need to do to make the oracle team going ahead with creating indexes.
Error Begin ==>
ORA-12801: error signaled in parallel query server P004
ORA-27059: could not reduce file size
HPUX-ia64 Error: 27: File too large
Additional information: 2
ORA-27059: could not reduce file size
HPUX-ia64 Error: 27: File too large
=======
ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 4293702676
stack(kbytes) 131072
memory(kbytes) unlimited
coredump(blocks) 4194303
=======
When i checked for this ("ORA-27059: could not reduce file size")error in google.
It gave these info:
ORA-27059: could not reduce file size
Cause: ftruncate system call returned error
Action: check errno
Can you please advice as to what needs to be done to get past this error. Thanks in advance.
Regards,
Satish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 12:43 AM
тАО05-16-2007 12:43 AM
Re: "HPUX-ia64 Error: 27: File too large"
please clarify:
1. Is the file system NFS mounted?
2. Do you have enough free space available on the file system?
3. what is the approximate size of the index which you are trying to create?
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 01:00 AM
тАО05-16-2007 01:00 AM
Re: "HPUX-ia64 Error: 27: File too large"
Hi,
We have sufficient space left on filesystem.
The size of the FS is 445Gig and it is now 12% used. It is a local FS. The size of the indexes which are getting created is 3gb.
Just for info
/dev/u51/lvol1 /u51 vxfs rw,suid,largefiles,delaylog,datainlog 0 2
Regards,
satish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 01:09 AM
тАО05-16-2007 01:09 AM
Re: "HPUX-ia64 Error: 27: File too large"
can you do a simple copy test to confirm if this is an Oracle or OS issue?
cp /u51/tmp
you may take any huge file (preferrably greater than 3GB)
In case of an OS issue, the error will pop-up as soon as you press enter.
revert.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 01:24 AM
тАО05-16-2007 01:24 AM
Re: "HPUX-ia64 Error: 27: File too large"
We have already created 12GB file on this FS without any problem.
Regards,
Satish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 01:26 AM
тАО05-16-2007 01:26 AM
Re: "HPUX-ia64 Error: 27: File too large"
What does the following return:
# fsadm -F vxfs /u51
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 01:31 AM
тАО05-16-2007 01:31 AM
Re: "HPUX-ia64 Error: 27: File too large"
Sound to me like Oracle is confused about the actual datafile sizes. Maybe you want to query those and compare with actuals?
Talk to us some more about the commands used and the tablespaces/datafile uses.
The error occurs on a CREATE INDEX?
Are the datafiles pre-allocated or growing?
Using Oracle ASM, Raw, LVM, Filesystems ?
Which Oracle version?
A google for this message brought up a topic with 'Veritas QuickIO'. I don't suppose that applies here?
Also, the error suggests you are using degrees of parralel to create the index.
If you do a 'normal' create, does it work albeit slower?
Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 01:34 AM
тАО05-16-2007 01:34 AM
Re: "HPUX-ia64 Error: 27: File too large"
After you run Patrick's test, can you try to create a test tablespace on this file system?
e.g.
CREATE TABLESPACE LARGE01 DATAFILE
'/
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
/
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 01:38 AM
тАО05-16-2007 01:38 AM
Re: "HPUX-ia64 Error: 27: File too large"
can you also post your create index script?
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2007 01:44 AM
тАО05-16-2007 01:44 AM
Re: "HPUX-ia64 Error: 27: File too large"
The above fsadm command gave largefiles as output.
Yes, while creating the index.
The index size is around 3gb...
The filesystem is LVM
The error occured at the time of create index
we are running in parallel processes to make it fast...
oracle version is 10.2
the datafiles are growing...
Regards,
Satish