Operating System - HP-UX
1747984 Members
4607 Online
108756 Solutions
New Discussion юеВ

Re: "HPUX-ia64 Error: 27: File too large"

 
GSK_2
Advisor

"HPUX-ia64 Error: 27: File too large"

Hi Guys,

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
10 REPLIES 10
Yogeeraj_1
Honored Contributor

Re: "HPUX-ia64 Error: 27: File too large"

hi Satish,

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
GSK_2
Advisor

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
Yogeeraj_1
Honored Contributor

Re: "HPUX-ia64 Error: 27: File too large"

hi again,

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
GSK_2
Advisor

Re: "HPUX-ia64 Error: 27: File too large"

Hi Yogeeraj,

We have already created 12GB file on this FS without any problem.

Regards,
Satish
Patrick Wallek
Honored Contributor

Re: "HPUX-ia64 Error: 27: File too large"

Are you absolutely sure the filesystem on this LV was created as largefiles?

What does the following return:

# fsadm -F vxfs /u51
Hein van den Heuvel
Honored Contributor

Re: "HPUX-ia64 Error: 27: File too large"

Satish,

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
Yogeeraj_1
Honored Contributor

Re: "HPUX-ia64 Error: 27: File too large"

hi again,

After you run Patrick's test, can you try to create a test tablespace on this file system?

e.g.

CREATE TABLESPACE LARGE01 DATAFILE
'//large_datafile.dbf' SIZE 4096M AUTOEXTEND ON NEXT 50M MAXSIZE 33554416K
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
/

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: "HPUX-ia64 Error: 27: File too large"

Hi again,

can you also post your create index script?

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
GSK_2
Advisor

Re: "HPUX-ia64 Error: 27: File too large"

Hi,

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