ORA-1114 --what to look first
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ORA-1114 --what to look first

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    ORA-1114 --what to look first

    ORA-1114
    ID ERROR WRITING BLOCK TO FILE %s (BLOCK # %S)

    The above error is coming when running brio reports through
    odbc in one of our client place.

    what I have to look first during trobleshooting?

    thanks

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Well, what I do normally when I start trouble shooting is to simply go to Metalink, plug the error number into the search box and start to read. If that doesn't help I pulg the error number into an internet search engine. Then as a last resort I search the archives on this site. By then I've got the answer. But, since so many people here would much rather post the question here expecting someone to tell them so they don't have to do the reasearch is by far the way to go when trouble shooting.

    So, with that all said... After pluging your error into Metalink it looks as though you may have a file size limit or a possible bug (depending on your version of Oracle)according to Gina from Oracle support.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    i SEARCHED NET
    I POSTED METALINK.
    BUT WHY I COME TO THIS FORUM YOU KNOW..
    IF SOMEBODY FACED THE SAME PROBLEM..
    THEN IT IS EASY TO ADVICE FROM THEM.. THEY PINPOINT THE EXACT
    SOURCE OF THE ERROR..
    THIS IS NOT FOR ANYOTHER ANALYZE.

  4. #4
    Join Date
    Apr 2003
    Posts
    353
    DURING PROBLEM , REINVENTING TIME WILL BE SAVED..

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    check the size on disk where the file resides, if its out of space or corrupt or disk going offline?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Check the file permissions..

    regards
    Hrishy

  7. #7
    Join Date
    Feb 2004
    Posts
    50

    Re: ORA-1114 --what to look first

    Originally posted by engiri
    what I have to look first during trobleshooting?
    In this case, I'd start with the alert log to get the full error stack.
    Especially any operating system errors.

  8. #8
    Join Date
    Apr 2003
    Posts
    353
    The person sitting there has no knowledge in db. There is no connectivity too.

    After analyzing the db there, with ts and df s
    i have done the following things,, and the Problem is solved.

    Dropped the previous rollback segments which grown big,,1gb plus,
    it is a small database of size 5 gb.

    Created another Temp ts and assigned that .//
    Previous temp ts grown to 1gb +//

    Thanks all for your valuable replies.

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