ORA-01110, ORA-27041, Oraus.Msb Being Opened Repeatedly, Until Max Files Limit Is Reached and Processes Fail
(Doc ID 1200013.1)
Last updated on FEBRUARY 02, 2022
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Oraus.Msb is being opened repeatedly, until the max files limit is reached and processes fail with these errors:
ORA-01110: data file 16: '<path_to_datafile/datafile.dbf>'
ORA-27041: unable to open file
You may also see:
(THOUSANDS of file-handles for this, left in an open state!)
This has been seen following an upgrade from 10g to 11g.
In one case it was triggered by an attempt to unset an event that was not actually set. There will likely be other triggers.
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