- 论坛徽章:
- 0
|
1.运行环境
OS: AIX 5.2
ORALCE:8.1.7
数据文件:'/data/ data01.dbf' 大小为10G
oralce用户与test用户在同一台机器上
2.oracle进程以oracle用户启动,启动正常
#>ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
3.以另一个用户登陆test,其中fsize=执行sqlplus查询语句报错
#>ulimit -a
time(seconds) unlimited
file(blocks) 2097151
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
#>sqlplus test/test
ORA-27092: skgfofi: size of file exceeds file size limit of the process
SQL> select * from tbl_trans_log;
select * from tbl_trans_log
*
ERROR at line 1:
ORA-01116: error in opening database file 9
ORA-01110: data file 9: '/data/ data01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 131071
Additional information: 896001
#检查联机交易进程(*.pc程序)日志,无任何数据库报错
4.调整test用户的fsize,重新执行上面的sql语句,无任何问题
#>ulimit -f unlimited
#>ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
5.fsize与访问数据库的终端用户关系?为什么执行sqlplus会报错,但后台交易进程(*.pc)没有数据库访问报错?请高手解释一下? |
|