Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: ORA-01114-Need help!

    Please help!
    My applications told that:
    Error: java.sql.SQLException: ORA-01114: IO error writing block to file 201 (block # 524041)
    ORA-27091: skgfqio: unable to queue I/O
    ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
    OSD-04026: Invalid parameter passed. (OS 524041)

    Alert log told me only
    found dead shared server 's001' pid=( 14,82) ,few that errrors.Trace file do not exist.
    Temp TBS is online and 4GB.
    Server is Oracle 9.2,OS Windows 2000.
    Thanks for advice,Zvonimir

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    which file to which tablespace is for file with id 201?

    you can retrieve the file id from v$datafiles.file#

    it sounds the datafiles belonging to the tablespace have autoextend and you are trying to expand beyond physical disk space ...

Posting Permissions

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