|
-
Our two databases crash everynight. Both run on the same server and dont crash until the end of the day. The network admins swear no file backup is taking place on the system which seems to be the first answer to this issue. Any idea what else could be causing these file lock errors? The two databases are on the same system and didnt exeperience difficulty till last week sometime. You help is Greatly appreciated.
Alert Log says:
Wed Aug 22 19:45:16 2001
Errors in file C:\orant\rdbms80\trace\t1CKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'C:\ORANT\DATABASE\CTL1T1.ORA'
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 Aug 22 19:45:17 2001
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 270
Trace file says
*** 2001-08-21 19:44:29.796
*** SESSION ID:(4.1) 2001-08-21 19:44:29.781
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'C:\ORANT\DATABASE\CTL1T1.ORA'
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
Dump file C:\orant\rdbms80\trace\t1CKPT.TRC
Wed Aug 22 19:45:16 2001
ORACLE V8.0.6.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586
Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
PL/SQL Release 8.0.6.0.0 - Production
Windows NT V4.0, OS V5.101, CPU type 586
Instance name: t1
Redo thread mounted by this instance: 1
Oracle process number: 5
pid: 10e
Thanks
EJC
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|