Oracle 在undo和临时文件上间歇的ORA-1116, ORA-1110 和ORA-27092 错误

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com

 

 

ORA-01116 oerr ora 1116
01116, 00000, “error in opening database file %s”
// *Cause: Usually the file is not accessible.
// *Action: Restore the database file.

ORA-27092 oerr ora 27092
27092, 00000, “size of file exceeds file size limit of the process”
// *Cause: an attempt was made to open a file that exceeds the process’s
// file size limit (ulimit), additional information shows the current
// limit (logical blocks) and the size of the file (logical blocks)
// *Action: increase the processes file size limit (ulimit) and retry

 

 

适用于:

Oracle Database – Enterprise Edition – 版本9.2.0.1 及以上
本文信息适用于任何平台。
***28-Sep-2014检查相关性***

症状

在alert.log中,undo和临时文件上报告间歇的ORA-1116,ORA-1110 和ORA-27092:

ORA-01116: error in opening database file 2
ORA-01110: data file 2: ‘/u01/app/oracle/oradata/orcl/undo/undo01.dbf’
ORA-27092: size of file exceeds file size limit of the process
Additional information: 131071
Additional information: 1048577

ORA-01116: error in opening database file 10
ORA-01110: data file 10: ‘/u01/app/oracle/oradata/orcl/temp/temp01.dbf’
ORA-27092: size of file exceeds file size limit of the process
Additional information: 131071
Additional information: 1572865

原因

拥有Oracle安装的Unix用户的用户资源限制(例如’oracle’)是正确的,但拥有第三方应用的另一个Unix用户的用户资源限制(例如Patrol,由Unix用户’sapatrol’拥有)太低。

% ulimit -Sa
time(seconds) unlimited
file(blocks) 2097151
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
threads(per process) unlimited
processes(per user) unlimited

解决方案

增加拥有第三方应用的Unix用户的用户资源限制

要这么做,使用ulimit命令

例如,要将软’data’ 和’stack’ 限制设为unlimited ,使用命令:

% ulimit -d unlimited
% ulimit -s unlimited
要将硬’data’ 和’stack’ 限制设为unlimited ,使用命令:

% ulimit -Hd unlimited
% ulimit -Hs unlimited
获取有关ulimit命令的更多帮助,参见 Note:188149.1 或’ulimit’ 手册页:

% man ulimit

参考

NOTE:188149.1 – How to Display and Change UNIX Process Resource Limits
NOTE:165282.1 – ORA-27092 if ULIMIT Small on Client OS User

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号