On Sunday I did an upgrade from Oracle7 to Oracle9; uninstalled Oracle7; rebooted; installed 9.2.0.0; installed patch 9.2.0.4; created database skeleton; imported user data from Oracle 7; and exported into Oracle 9.2.0.4. 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.

    Requires Free Membership to View

It looks to me like you might have a non-Oracle problem here. The ORA-27072 error is telling me that a read or write call never returned from the operating system. This is not an Oracle problem. Either hardware is causing the problem, the operating system is causing the problem, or some other software is getting in your way. Try to turn off TrackIT and see if your problem goes away.

This was first published in April 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: