couldn't create SQL Plus spool file larger than 2 gb

[Arockia Jegan]

I'm having oracle 8.1.7 running on v class(hpux 11.11) system. The file system are setup with largefiles options. Ulimit is setup to unlimited.
# ulimit -Sa
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 262144
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 256

#ulimit -Ha
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 262144
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 1024

I don't have any problem to write/create larger than 2Gb file as a oracle or any other user.

But we couldn't create SQL plus spool files larger than 2 Gb. I know that we are having following work around for this problem,

1) mkfifo temp
2) dd if=temp of=spool &

Even I found some other ways(in this forum) to resolve this issue.

My question is here,

Is there any other way we can resolve this large files issue by doing some changes in the application(SQL/Oracle) configuration files?

[Carlos Fernandez Riera · Accepted solution]

See oracle's metalink:


Bug:1715763

Regards.

[Patrick Preuss]

hi,

are your fs in largefile mode.

# fsadm /dev/vg01/rlvol_u01

output should contain
largefiles

if not try

# fsadm -o largefiles /dev/vg01/rlvol_u01

regards
-PP