Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Posts
    7

    Angry Unanswered: ora:01171 datafile %s going offline due to error advancing checkpoint

    Would like to know what causes this error message,

    ora 01171 : datafile %s going offline due to error advancing checkpoint
    ora 01116 : error in opening database file %s

    when ever I ran a huge load through SQL Loader in the database this happens. I did try to do Media recovery, the db comes up ok, but then again when I run the load, it gives the same error.

    Any solution is highly appreciated.

    Thanks!

  2. #2
    Join Date
    Jul 2001
    Posts
    92

    Unhappy

    Are u running your database in AIX enviroment?
    IF yes, please disable AIO in initsid.ora and restart your database.
    It is an oracle/(or aix?, who knows) bug.
    This should help you, though some performance degration,
    zhu chao
    www.cnoug.org

  3. #3
    Join Date
    Dec 2001
    Posts
    7
    I am running Oracle on Sun OS.

Posting Permissions

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