ORA-01116 during R3load import

[Former Member]

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 ?

[Former Member]

Solved.

These ulimit changes are effective only after the reboot of the machine

[sunny_pahuja2]

Hi,

You are facing this problem because of file size limit. Please check SAP note 553854 and 129439.

Thanks

Sunny

[Former Member]

The ulimits are as described in the OSS note suggested.

How can I check the status Large File Attributes?

whit the command lsfs -q, in AIX 6.1 suggested in the note 129439 I can see only:

/dev/IUTsapmnt -- /sapmnt/IUT jfs2 12189696 rw yes no

/dev/IUTusrsap -- /usr/SAP/IUT jfs2 20447232 rw yes no

/dev/IUToracle -- /oracle jfs2 262144 rw yes no

/dev/IUToracli -- /oracle/client jfs2 1310720 rw yes no

/dev/IUTstage0 -- /oracle/stage/102_64 jfs2 11272192 rw yes no

/dev/IUToracle_2 -- /oracle/IUT jfs2 393216 rw yes no

/dev/IUTora64 -- /oracle/IUT/102_64 jfs2 18612224 rw yes no

/dev/IUTorilgA -- /oracle/IUT/origlogA jfs2 1024000 rw yes no

/dev/IUTorilgB -- /oracle/IUT/origlogB jfs2 1024000 rw yes no

/dev/IUTmirrlogA -- /oracle/IUT/mirrlogA jfs2 1024000 rw yes no

/dev/IUTmirrlogB -- /oracle/IUT/mirrlogB jfs2 1024000 rw yes no

/dev/IUToraarch -- /oracle/IUT/oraarch jfs2 5767168 rw yes no

/dev/IUTreorg0 -- /oracle/IUT/sapreorg jfs2 3932160 rw yes no

/dev/IUTdata01lv -- /oracle/IUT/sapdata1 jfs2 409468928 rw yes no

/dev/IUTdata02lv -- /oracle/IUT/sapdata2 jfs2 409468928 rw yes no

/dev/IUTdata03lv -- /oracle/IUT/sapdata3 jfs2 409468928 rw yes no

/dev/IUTdata04lv -- /oracle/IUT/sapdata4 jfs2 409468928 rw yes no

/dev/IUTdata05lv -- /oracle/IUT/sapdata5 jfs2 409468928 rw yes no

/dev/IUTdata06lv -- /oracle/IUT/sapdata6 jfs2 409468928 rw yes no

/dev/IUTdata07lv -- /oracle/IUT/sapdata7 jfs2 409468928 rw yes no

/dev/IUTinterf1lv -- /interfacce jfs2 204734464 rw yes no

Thank you for your reply