Please help with ORA-27092 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Please help with ORA-27092

  1. #11
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Originally posted by marist89
    What do you mean by this? This is not the oracle user?
    it is not oracle user. With oracle user, we don't have any problem.

  2. #12
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    the end user used the rgsgmat as the unix account and access the database with the bequeath protocol. When she used another unix account to login and access database, there is no problem.

    So, i really got confused.

  3. #13
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    sounds like an OS permission issue or an environment issue.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #14
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Originally posted by Lily_Liu_2004
    ORA-01115: IO error reading block from file 1 (block # 281)
    ORA-01110: data file 1: '/db8/rstst/system.dbf'
    ORA-27092: skgfofi: size of file exceeds file size limit of the process
    Additional information: 6249
    Additional information: 38401
    SQL> SELECT * FROM DBA_EXTENTS WHERE BLOCK_ID=281 AND TABLESPACE_NAME='SYSTEM';

    OWNER
    ------------------------------
    SEGMENT_NAME
    --------------------------------------------------------------------------------
    PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME
    ------------------------------ ------------------ ------------------------------
    EXTENT_ID FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
    ---------- ---------- ---------- ---------- ---------- ------------
    SYS
    I_OBJAUTH1
    INDEX SYSTEM
    0 1 281 16384 2 1

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