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

Thread: Unknown Error

  1. #1
    Join Date
    Sep 2001
    Posts
    112
    ERROR at line 1:
    ORA-01114: IO error writing block to file 3 (block # 2977)
    ORA-27072: skgfdisp: I/O error
    SVR4 Error: 9: Bad file number
    Additional information: 2977
    ORA-01114: IO error writing block to file 3 (block # 2977)
    ORA-27072: skgfdisp: I/O error
    SVR4 Error: 9: Bad file number
    Additional information: 2977
    ORA-06512: at line 34


    I recieve the preceeding errors whilst running a piece of PL/SQL.

    What puzzles me is the success depends on the OS user running it.

    If I log on as oracle the procedure is successful. If I log on as myself I get the error you see there, i'm also sure this wasn't happening on Friday.

    Any ideas. I'm not even sure what the error means. I'm guessing one of my datafiles is corrupted in some way.

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    If it depends on the user, could it be an issue of privileges?

    What does the PL/SQL do?
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Sep 2001
    Posts
    112
    Damned fine call there my man.

    One of the guys here took my user ouit of the 'dba' group.

    It was screwing a couple of things up.

    Put myself back in the group and it's all ok.

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