Posted by
Roshan on
Oct 28, 2016; 10:30am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Unable-to-access-database-tp1464.html
Hello Erman,
when I am accessing sqlplus, I am getting:
database1.PNGI checked the alert logs:
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_lgwr_7056.trc:
ORA-00345: redo log write error block 31274 count 10
ORA-00312: online log 2 thread 1: 'E:\ORADATA\LFICHE\REDO02.LOG'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:44 2016
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_ckpt_5376.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL02.CTL'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:45 2016
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_ckpt_5376.trc:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL02.CTL'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:45 2016
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_arc1_7592.trc:
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:45 2016
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_arc0_6256.trc:
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:45 2016
System state dump requested by (instance=1, osid=5376 (CKPT)), summary=[abnormal instance termination].
Fri Oct 28 14:00:45 2016
System State dumped to trace file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_diag_7908_20161028140045.trc
Fri Oct 28 14:00:45 2016
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_arc2_6516.trc:
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:46 2016
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_arc0_6256.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:46 2016
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_arc1_7592.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:45 2016
USER (ospid: 5376): terminating the instance due to error 221
Fri Oct 28 14:00:48 2016
Errors in file E:\APP\ORA12C\diag\rdbms\lfiche\lfiche\trace\lfiche_arc2_6516.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'E:\ORADATA\LFICHE\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Fri Oct 28 14:00:50 2016
opiodr aborting process unknown ospid (8912) as a result of ORA-1092
Fri Oct 28 14:00:54 2016
ORA-1092 : opitsk aborting process
Fri Oct 28 14:00:55 2016
opiodr aborting process unknown ospid (8844) as a result of ORA-1092
Fri Oct 28 14:00:55 2016
ORA-1092 : opitsk aborting process
Fri Oct 28 14:01:01 2016
opiodr aborting process unknown ospid (9124) as a result of ORA-1092
Fri Oct 28 14:01:01 2016
ORA-1092 : opitsk aborting process
Fri Oct 28 14:01:26 2016
Instance terminated by USER, pid = 5376
Maybe there is hardware error.
Thanks,
Roshan