ORA-01000: maximum open cursors exceeded

ORA-01000: maximum open cursors exceeded 

cause : this issue produce reason OPEN_CURSORS parameter size, in your database please check present size and increase it more value to avoid error repetition in future. 

To check present value:-

sho parameter OPEN_CURSORS 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

open_cursors                         integer     300

increase value by using below command

alter system set open_cursors = 1000 scope=both;