ZCM 10.1.1 Bulk Delete Error Deleting or Adding User Sources

0 Likes
over 12 years ago

Cannot create Administrator users or delete a user source... resulting in a "bulk delete error".



Issue: Unable to create groups, folders, admin (from user sources or in zcc)

Platform: Windows 2003 R2 SP3 Enterprise 32-bit

ZENworks Version: 10.1.1

Database: Oracle 10g database on separate server

ZCC LOG: Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded



Need to configure the oracle database setting. It should be larger than the default of 300:


View cursor setting:


show parameter open_cursors




Modify cursors setting:


alter system set open_cursors=1000




--------------------  view of parameters and results -----------------
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Nov 18 13:56:14 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit
Production With the Partitioning, OLAP and Data Mining options
SQL> "show parameter open_cursors"
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 300
SQL> "alter system set open_cursors=1000;"
System altered.




Labels:

How To-Best Practice
Comment List
Anonymous
Related Discussions
Recommended