Article

paulpf's picture
article
Reads:

3469

Score:
0
0
 
Comments:

0

ZCM 10.1.1 Bulk Delete Error Deleting or Adding User Sources

Author Info

12 December 2008 - 1:33pm
Submitted by: paulpf

Author Blog
Author Profile

Tags

Tags Map

(View Disclaimer)

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.

Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (so don't even think of calling Support if you try something and it blows up).

It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.



Related Articles


User Comments

© 2013 Novell