Tuesday, March 10, 2015

Oracle 10g R2 -- ORA-27092: size of file exceeds file size limit of the process

Problem

On a Solaris box, while logging into RMAN you get an error similar to the below:

oracle@myhost$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Mar 10 07:47:19 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06003: ORACLE error from target database:
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/oradata/controlfile/control01.ctl'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 1
Additional information: 713


Solution

The cause probably is an undersized file size limit. Check your shell's ulimit parameters:

oracle@myhost$ ulimit -a
core file size          (blocks, -c) unlimited
data seg size           (kbytes, -d) unlimited
file size               (blocks, -f) 22
open files                      (-n) 1024
pipe size            (512 bytes, -p) 10
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 29995
virtual memory          (kbytes, -v) unlimited

Increase the file size limits.

No comments: