Solution : https://service.sap.com/sap/support/notes/553854 (SAP Service marketplace login required)
Summary :
This SAP Note identifies common errors occurring from file size limits during operations such as database file creation, export dumps, and system reorganizations. It specifies that failures like EXP-00002 and ORA-01157 arise due of surpassing file size limitations set by operating systems or Oracle parameters. Solutions include configuring SAPDBA and BR tools with correct file size parameters, ensuring that system-level limits like 'ulimit' are adequately set, and updating Oracle versions or parameters where necessary. Verification of file system configurations on Unix systems (like HP-UX) for large file capability is also recommended.
Key words :
write/open error block=0x40209 online=1 file=<file_nr> <file> error=27072 txt, older oracle releases partially limited, creating database file '<file>'osd-04005, creating database file '<file>'ora-19510, write error onfile <file_nr>, export fileerror closing export fileexp-00000, file exceeds file size limit, 262665'automatic datafile offline due, invalid argument<unix> error, maximum file size permitted
Related Notes :
| 592393 | FAQ: Oracle |
| 387723 | Incorrect ulimit values with AT command |
| 129439 | Maximum file sizes with Oracle |
| 72105 | SAPDBA: Profile parameter max_file_size |
| 20823 | R3trans termin.: Cannot write to datafile any more |
| 12741 | Current versions of BR*Tools and SAPDBA |