Novell Cool Solutions

ZCM 10.1.1 Bulk Delete Error Deleting or Adding User Sources



By:

December 12, 2008 1:33 pm

Reads:3,895

Comments:0

Score:Unrated

Print/PDF

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.

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.
Loading...Loading...

Categories: Uncategorized

0

Disclaimer: This content is not supported by Novell. 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 it thoroughly before using it in a production environment.

Comment

RSS