DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Please help with ORA-27092

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    Please help with ORA-27092

    DBAs,

    One end user met the flollowing error.
    I already reset the oracle accont ulimits to unlimited and even the end user's unix account's ulimit to unlimited. Restarted the database.

    ACTRS3 $ whoami
    oracle
    ACTRS3 $ ulimit -a
    time(seconds) unlimited
    file(blocks) unlimited
    data(kbytes) unlimited
    stack(kbytes) unlimited
    memory(kbytes) unlimited
    coredump(blocks) unlimited
    nofiles(descriptors) unlimited
    The problem still dun go away.

    The error message the end user got is as follows:
    $ sqlplus rsgmat


    SQL*Plus: Release 8.1.7.0.0 - Production on Mon May 2 09:12:21 2005

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Enter password:
    ERROR:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01115: IO error reading block from file 2 (block # 16208)
    ORA-01110: data file 2: '/db5/rstst/rbs1.dbf'
    ORA-27092: skgfofi: size of file exceeds file size limit of the process
    Additional information: 6249
    Additional information: 128009
    ORA-02002: error while writing to audit trail
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01115: IO error reading block from file 2 (block # 16208)
    ORA-01110: data file 2: '/db5/rstst/rbs1.dbf'
    ORA-27092: skgfofi: size of file exceeds file size limit of the process
    Additional information: 6249
    Additional information: 128009

    I cannot think about any other casue. Any idea about this?

    Thanks.

  2. #2
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    after reset the oracle user's ulimit to unlimited and restarted the database. the user got the following error message;

    $ sqlplus rsgmat

    SQL*Plus: Release 8.1.7.0.0 - Production on Mon May 2 10:54:02 2005

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Enter password:
    ERROR:
    ORA-00604: error occurred at recursive SQL level 1
    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

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    hmmm, is file at 2G limit for OS filesize?
    Jeff Hunter

  4. #4
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    SQL> select substr(file_name,1,30), bytes/1024/1024 from dba_data_files
    2 ;

    SUBSTR(FILE_NAME,1,30) BYTES/1024/1024
    ------------------------------ ---------------
    /db8/rstst/system.dbf 300
    /db5/rstst/rbs1.dbf 1000.0625
    /db6/rstst/usrs_sml.dbf 500.0625
    /db6/rstst/usrs_med.dbf 1500
    /db6/rstst/usrs_lrg.dbf 1000.0625
    /db6/rstst/usrs_lrg2.dbf 1512.0625
    /db7/rstst/idx_sml.dbf 500.0625
    /db7/rstst/idx_med.dbf 1000.0625
    /db7/rstst/idx_lrg.dbf 1000.0625
    /db7/rstst/idx_lrg2.dbf 1000.0625
    /db5/rstst/rbs2.dbf 500

  5. #5
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    In the followiing error message, the systm.dbf actually just 300m

    $ sqlplus rsgmat

    SQL*Plus: Release 8.1.7.0.0 - Production on Mon May 2 13:51:54 2005

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Enter password:
    ERROR:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01115: IO error reading block from file 1 (block # 5970)
    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
    ORA-02002: error while writing to audit trail
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01115: IO error reading block from file 1 (block # 5970)
    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

  6. #6
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Really connot understand. The same end user used the other oracle account and can connect the database without any problem.

  7. #7
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is the object ued by the block 5970 in the system.dbf?

    You can get it from dba_extents.

    Tamil

  8. #8
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Originally posted by tamilselvan
    What is the object ued by the block 5970 in the system.dbf?

    You can get it from dba_extents.

    Tamil
    SQL> SELECT * FROM DBA_EXTENTS WHERE BLOCK_ID=5970 AND TABLESPACE_NAME='SYSTEM';

    no rows selected

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Lily_Liu_2004
    The same end user used the other oracle account and can connect the database without any problem.
    What do you mean by this? This is not the oracle user?
    Jeff Hunter

  10. #10
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    the problem connecting is directly from a UNIX process via the Oracle bequeath protocol, therey bypassing tnsnames and the listener,
    is there any wrong setting from unix os?

    The same user can connect the database with other account.

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