Installation guide

Preparation 39
NOTE: For this database, Novell Support provides problem determination, provision of compatibility
information, installation assistance, usage support, ongoing maintenance, and basic troubleshooting.
For additional support, including extended troubleshooting and error resolution, see the Sybase
Support Web site (http://www.sybase.com/support).
Prerequisites for Microsoft SQL Server
Before installing and configuring the Microsoft SQL Server database for ZENworks 11, ensure that
the Microsoft SQL Server software is installed on the database server so that the ZENworks
installation program can create the new Microsoft SQL database. For instructions on installing the
Microsoft SQL Server software, refer to the Microsoft documentation.
Prerequisites for Oracle
During the installation of the ZENworks database on Oracle, you can choose to create a new user
schema or specify an existing one that resides on a server in your network.
 Create a new user schema: If you choose to create a new user schema, ensure that the
following requirements are met:
 You must be aware of the database administrator credentials.
 A tablespace must already exist for associating to the Oracle access user.
 The tablespace must have sufficient space to create and store the ZENworks database
schema.The tablespace requires a minimum of 100 MB to create the ZENworks database
schema without any data in it.
 Use an existing user schema: You can install to an existing Oracle user schema that resides
on a server in your network in the following scenarios:
 The database administrator creates a user schema with the necessary rights and you
receive the credentials for that user schema from the database administrator. In this case,
the database administrator credentials are not required to install to an existing Oracle user
schema.
 You create a user schema in the Oracle database and choose to use it during ZENworks 11
installation.
If you choose to use an existing user schema, ensure that the following requirements are met:
 Ensure that the tablespace has sufficient space to create and store the ZENworks database
schema.The tablespace requires a minimum of 100 MB to create ZENworks database
schema without any data in it.
 Ensure that the quota for the user schema is set to Unlimited on the tablespace that you
plan to configure during the installation.
 Ensure that the user schema has the following rights to create the database.
CREATE SESSION
CREATE_TABLE
CREATE_VIEW
CREATE_PROCEDURE
CREATE_SEQUENCE
CREATE_TRIGGER
IMPORTANT: For Oracle databases, performance can be affected by whether you configure
your database to use shared server or dedicated server processes. Each ZENworks Primary
Server is configured with a database connection pool whose size fluctuates with the ZENworks