Posts

Showing posts from August 20, 2017

ORA-08102: index key not found

Issue: In my alert log file i found several errors like below ones, Sun Aug 20 06:22:57 2017 Errors in file /oracleSID/diag/rdbms/SID/SID/trace/SID_j000_17106.trc: ORA-01114: IO error writing block to file  (block # ) Sun Aug 20 09:00:01 2017 Errors in file /oracleSID/diag/rdbms/SID/SID/trace/SID_j000_18872.trc: ORA-01114: IO error writing block to file  (block # ) Errors in file /oracleSID/diag/rdbms/SID/SID/trace/SID_j000_18872.trc: ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-01114: IO error writing block to file  (block # ) ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073 ORA-06512: at line 1 Sun Aug 20 11:15:42 2017 Thread 1 cannot allocate new log, sequence 12922 Wed Aug 23 22:14:22 2017 Errors in file /oracleSID/diag/rdbms/SID/SID/trace/SID_m001_26283.trc: Wed Aug 23 22:14:27 2017 Dumping diagnostic data in directory=[cdmp_20170823221427], requested by (instance=1, osid=26283