1890999 - ORA-01114 ORA-27072 occurs for Tempfiles

• The following error is encountered in the Alert.log file -:

           Errors in file
           /oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/trace/<SID>_ora_26826.trc
           (incident=44281):
           ORA-00603: ORACLE server session terminated by fatal error
           ORA-01114: IO error writing block to file 201 (block # 1166844)
           ORA-27072: File I/O error

• The below query does not produce any output.

          SQL> select file_name, tablespace_name, file_id, status from dba_data_files where file_id= 201
                    union all
                    select file_name, tablespace_name, file_id, status from dba_temp_files where file_id= 201;

Oracle Database , 10.2.0.5 to 11.2.0.3 Release

ORA-01114 ,ORA-27072, Temporary Tablespace , Tempfile , Corruption , KBA , BC-DB-ORA-DBA , Database Administration , Problem