Sunday, September 21, 2014
11gR2: Listener hangs with ORA-12518 and too many open files
How up to date are you on bugs fixed in 18.104.22.168 which affect 22.214.171.124, 126.96.36.199 and 188.8.131.52? Were you aware there is an unpublished bug related to this and also a patch for 11.2.02 and 184.108.40.206 which can resolve this for you? Read "11.2 : ORA-12518 Listener Hangs and Reports "Too Many Open Files" on My Oracle Support from document ID 1527483.1 and also see how you can monitor open sessions with lsof which is something featured in this article where we had problems with open connections ourselves.