ORA-01000 maximum open cursors exceeded 1

[Karen99]

I get the following error. So I guess I must change the OPEN_CURSORS parameter. The only problem is just that I don't know where or how to do it.

Please help

Thanks
Karen

 

[sem]

You should change it in init.oa file and restart your instance. But I'd also recommend you to look for a "cursors leak", i.e. for a part of your application that doesn't close unused cursors.

Regards, Dima

http://seminihin.narod.ru

 

[Karen99]

I don't find OPEN_CURSORS parameter in my init.ora file. Must I just add it ?

 

[sem]

Yes. You may check current value by

select value from v$parameter where name='open_cursors'

or by issuing in sql*plus

show parameter open_cursors

Regards, Dima

http://seminihin.narod.ru

 

[Karen99]

Thanks, I just added the parameter to my init.ora file and made the value 600. Now it works.