DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DBWR Error

  1. #1
    Join Date
    Oct 2001
    Posts
    34
    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.
    _____________________________
    Loren

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  3. #3
    Join Date
    Oct 2001
    Posts
    34
    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.
    _____________________________
    Loren

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width