we use oracle9i database. and since last week my oracle crash many times, after running for 30 hours more or less. we see errors repeat in my trc file and alert log :
qmhGetHTTPError: Got unknown oracle error. Error stack is: ORA-00942: table or view does not exist
we do not find the exact table or view does not exist. if we upgrade our database to oracle 10g or 11g,will solve the problems? I found some error another log,
error 1242 detected in background process ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01114: IO error writing block to file 16 (block # 156925) ORA-01110: data file 16: 'D:\ORACLE\ORADATA\SDH\SDH_DATA4.ORA' ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() O/S-Error: (OS 1450) will above implies hard disk error? anyone gets an idea? thanks for all.