Home » RDBMS Server » Server Administration » ORA-27092: skgfofi: size of file exceeds file size
ORA-27092: skgfofi: size of file exceeds file size [message #58532] Mon, 15 September 2003 17:05 Go to next message
Steve
Messages: 190
Registered: September 1999
Senior Member
I am getting the following message during some overnight batch processing.

I have read some relevant articles that point to using ulimit to increase the allowed file size to unlimited. I checked and it is already set to unlimited. I also checked both the Hard and Soft settings using ulimit. They are both set to "unlimited".

update log_detail
*
ERROR at line 1:
ORA-01116: error in opening database file 12
ORA-01110: data file 12: '/oracle/oradata/PRD/LEGACY_T01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 640001

Any help would be greatly appreciated.

Regards
Steve
Re: ORA-27092: skgfofi: size of file exceeds file size [message #58533 is a reply to message #58532] Mon, 15 September 2003 17:37 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Hi,

Increase the ulimit of your environment and then shutdown
and restart the database. You might also need to set some
kernel parameters to allow you to specify larger ulimit
values.

Here is Oracle's description of the error:

ORA-27092: 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

Best regards.

Frank
Re: ORA-27092: skgfofi: size of file exceeds file size [message #58534 is a reply to message #58533] Mon, 15 September 2003 18:35 Go to previous messageGo to next message
Steve
Messages: 190
Registered: September 1999
Senior Member
ulimit already reports that the filesize is unlimited. (Both hard and soft parameters).

It has been like that for a while.

NB. I checked ulimit as the user that starts/stops oracle.
Re: ORA-27092: skgfofi: size of file exceeds file size [message #61326 is a reply to message #58534] Wed, 14 April 2004 21:09 Go to previous messageGo to next message
sri
Messages: 154
Registered: February 2000
Senior Member
Hi,

Were you able to resolve this problem? What was the solution or fix?

Thanks,
Sridhar
Re: ORA-27092: skgfofi: size of file exceeds file size [message #398753 is a reply to message #58532] Fri, 17 April 2009 07:39 Go to previous messageGo to next message
ducasio
Messages: 38
Registered: November 2003
Member
Hi guys,
i am really interested in the solution of the problem if you have found any. I get the same error during loading a table with sqlldr. The strange thing is that i can load without problems in one instance(ORA_SID_1) but i can't load the same file on the other one(ORA_SID_2) executing the sqlldr from the same unix user and machine. I have unlimited file size limits(soft and hard) on the unix user "oracle" and on the unix user from where i execute the sqlldr. I want to add that the two files initORA_SID_1.ora and initORA_SID_2.ora are identical.

thanks in advance,
ducasio
Re: ORA-27092: skgfofi: size of file exceeds file size [message #398755 is a reply to message #398753] Fri, 17 April 2009 07:44 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Too dealy.

Your asking/replying very very old thread.

Quote:
ORA-27092: 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
Re: ORA-27092: skgfofi: size of file exceeds file size [message #398760 is a reply to message #58532] Fri, 17 April 2009 08:05 Go to previous messageGo to next message
ducasio
Messages: 38
Registered: November 2003
Member
I searched before on the forum per a possible solution of the problem and i didn't find one, except this thread.
As i described previously, i have unimited file size limits(soft and hard) for the unix user. And the strange thing is that from the same unix(aix) user i can load to one instance but not to the other one.
The file i want to load is about 800Mb.
Re: ORA-27092: skgfofi: size of file exceeds file size [message #398773 is a reply to message #398760] Fri, 17 April 2009 08:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> i have unimited file size limits(soft and hard) for the unix user
Please prove that.
Please prove that the environment settings are same for instances.
Post the relevant contents of /etc/security/limits
Re: ORA-27092: skgfofi: size of file exceeds file size [message #398786 is a reply to message #58532] Fri, 17 April 2009 09:27 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
http://www.dbforums.com/oracle/1641157-problem-during-executing-loader.html
Re: ORA-27092: skgfofi: size of file exceeds file size [message #398795 is a reply to message #58532] Fri, 17 April 2009 10:34 Go to previous messageGo to next message
ducasio
Messages: 38
Registered: November 2003
Member
for the user from where i execute loader:

# ulimit -a
time(seconds) unlimited
file(blocks) 10000000
data(kbytes) unlimited
stack(kbytes) unlimited
memory(kbytes) unlimited
coredump(blocks) 2097151
nofiles(descriptors) 2000

ulimit -s
unlimited

for the user oracle:

# ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
memory(kbytes) unlimited
coredump(blocks) 2097151
nofiles(descriptors) 2000

So any suggestions? File to load are are from 300Mb to 800Mb.

Re: ORA-27092: skgfofi: size of file exceeds file size [message #398868 is a reply to message #398795] Sat, 18 April 2009 14:51 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
How big the files are that you are trying to load is irrelevant, you most likely run into an error because of something else. But You never told us which error exactly.

Unfortunately my crystal ball is in the repair shop this week, so you will have to post the exact error you get.
Re: ORA-27092: skgfofi: size of file exceeds file size [message #399004 is a reply to message #58532] Mon, 20 April 2009 04:48 Go to previous messageGo to next message
ducasio
Messages: 38
Registered: November 2003
Member
Hi Thomas,
the error message i get from oracle during the execution of sqlldr is:
--------------
Record 77390: Rejected - Error on table MY_TABLE_NAME.
ORA-01116: error in opening database file 24
ORA-01110: data file 24: '/arch/oradata/undotbs1.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 625000
Additional information: 1024001

I can't explain the reason.
Re: ORA-27092: skgfofi: size of file exceeds file size [message #399008 is a reply to message #399004] Mon, 20 April 2009 04:56 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


What's your database verison (4 digit) ??

Babu
Re: ORA-27092: skgfofi: size of file exceeds file size [message #399019 is a reply to message #58532] Mon, 20 April 2009 05:19 Go to previous messageGo to next message
ducasio
Messages: 38
Registered: November 2003
Member
Operating System:
AIX Version 5.2


Database:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, Real Application Clusters and OLAP options
JServer Release 9.2.0.8.0 - Production

ducasio
Re: ORA-27092: skgfofi: size of file exceeds file size [message #399024 is a reply to message #399019] Mon, 20 April 2009 05:26 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Check Metalink Document: 271331.1

Babu
Previous Topic: undo blocks of killed session
Next Topic: drop a single datafile
Goto Forum:
  


Current Time: Wed Dec 07 05:08:51 CST 2016

Total time taken to generate the page: 0.21901 seconds