ORA-01000: maximum open cursors exceeded!!
In our production server(SOA Suite 10.1.3.4) we have started getting follwoing error:
<2009-09-30 17:29:12,343> <ERROR> <default.collaxa.cube> <BaseCubeSessionBean::logError> Error while invoking bean "instance manager": Cannot read blob stream.
Cannot read blob stream from datastore with key "380291"; exception is ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
.
ORABPEL-04079
Cannot read blob stream.
Cannot read blob stream from datastore with key "380291"; exception is ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
While we have configured enough no. of cursor, current no. of cursor is 1000 in database but still getting cursor error. we have almost 40 bpels in the project but very few are interacting with db adapter or database. whenever we face this error, we restart server and things then work. But again after few days we get same error as cursors gets increasing day by day.
We need to fix the problem permanetnly. So i want to know if there is any configuration settings in app server to resolve this or the way we have created bpels is causing this error.
Thanks.