Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Question Unanswered: Oracle Crash ORA-00345

    Oracle crashes with following error message. It is a Windows 2000 server. We just installed Oracle in this server and created 1 database and OEMREP database. No other activity on this database. We are running Oracle 9.2.0.1.0

    Errors in file d:\oracle\admin\oemrep\bdump\oemrep_lgwr_1964.trc:
    ORA-00345: redo log write error block 106927 count 1
    ORA-00312: online log 1 thread 1: 'D:\ORACLE\ORADATA\OEMREP\REDO01.LOG'
    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.

    We have ensured that there are no backup process or virus scan are running in this machine. We can not think of any process which will lock this file. Any help on this is greatly appreciated.
    Last edited by ravi101; 02-11-04 at 14:25.

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Something has it locked. Maybe another instance?

  3. #3
    Join Date
    Jan 2004
    Posts
    370
    I would doubt if another instance has this log file locked.

    There is a program which allows you to see the programs that have a particlar file or directory open.

    You can get it here:

    http://www.sysinternals.com/ntw2k/freeware/handle.shtml

    Just make sure the database is closed when you run it.

  4. #4
    Join Date
    Feb 2004
    Posts
    3

    Crash occurs at 3:30am - Still checking

    Just wanted to give an update that the database is still crashing. It is crashing at around 3:30am everyday. We are still trying to identify the process which is causing that crash to happen.

    PS: There are only 2 instances running and I stopped one instance. Still the other instance crashed.

  5. #5
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Sounds suspiciously like either a backup process or some other OS utility (like a defrag or something) which has been scheduled to run during the night. Check what jobs are set to run at night on your server.
    Also are there any other servers which have access to the disks on your server?

    Alan

  6. #6
    Join Date
    Feb 2004
    Posts
    3

    Backup process was causing.

    It was a backup process. Finally found that the back process running in a remote server was backing up this server.
    Thank you very much for all your valuable help.

Posting Permissions

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