topic Re: datafile larger then 2048 Mo in Operating System - HP-UX

datafile larger then 2048 Mo

bruandet — Fri, 07 May 2004 04:14:41 GMT

Hello,
Following install ORACLE 9;
The DBA with created files superior to 2048 Mo. And no error.Then the data were imported successfully and no error. But when the dBa makes a copy of table in sql it obtains this message:

ERROR at line 1:
ORA-01116: error in opening database file 6
ORA-01110: data file 6: '/U02/oradata/GPF/users01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 448001
--------------------
J looked at the value of ulimit and:

# uxsar13:/> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 29296
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 1500

What to make? and why 262143 (2 Go)
and when DBA reduce file under 2 Go, that working !

regards.
Julien.

Re: datafile larger then 2048 Mo

Jean-Luc Oudart — Fri, 07 May 2004 04:22:08 GMT

This is explained (somewhat) in metalink noteid 124822.1

I guess your oracle block size is 8Kb.

1) What is the user used for the SQL copy (Unix user , local or remote)

2) What is the ulimit of this user ?
ulimit for the user who starts the listener ?

3) Shell used : ksh or POSIX shell ?

Regards,
Jean-Luc

Re: datafile larger then 2048 Mo

Nicolas Dumeige — Fri, 07 May 2004 04:22:18 GMT

Bonjour Julien,

Take a look at this thread :
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=550089

Same thing with oerr
ksh> oerr ora 27092
27092, 00000, "skgfofi: size of file exceeds file size limit of the process"
// *Cause: an attempt was made to open a file that exceeds the process's
// file size limit (ulimit), additional information shows the current
// limit (logical blocks) and the size of the file (logical blocks)
// *Action: increase the processes file size limit (ulimit) and retry

It's seems that the problem is with ulimit, whether it's not tested for the Oracle user or because there is a flaw in ksh.

Cheers

Nicolas

Re: datafile larger then 2048 Mo

bruandet — Fri, 07 May 2004 04:42:58 GMT

I check 124822.1 in metalink.
And my db block size is 8kb.

1) user for sql copy is Unix user local (gpfadm)
and when I do ulimit -a for this user I have :

gpfadm:/home/gpfadm > ulimit -a
ksh: ulimit: bad option(s)

and when I do ulimit
gpfadm:/home/gpfadm > ulimit
4194303

user who launch oracle is oracle9 and when I do ulimit thas is same of user gpfadm
:ulimit -a
ksh: ulimit: bad option(s)
ulimit
4194303

3) Oracle are installed whith user oracle9 in sh, but that I chosse then in Ksh.

Re: datafile larger then 2048 Mo

Jean-Luc Oudart — Fri, 07 May 2004 05:00:39 GMT

Use POSIX-shell
and try again

Regards,
Jean-Luc

Re: datafile larger then 2048 Mo

T G Manikandan — Fri, 07 May 2004 09:23:00 GMT

I would check the below things

1.check the .profile file of the oracle user to see whether the oraenv script is present in the startup file.

THis oraenv file sets the ulimit value as 4194303
.

Remove the script from .profile or change the script from "4194303
" to "unlimited" in the "if condition".
If that is not present.

2.Load the patches
PHCO_26783 (11.00)
PHCO_27019 (11.11)
which should make the ulimit values for ksh to unlimited.

Revert

Re: datafile larger then 2048 Mo

T G Manikandan — Fri, 07 May 2004 09:25:51 GMT

This is a bug with oracle.check the attached metalink note

Re: datafile larger then 2048 Mo

bruandet — Fri, 07 May 2004 09:27:19 GMT

THank you very much !
I install patch PHCO_26738 and I resolve my problem !

Re: datafile larger then 2048 Mo

Fred Ruffet — Fri, 07 May 2004 09:40:26 GMT

In a more general way, try to be compliant with the metalink document ID 169706.1. It is oftenly updated and is a good references for needed patches.

Regards,

Fred