List,
I have users executing an ksh script which calls an SQL*Plus script and they get this error. Since it is only a matter of reading a data file, can we give users permission to read this file, so they can execute the query in the ERP environment or does it pose a threat?
$ 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.
In /etc/security/limits:
default:
fsize = 2097151
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
nofiles = 2000
Thanks!
I have users executing an ksh script which calls an SQL*Plus script and they get this error. Since it is only a matter of reading a data file, can we give users permission to read this file, so they can execute the query in the ERP environment or does it pose a threat?
$ 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.
In /etc/security/limits:
default:
fsize = 2097151
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
nofiles = 2000
Thanks!