Please help with ORA-27092

[Lily_Liu_2004]

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.

[Lily_Liu_2004]

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

[marist89]

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

[Lily_Liu_2004]

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

[Lily_Liu_2004]

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

[Lily_Liu_2004]

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

[tamilselvan]

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

You can get it from dba_extents.

Tamil

[Lily_Liu_2004]

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

[marist89]

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?

[Lily_Liu_2004]

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.