HELP!!! Instance crashes??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: HELP!!! Instance crashes??

  1. #1
    Join Date
    Aug 2001
    Location
    Philadelphia, NJ
    Posts
    44

    Angry

    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    These are some of the possible remedies that you can take/check for.

    1. Check for any kind of cron job scripts that would do a backup of the control file simultaniously.

    2. Check for any scripts that would modify the file permissions temprorily

    3. IF the above two had been ruled out, then try to enforce the serialization on the disk read by changing the following parameter

    disk_asynch_io = false; ( This should fix the problem for you)

    Changing this parameter in your initSID.ora requires a bounce of the instance.

    Good luck,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2001
    Posts
    10
    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 .

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003

    Lightbulb

    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.

  5. #5
    Join Date
    Aug 2001
    Location
    Philadelphia, NJ
    Posts
    44

    RE

    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.

    Thanks
    EJC

  6. #6
    Join Date
    Aug 2001
    Location
    Philadelphia, NJ
    Posts
    44

    Angry crashed again

    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.

    A dumbfounded DBA
    EJC

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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 ?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Dec 2001
    Posts
    2

    Question Have you found a solution?

    Hi

    Have you found a solution to your problem, if yesthen please do let me know, as I am facing the same problem, have a look at:

    http://www.dbasupport.com/forums/sho...threadid=18491

    Sincere Regards
    Munish Jauhar

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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?


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