On Sunday I did an upgrade from Oracle7 to Oracle9; uninstalled Oracle7; rebooted; installed 22.214.171.124; installed patch 126.96.36.199; created database skeleton; imported user data from Oracle 7; and exported into Oracle 188.8.131.52. From what I view the database is not in archive log mode. Monday the database switches one log at 12:18 and one checkpoint happens at 14:21. Tuesday the database switches one log at 8:51 and one checkpoint at 10:55. At 15:22 the database crashes with ORA-00206, ORA-00202, ORA-27072, OSD-04008 and O/S Error (OS 33). The process cannot access the file because another process has locked a portion of the file. The file is the third control file.
On Wednesday, this exact same thing happens.
Do you know of any quirks in Windows that may cause this due to database settings or the Windows layer?
We do not have anti-virus software loaded on the server due to problems; the backups were excluding the database folder; and there are not any other pieces of software running that we know of to be trying to read this file. We do have TrackIT, but I was told this software reads the system-level info.
Thank you for your help.
This was first published in April 2006