If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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
Thanks
G.Suresh
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
_control_file_enqueue_timeout=2700

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.

Same problem repeating

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
Thanks

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.