- 论坛徽章:
- 0
|
本帖最后由 剑次狼 于 2011-05-19 14:06 编辑
主机AIX重启系统后拉起数据库后正常,估计创建数据库时没设置ulimit??
生成环境是AIX Version 6.1
oracle用户限制无:
[oracle@DB01 ~]$ulimit -a
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) unlimited
pipe size (512 bytes, -p) 64
stack size (kbytes, -s) hard
cpu time (seconds, -t) unlimited
max user processes (-u) 128
virtual memory (kbytes, -v) unlimited
$ls -al /u01/app/oracle/oradata/db/db01.dbf
-rw-r----- 1 oracle dba 2027757568 May 16 20:03 /u01/app/oracle/oradata/db/db01.dbf
数据库版本是:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
但是表空间不能自动扩展,写入数据时报
ORA-01110: data file 5: '/u01/app/oracle/oradata/db/db01.dbf'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 131071
Additional information: 247529
用oracle管理工具去手工扩展也报错,还请大家帮忙指点下为什么不能自动扩展表空间呢?请问该如何解决这个问题?
是生成环境,不能自动扩展表空间不是要人命吗。
|
|