如果自己搞不定可以找诗檀软件专业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