| HELP! Control files locked! Instance shuts down! [message #51418] |
Wed, 22 May 2002 06:54  |
John Fekula
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
HELP!
I am simply out of ideas. About every 3 days or so our production DB shuts down. We are running Oracle 8.1.7 on Windows 2000. I thought it was backup related, but it's shutting down even when no backup is running. Somehow the controlfile is becoming locked and not released. Below is the info from the alert file and trace file. Any help would be greatly appreciated because I am officially stumped!
Alert file ----------
Thread 1 advanced to log sequence 4658
Current log# 2 seq# 4658 mem# 0: D:ORACLEORADATAPRISMPA2REDO02.LOG
Wed May 22 09:51:11 2002
ARC0: Beginning to archive log# 1 seq# 4657
ARC0: Completed archiving log# 1 seq# 4657
Wed May 22 09:54:15 2002
Errors in file D:oracleadminPRISMPA2bdumpprismpa2CKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'D:ORACLEORADATAPRISMPA2CONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
Wed May 22 09:54:15 2002
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 2236
trace file ------
*** 2002-05-22 09:54:15.838
*** SESSION ID:(4.1) 2002-05-22 09:54:15.823
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'D:ORACLEORADATAPRISMPA2CONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
error 221 detected in background process
|
|
|
|
| Re: HELP! Control files locked! Instance shuts down! [message #51425 is a reply to message #51418] |
Wed, 22 May 2002 10:26  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
I would start by replacing 'D:ORACLEORADATAPRISMPA2CONTROL01.CTL' with one of your other control files if this one keeps causing the problem. This would be to make sure your control file isn't corrupt. You would do this by:
Note: all control files are the same so you can copy them.
1. shut it down
2. rename CONTROL01.CTL to CONTROL01.CTL_OLD
3. copy CONTROL02.CTL to CONTROL01
4. start it back up.
If you continue to have the problem make sure there isn't another database using the same file/directory. If so fix it. If neither of these options fix the problem call Oracle Support.
|
|
|
|
|
|
| Re: HELP! Control files locked! Instance shuts down! [message #52232 is a reply to message #51418] |
Wed, 10 July 2002 07:50 |
Moutts
Messages: 8
Registered: December 2001
|
Junior Member |
|
|
HI,
Have you found any solution to your problem. Because iam also having the same problem...My development server is going down everyday at 11:23 PM. Im still struggling to fix the problem. It is a similar problem like yours...if you had found any solution for that, please share it with me...Im stuck with this almost 2 weeks...
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
