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

alaw_at_oracle.com (Alvin Law) wrote:

>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

Thanks -- I can't believe I missed it ;-] But so did Oracle support and an Oracle consultant that was brought in to help with install and verify the system!!!!

Regards,
Perry A. McGrew (perrygrw_at_future.dreamscape.com) Received on Thu May 11 1995 - 00:00:00 CEST