SAP Note 8485 - Default limit for file size in AIX is 1 GB

Component : IBM AIX -

Solution : https://service.sap.com/sap/support/notes/8485 (SAP Service marketplace login required)

Summary :
The SAP Note addresses potential errors encountered with AIX file size limits affecting Oracle operations. Symptoms include export failures with oraunload displaying errors like exp-00015, exp-00222, and exp-00002. Oracle Tablespaces reorganization might terminate with ora-01119 or ora-07358 errors. Additional errors could be ora-07244, ora-07209, and IBM AIX error: 27. These issues can prevent database start/stop operations. The cause is typically files exceeding the 1 GB limit. The solution involves logging in as "root", querying the user limit, and modifying the "fsize" parameter using "chuser" or SMIT. Rebooting is recommended to activate changes. Setting default fsize to unlimited may be necessary.

Key words :
error messages exp-00015 export terminated unsuccessfullyexp-00222 system error messageexp-00002 error, creating database file         orora-07358 sfccf, ora-07244 file-size limit reached, displays 512 bytes blocksto change, additional key words exp15, aix file sizepossible symptoms, unlimited default file size, default file size limit, ibm aix error, error messages

Related Notes :

328785ORA-00376: File cannot be read at this time