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
I had the same problem. The NT server where Oracle is running is backed up every night. When the control file was backed up, it was locked exclusively by the backup software (veritas). So it is not available to oracle. Now I shutdown the database and restart again after the back up, every night using a batch file .
If any of the prvious messages don't help try looking at your antivirus software. Your server might be scanning your db files at a certain time everynight. Thus locking the files and causing Oracle to crash.
There doesnt seem to be any other posibility other than disk_asynch_io is set to true. NO backups are scheduled and no virus scan runs on the server. I set it to false and willl see what happens tonight.
Crashed again...i noticed only two control files in the databases. I will try adding a control file. I dont think this will work as the error always occurss on the first control file. I can find no software which is scanning or backing up the software. Both databases tend to go down at the same time, although they can go down seperately.
I think its time for you to stay late and find out what programs and sessions that get opened at this time of crash. Do you have any background dbms jobs, Do you hane any OEM event that are set to execute at this time of the day? What are the other applications that would use the server at the time of crash. Are you folks using any filer for the backend storage of the database files ?
Yeah, it sounds a little too freaky that both databases go down at the same time. Are the two systems sharing a filesystem that contains a controlfile maybe?
Originally posted by tk_dba I had the same problem. The NT server where Oracle is running is backed up every night. When the control file was backed up, it was locked exclusively by the backup software (veritas). So it is not available to oracle. Now I shutdown the database and restart again after the back up, every night using a batch file .
You shutdown every day your DB and restart it on the next day, really?
Reply With Quote
Have you found a solution?
Bookmarks