| ORA-27092: skgfofi: size of file exceeds file size [message #58532] |
Mon, 15 September 2003 17:05  |
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  |
Frank Naude
Messages: 4581
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 #398753 is a reply to message #58532] |
Fri, 17 April 2009 07:39 |
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 #398760 is a reply to message #58532] |
Fri, 17 April 2009 08:05 |
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 #398795 is a reply to message #58532] |
Fri, 17 April 2009 10:34 |
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 |
ThomasG
Messages: 3212
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 |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
