Monday, February 22, 2010

ORA-01000: maximum open cursors exceeded

You might find issues in esb console that it is not showing any instances and then you might find following error in your log.xml

ORA-01000: maximum open cursors exceeded

In order to resolve this issue.

Go to you database home srvm\admin folder.In my case the location is

D:\Oracle\product\10.2.0\db_1\srvm\admin

Now open the init.ora file

You will get a property

open_cursors=300

By default the value is 300

Increase its value to some higher value let it be 1000 save and restart your server.This issue should not occur.

No comments: