Ask the Expert

Errors causing Oracle instance to shut down

I'm running Oracle 9i on Windows 2000. I found the below messages in the Alertlog and LGWR logs. The Oracle instance shut down because of those errors. Any ideas? All the online redo files are in place.

*** 2004-11-10 02:00:58.000
*** SESSION ID:(3.1) 2004-11-10 02:00:58.000
ORA-00321: log 3 of thread 1, cannot update log file header
ORA-00312: online log 3 thread 1: 'E:ORACLEORADATADMDBxFREDO03.LOG'
ORA-27091: skgfqio: unable to queue I/O
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 32) The process cannot access the file because it is
being used by another process.
error 321 detected in background process
ORA-00321: log 3 of thread 1, cannot update log file header

    Requires Free Membership to View

Some process has a hook into the redo log file mentioned above. If you are not sure which process, then I would recommend rebooting your Windows server. That will clear up all processes. The Oracle database should then be able to access this file.

This was first published in November 2004

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: