Application Delivery Management
Application Modernization & Connectivity
CyberRes
IT Operations Management
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.
Paul Pedron
Micro Focus Product Manager