Unable to access database

[Roshan]

Hello Erman,

when I am accessing sqlplus, I am getting:

database1.PNG

I 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

[Roshan]

It's a database 12C on Windows server R12

[ErmanArslansOracleBlog]

In the first look, it seems the Oracle database is unable to access the files due to the OS(IO layer) errors.

Check event log of Windows? Is this the situation or not?  I mean , check that, the disks where redo files and datafiles are located can be accessed by Oracle Database without any issue..

[Roshan]

In fact I have contacted the people in datacentre. There  was an issue with the SAN. I did not see issues in Event Viewer log.

[ErmanArslansOracleBlog]

So they fixed the issue now?

[Roshan]

The database instance was down when I got this error in alert log. I restarted it. I will investigate to know exactly the issue on the server.