on 02-22-2011 4:43 PM
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 ?
Solved.
These ulimit changes are effective only after the reboot of the machine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You are facing this problem because of file size limit. Please check SAP note 553854 and 129439.
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.