15.1 Prerequisites for External Databases

15.1.1 Prerequisites for Remote OEM Sybase

Before installing ZENworks to create the Management Zone, you must install the remote OEM Sybase database on your remote database server so that it can be properly configured during installation of the Primary Server that hosts the database.

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.

15.1.2 Prerequisites for Remote Sybase SQL Anywhere

Before installing and configuring the Sybase SQL Anywhere database for ZENworks , ensure that the following prerequisites are met:

  • Install and set up the Sybase SQL Anywhere database so that it can be updated during ZENworks installation.

  • During ZENworks installation, you must specify a database user. Ensure that the database user has read/write permissions to create and modify the tables on the database server.

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.

15.1.3 Prerequisites for Microsoft SQL Server

To use the Microsoft SQL Server database for ZENworks, 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.

For MS SQL, set the READ_COMMITTED_SNAPSHOT setting to ON so that it allows read access to information in the database while data is being written or modified.

To set the READ_COMMITTED_SNAPSHOT setting to ON, execute the following command at the database server prompt:

ALTER DATABASE database_name SET READ_COMMITTED_SNAPSHOT ON;

15.1.4 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 is needed for the Oracle access user. A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data, and serves to allocate storage for all DBMS managed segments. (A database segment is a database object which occupies physical space such as table data and indexes.) Once created, a tablespace can be referred to by name when creating database segments.

    • The tablespace can be created by ZENworks or can be created by the Database Administrator.

    • The tablespace has sufficient space to create and store the ZENworks database schema. The tablespace requires a minimum of 10 GB to create ZENworks database schema.

  • 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 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 10 GB to create ZENworks database schema.

    • Ensure that the quota for the user schema is set to Unlimited on the tablespace that you plan to configure during the installation.

  • Rights to create the database: Ensure that the user schema has the following rights to create the database:

    • CREATE SESSION
    • CREATE TABLE
    • CREATE VIEW
    • CREATE PROCEDURE
    • CREATE SEQUENCE
    • CREATE TYPE
    • CREATE TRIGGER
    • ALTER ANY TABLE
    • DROP ANY TABLE
    • LOCK ANY TABLE
    • SELECT ANY TABLE
    • CREATE ANY TABLE
    • CREATE ANY TRIGGER
    • CREATE ANY INDEX
    • CREATE ANY DIMENSION
    • CREATE ANY EVALUATION CONTEXT
    • CREATE ANY INDEXTYPE
    • CREATE ANY LIBRARY
    • CREATE ANY MATERIALIZED VIEW
    • CREATE ANY OPERATOR
    • CREATE ANY PROCEDURE
    • CREATE ANY RULE
    • CREATE ANY RULE SET
    • CREATE ANY SYNONYM
    • CREATE ANY TYPE
    • CREATE ANY VIEW
    • DBMS_DDL
    • DBMS_REDEFINITION
    • DBMS_LOCK (Execute and Debug)

    IMPORTANT:The above privileges are used to modify tables only in ZENworks and Audit schema and not in any other schema. The DBMS_DDL and DBMS_REDEFINITION packages are used to restructure some of the tables as partitioning tables during fresh installation of ZENworks.You can give the DBMS_DDL and DBMS_REDEFINITION rights to the user at the time of installation or upgrade. After the installation or upgrade is successful, you can revoke the DBMS_DDL and DBMS_REDEFINITION rights and also those privileges with ANY option. If these privileges are revoked, then, for the next upgrade, these privileges will have to be invoked prior to performing the upgrade. The installation privileges are also applicable for upgrade and these minimum privileges should be retained for day-to-day operations. No additional privileges are required for Upgrades or System Updates.

    For more details, see the Oracle database documentation.

    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 system load. This pool can grow at peak loads to a maximum of 100 concurrent database connections per Primary Server. If your Oracle database is configured to use dedicated server processes, it is possible that your database server resource usage can reach undesirable levels that affect performance when there are multiple Primary Servers in your zone. If you encounter this problem, consider changing your ZENworks database to use shared server processes.

    • Day-to-Day Operations for Databases: Ensure that the ZENworks and Audit users have the minimum rights to function during database operations.

      CREATE TRIGGER

      CREATE SESSION

      CREATE SEQUENCE

      CREATE TYPE

      CREATE PROCEDURE

      CREATE VIEW

      CREATE TABLE

      DBMS_LOCK (Execute & Debug)

Prerequisites for Oracle RAC

  • Oracle database and Real Application Clusters (RAC) version must be 11.2.0.4 or above.

  • Tablespaces must be created by your database administrator manually (do not use ZENworks to create the tablespaces).

  • Shut down ZENworks services on all Primary Servers and Reporting Server before upgrading ZENworks.