Q

Database crashing after upgrade

On Sunday I did an upgrade from Oracle7 to Oracle9. 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. The process cannot access the file because another process has locked a portion of the file. Do you know of any quirks in Windows that may cause this?

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.

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close