Re: ORA-00604,01116,01110,07209 errors

In article <3ol7uh$lcd_at_news1.databank.com> perrygrw_at_future.dreamscape.com (Perry McGrew) writes:

> Runiing Oracle 7.1.4 / SQL*PLUS 3.1.3.5.1 on NCR UNIX SVR4 machine. I
> enter following sequence:
> sqlplus
> Enter user-name: system
> Enter password:
> ERROR: ORA-00604: error occurred at recursive SQL level 1
> ORA-01116: error in opening database file 2
> ORA-01110: data file 2: '/u13/oracle/AGDW/rbs01.dbf'
> ORA-07209: sfofi: file size limit was exceeded
>
> I can get this error with any id. Also, I can logoff/logon to UNIX
> and successfully connect into Oracle -- meaning the "problem" is not
> always recreatable!!! Does anyone have any clues?

This is the error text from the message file itself:

% oerr ora 7209
07209, 00000, "sfofi: file size limit was exceeded."

// *Cause:  The size of the file to be opened exceeded the OS limit imposed
//          on this process.
// *Action: Run osh to increase the file size limit.

Apparently the OS user who owns the oracle executable has an OS-imposed limit so it cannot open the datafile. Since all direct database access is through this oracle back-end executable and this executable is set-uid, an OS limit on this user will encounter the above error.

--
"And this is all I have to say about that..."   - F. Gump
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
|  Alvin W. Law ..... Oracle Corporation ....... Email: alaw_at_us.oracle.com  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel