ORA-7445 Followed By ORA-1000 "MAXIMUM OPEN CURSORS EXCEEDED" Error (Doc ID 1138647.1)
可以根据情况先加大一下 open_cursors参数试试， 把这个参数设置的很大，如果打开的游标到不了指定的数，也不会有什么坏处
Assuming that a session does not open the number of cursors specified by OPEN_CURSORS, there is no added overhead to setting this value higher than actually needed.
Oracle Server - Enterprise Edition - Version 126.96.36.199 and later 188.8.131.52及以后的版本
Information in this document applies to any platform.
***Checked for relevance on 13-SEP-2012***
You are experiencing ORA-7445 core dump errors which are accompanied by ORA-1000 errors, e.g.:
ORA-07445: exception encountered: core dump  [SIGILL] [Illegal opcode] [0x000000000]  
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
You may have already noticed that OPEN_CURSORS was set to a low value and corrected it by setting it higher and still encounter the errors.
As the errors suggest, this is due to the session running out of open cursor slots. This can often be traced back to a coding issue in the application where the code is opening many cursors and not explicitly closing them.
Research will be needed in the code that is being run to do determine what cursors need to be closed explicitly to avoid the ORA-1000 MAXIMUM OPEN CURSORS EXCEEDED
Resolve the ORA-1000 error by increasing the OPEN_CURSORS parameter value which will also stop the related ORA-7445 errors.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25099483/viewspace-773922/，如需转载，请注明出处，否则将追究法律责任。