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 DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2016***

Symptoms


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:
fd=4095 File=/oracle/product/11.1.0/rdbms/mesg/oraus.msb
(THOUSANDS of file-handles for this, left in an open state!)

Changes

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.

Cause

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