ORA-01115, ORA-01110, ORA-27092
52748Apr 16 2003 — edited Apr 16 2003I 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.