ORA-7445 ORA-1000

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.

如果加大之后还是不行的话，就要找没有关闭游标的操作了。

APPLIES TO:

Oracle Server - Enterprise Edition - Version 9.2.0.1 and later   9.2.0.1及以后的版本

Information in this document applies to any platform.

***Checked for relevance on 13-SEP-2012***

SYMPTOMS

You are experiencing ORA-7445 core dump errors which are accompanied by ORA-1000 errors, e.g.:

ORA-07445: exception encountered: core dump [00000000] [SIGILL] [Illegal opcode] [0x000000000] [] [] 

ORA-00604: error occurred at recursive SQL level 1 

ORA-01000: maximum open cursors exceeded

报上面的错误。。。

 

CHANGES

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.

可能已经注意到OPEN_CURSORS过低并且加大了它的值，但是还是有错误产生

CAUSE

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.

对于这种错误，session运行的游标超过了打开的游标。 根踪应用程序代码看哪些代码打开游票但是没有显示关闭

SOLUTION

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-773921/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25099483/viewspace-773921/