Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01115, ORA-01110, ORA-27092

52748Apr 16 2003 — edited Apr 16 2003
I have users executing an ksh script which creates an SQL*Plus report spooled to a file and they get this error. Is it only a matter of reading a data file?

$ ls -l
total 6245888
-rw-rw---- 1 oracle oinstall 50868224 Apr 15 13:55 customer_data01.dbf
-rw-rw---- 1 oracle oinstall 2411728896 Apr 15 13:55 order_data01.dbf
-rw-r----- 1 oracle oinstall 78643712 Apr 15 13:48 redo_03a.log
-rw-rw---- 1 oracle oinstall 243937280 Apr 15 13:55 wms_data01.dbf
-rw-rw---- 1 oracle oinstall 412188672 Apr 15 13:55 wms_idx_static01.dbf

select a.order_date, c.cust_name, count(b.ord_id)
*
ERROR at line 1:
ORA-01115: IO error reading block from file 13 (block # 35)
ORA-01110: data file 13:
'/u05/oradata/THLI/order_data01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of
the process
Additional information: 262143
Additional information: 588801

Then I have to address the other ora error regarding the size of file. If you have any insights into this, I'd be grateful.

ulimit yields unlimited for users. In /etc/security/limits:

default:
fsize = 2097151
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
nofiles = 2000


Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2003
Added on Apr 16 2003
1 comment
725 views