Skip to Content
Former Member
Feb 22, 2011 at 04:43 PM

ORA-01116 during R3load import


Hi dears,

we are doing a system copy with R3load method; THe export went fine , while the import does not work.

As the Sapinst is started it returns the errorr :

"DbSl Trace: Error 1116 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1116 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed



ORA-01116: error in opening database file 2

ORA-01110: data file 2: '/oracle/ABC/sapdata1/undo_1/undo.data1'

ORA-27092: size of file exceeds file size limit of the process

Additional information: 262143

Additional information: 263681

(DB) INFO: disconnected from DB

We already check the ulimits of the abcadm and oraabc users, and for the root user too; we check note 553454 and is ok too.

We are on AIX, Oracle 10204 latest bundle patch.

What could be the reason ?