ORA-01110, ORA-27041, Oraus.Msb Being Opened Repeatedly, Until Max Files Limit Is Reached and Processes Fail
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2016***
Oraus.Msb is being opened repeatedly, until the max files limit is reached and processes fail with these errors:
ORA-01110: data file 16: '/ora03/gpo/gpop1/oi_stmt_img_dtl_x.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms