Article Content
Article Number | 000014092 |
Applies To | Oracle |
Issue | How to fix "maximum open cursors exceeded" error when load configuration files to AA database. Customer experience following error when load configuration files to database:
2008-07-13 04:43:58,659 ERROR [main] [] [] [com.passmarksecurity.dao.sp.ConfigSpaceStoredProcBase] - <failed to set configSpace: ORA-01000: maximum open cursors exceeded ORA-06512: at "PMSECURE.SETCONFIGDEFINITION", line 68 ORA-06512: at line 1
|
Cause | Some customers have dramatically increased the question ref bean in c-config-challenge.xml file, which caused increased cursor needed when loading the file to database. |
Resolution | The error is caused by not enough cursor to open in order to load the configrations. 1) run following SQL to get how many open cursors and its owners. select sum(a.value) total_cur, avg(a.value) avg_cur, max(a.value) max_cur,s.username, s.machine 2) Run following command to get the max open cursor setting in database SQL> show parameter curs 3) increase the max cursor setting as needed. |
Legacy Article ID | a41127 |