My Oracle Support Banner

Intermittent ORA-1116, ORA-1110 and ORA-27092 Errors On Undo and Temp Files (Doc ID 1313501.1)

Last updated on AUGUST 27, 2023

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


Symptoms

In the alert.log, intermittent ORA-1116, ORA-1110 and ORA-27092 on undo and temp files are reported:

ORA-01116: error in opening database file 2
ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl/undo/undo01.dbf'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 131071
Additional information: 1048577

ORA-01116: error in opening database file 10
ORA-01110: data file 10: '/u01/app/oracle/oradata/orcl/temp/temp01.dbf'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 131071
Additional information: 1572865

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.