Unable to start eHealth with Oracle ORA-01171 error

Products

• CA eHealth

Issue/Introduction

Issue: 

After reboot of OS, eHealth system.log shows the following error and fails to start.

 

Warning,ORA-27072,skgfdisp: I/O error

Warning,ORA-01115,IO error reading block from file 5 (block # 1)

Warning,ORA-01110,data file 5: \'D:\ORA_DATA\ORADATA\EHEALTH\NH_DATA01A.DBF\'

Warning,ORA-01171,datafile 5 going offline due to error advancing checkpoint

 

Cause: 

When starting Oracle DB, Oracle reads datafiles (*.dbf files). If Oracle can't read the datafile with an error (in this case OS I/O error), the datafile will move to offline status. Once the staus of the datafile is set to offline, you need to set online manually.    

 

Resolution:

Please set the erroneous datafile online with the following SQL.

 

sqlplus ehealth/<db password>

RECOVER DATAFILE '<Full Path of datafile>';

ALTER DATABASE DATAFILE '<Full Path of datafile>' ONLINE;

 

Example;

RECOVER DATAFILE 'D:\ORA_DATA\ORADATA\EHEALTH\NH_DATA01A.DBF';

ALTER DATABASE DATAFILE 'D:\ORA_DATA\ORADATA\EHEALTH\NH_DATA01A.DBF' ONLINE;

Environment

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: