I am getting the following error frequently.But once I shutdown the database & startup it works fine for some days & again I get the same error & aggain I do the shutdown & startup.Can anyone suggest how to avoid this error so as to prevent me in shutting down the database & startingup.
I am getting the same error in trace files for testckpt.trc,testlgwr.trc,testdbwo.trc,testpmon.trc & testsmon.trc.The name of the databse is test & the version is ORACLE 8.1.6 Running in WindowsN/T.This is a test databse & when some applications runs on this databse I am getting this error
CKPT: terminating instance due to error 1110
Instance terminated by CKPT, pid = 293
I found the following information on Metalink (a great place to look for information on specific errors):
1- A similar bug 953585 that is reporting similar issue. It seems that the issue is related to the timeout on the
checkpointing procedure. Please try their wrokaround of play around with init.ora parameters checkpoint_interval,
and any parameters you are setting for db buffers to isolate the problem to some degree.
The customer logging the bug has solved his issue by increasing the value of checkpoint_interval and the value of
2- In some cases, you may encounter an error such as:
Instance terminating due to error 1110.
Instance terminated by CKPT PID=505
A third party software, most likely a backup application, has locked a
datafile or logfile. We have seen this situation with Seagate Backup
Exec Software. When Oracle attempts to write to the file, the lock prevents
it and the database crashes.
It looks like the second scenario matches your problem pretty well.
ORA-01157: cannot identify/lock data file 17 - see DBWR trace file
ORA-01110: data file 17: 'J:\DATA11.ORA'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file.
Dump file o:\oracle816\admin\test\bdump\testDBW0.TRC
I am not seeing any other process locking.Once I do a cold boot of the system it works fine.Any suggestions are welcom
Re: your last post - we had seen this message (or one very similar) on NT when the Oracle database files had not been excluded from the system backups.
Ended up having to recover the database each time.