Tuesday, April 19, 2011

Bug 9981011: VARIOUS ORACLE PROCESSES CONSUMING LARGE QUANTITIES OF FILE DESCIPTORS (NFILES)


After upgrading to the 10.2.0.5.0 release the database is encounter a file handle leak.  The leak is seen in production and development instances. The leak happens on different processes (emagent and MMNL process are the current ones). 
Test on growing of openfiles:
lsof -p 10140 |wc -l => 600
lsof -p 10140 |wc -l => 759
Now we wait for the sollution of oracle to solve this bug. 

The max file limit has been reached so the db will have to be shutdown or the 
process killed, if possible, to free up files.The leak happen over time and manifests itself when the limits are reached as error ORA-27041.

The sollotion
VARIOUS ORACLE PROCESSES CONSUMING LARGE QUANTITIES OF FILE DESCIPTORS (NFILES) Patch 9981011. For us we need the Patch download for Oracle 10.2.0.5 on HP-UX Itanium.

This patch is also suitable for a 10.2.0.5.1 home, there are no conflicts with 10.2.0.5.1