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.

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

hmmm, is file at 2G limit for OS filesize?

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

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

Really connot understand. The same end user used the other oracle account and can connect the database without any problem.

What is the object ued by the block 5970 in the system.dbf?

You can get it from dba_extents.

Tamil

Quote:

---

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

Quote:

---

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?

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.

Quote:

---

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.

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.

sounds like an OS permission issue or an environment issue.

Quote:

---

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