-
Hi all,
I have a 7.3.4 database that run on winNT4.0 platform. There isn't any scheduled jobs in this database or in NT. But periodically, on every sunday, I find an error messages in DBWR trace file. The content is as follows:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
*** 2001.11.25.09.08.46.261
*** SESSION ID:(2.1) 2001.11.25.09.08.46.241
KCF: write/open error dba=0x300da91 block=0xda91 online=1
file=3 E:\ORANT\DATABASE\MOT\APP1MOSY.ORA
error=9215 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file.
'
error 1242 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 3 (block # 55953)
ORA-01110: data file 3: 'E:\ORANT\DATABASE\MOT\APP1MOSY.ORA'
ORA-09215: sfqio: error detected in IOCompletionRoutine
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 33) The process cannot access the file because
another process has locked a portion of the file.
Dump file e:\orant\database\trace\motDBWR.TRC
Sun Nov 25 23:03:23 2001
ORACLE V7.3.4.0.0 - Production vsnsta=0
vsnsql=b vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586
Oracle7 Workgroup Server Release 7.3.4.0.0 - Production
With the distributed option
PL/SQL Release 2.3.4.0.0 - Production
Windows NT V4.0, OS V5.101, CPU type 586
Instance name: mot
Redo thread mounted by this instance: 1
Oracle process number: 3
pid: 4c
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
I dont know what this error mean. I have checked v$locked_objects that nothing is locked.
-
Have you bounced the DB after this error?
If it comes back succsessfully then probably some OS job (backup or something) is locking that datafile at that particular time.
Sanjay
-
No, I cannot connect to the database after that. When I use sqlplus to connect, the error appears again:
ORA-00472: PMON process terminated with error
Then if I "shutdown immediate" the database, it hangs. I need to "shutdown abort" the database and then restart it.
-
If you can restart the database later means the datafile is not corrupted.
The file is not accesible only at that particular time. Look for any other OS job that may be running and locking the file.
Sanjay
