Solution : https://service.sap.com/sap/support/notes/546006 (SAP Service marketplace login required)
Summary :
SAP Note addresses issues with Oracle error codes starting ORA-270xx affecting file operations including access, status retrieval, and write capabilities. Various ORA errors indicate specific failures in interaction with database files such as control files and redo logs. For instance, ORA-27037 to ORA-27072 series details problems from securing file status to I/O errors. Subsequent OS and Unix errors illustrate systemic or environmental constraints like lack of space or permission denials impacting file operations. The solution recommends ensuring no external processes conflict with Oracle file access, checking for sufficient filesystem space, verifying directory accessibility, and confirming file existence to mitigate these errors.
Key words :
customer component bc-db-ora oracle priority recommendations / additional info category, redo log write error block <block> count <count>ora-00346, redo log read error block <block> count <count>ora-00334, write/open error block=<block> online=1error=27041 txt, digital unix / compaq tru64 unixthe error messages, os kernel parameter recommendations 138816 oracle archiver stuck, br tools 391 archiver stuck 129439 maximum file sizes, os kernel parameter recommendations 12741 current versions, resource temporarily unavailable 365481 block corruptions 201302 ora-1115/27072, identify/lock data file <datafile>ora-01565
Related Notes :
| 980152 | DB reports I/O error after inst of AIX 5.3 TL 05, 06, 07, 08 |
| 977410 | Oracle error after upgrade to AIX 5.3 TL05 |
| 743328 | Composite SAP note: ORA-27102 |
| 659946 | FAQ: Temporary tablespaces |
| 651351 | BR tools on UNIX: Error due to executable permissions |
| 583861 | UNIX: Errors due to Oracle executable |
| 564783 | Addit. Info. for Win NT/2000 for upgrade to Oracle 8.1.7.4 |
| 548221 | Temporary Files are created as sparse files |
| 491160 | Restore scenarios for lost files of oracle databases |
| 365481 | Block corruptions |
| 328785 | ORA-00376: File cannot be read at this time |
| 210385 | AIX 4.3.3: error: 11: Resource temporarily unavailable |
| 201302 | ORA-1115/27072 I/OError on Solaris f. data file>2GB |
| 172747 | SAP on HP-UX: OS kernel parameter recommendations |
| 138816 | Oracle Archiver stuck on HP/UX 11 |
| 137707 | ORA-27069 for convert.sql on NT-INTEL |
| 129439 | Maximum file sizes with Oracle |
| 23345 | Consistency check of ORACLE database |
| 12741 | Current versions of BR*Tools and SAPDBA |
| 8812 | Increasing max. number of data files in Oracle |
| 391 | Archiver stuck |