ORA-7445 Followed By ORA-1000 "MAXIMUM OPEN CURSORS EXCEEDED" Error

ORA-7445 Followed By ORA-1000 "MAXIMUM OPEN CURSORS EXCEEDED" Error

I see the errors :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

This is due to the session running out of open cursor slots. This occurs mostly because the application code is opening many cursors and not explicitly closing them. The code needs to be looked into and the cursors need to be closed explicitly.

Resolve the ORA-1000 error by increasing the OPEN_CURSORS parameter value which will also stop the related ORA-7445 errors.