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

Thread: Help

  1. #1
    Join Date
    Sep 2000
    Posts
    56

    Exclamation

    I am getting the following error frequently.But once I shutdown the database & startup it works fine for some days & again I get the same error & aggain I do the shutdown & startup.Can anyone suggest how to avoid this error so as to prevent me in shutting down the database & startingup.
    I am getting the same error in trace files for testckpt.trc,testlgwr.trc,testdbwo.trc,testpmon.trc & testsmon.trc.The name of the databse is test & the version is ORACLE 8.1.6 Running in WindowsN/T.This is a test databse & when some applications runs on this databse I am getting this error
    Thanks
    G.Suresh
    CKPT: terminating instance due to error 1110
    Instance terminated by CKPT, pid = 293

  2. #2
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    I found the following information on Metalink (a great place to look for information on specific errors):

    =======================================
    1- A similar bug 953585 that is reporting similar issue. It seems that the issue is related to the timeout on the
    checkpointing procedure. Please try their wrokaround of play around with init.ora parameters checkpoint_interval,
    and any parameters you are setting for db buffers to isolate the problem to some degree.


    The customer logging the bug has solved his issue by increasing the value of checkpoint_interval and the value of
    _control_file_enqueue_timeout=2700

    2- In some cases, you may encounter an error such as:

    Instance terminating due to error 1110.
    Instance terminated by CKPT PID=505


    A third party software, most likely a backup application, has locked a
    datafile or logfile. We have seen this situation with Seagate Backup
    Exec Software. When Oracle attempts to write to the file, the lock prevents
    it and the database crashes.


    ====================================

    It looks like the second scenario matches your problem pretty well.

  3. #3
    Join Date
    Sep 2000
    Posts
    56
    Thanks!!! Carp.Can u please lookat the details of the error I have posted & tell me the solution.Any I will increase ch---to 2700
    Thanks
    G.Suresh

  4. #4
    Join Date
    Sep 2000
    Posts
    56
    u mean I should increase the present log_checkpoint_timeout = 1800 to 2700?????.If I am wrong correct me

  5. #5
    Join Date
    Sep 2000
    Posts
    56

    Same problem repeating

    ORA-01157: cannot identify/lock data file 17 - see DBWR trace file
    ORA-01110: data file 17: 'J:\DATA11.ORA'
    ORA-27047: unable to read the header block of file
    OSD-04006: ReadFile() failure, unable to read from file
    O/S-Error: (OS 33) The process cannot access the file because
    another process has locked a portion of the file.
    Dump file o:\oracle816\admin\test\bdump\testDBW0.TRC
    I am not seeing any other process locking.Once I do a cold boot of the system it works fine.Any suggestions are welcom
    Thanks

  6. #6
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Run dbverify (to ensure that there's nothing wrong with the dbf). Call tech support and report this problem.

  7. #7
    Join Date
    Oct 2000
    Posts
    8
    Re: your last post - we had seen this message (or one very similar) on NT when the Oracle database files had not been excluded from the system backups.
    Ended up having to recover the database each time.
    Jan

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