Compare failed with error " ORA-01187: cannot read from file XXX" and "ORA-01110: data file "
Server log has following error :
006: Oracle Error 1187: ORA-01187: cannot read from file xxx because it failed verification tests
ORA-01110: data file xxx: '/dev/rM_TEMP_01'
006: Error 1187 calling OCIStmtExecute (de_select_prepare_to_fetch,L1490)
006: Error 1 calling de_select_prepare_to_fetch in de_batch_setup
In this scenario the problem is with the temp tablespace. It was corrupted hence the compare couldn't read from it.
Workaround:
Check the Temp tablespace and if there is corruption and datafiles cannot be read then the corruption needs to be fixed.
