8.1 Prerequisites for External Databases

8.1.1 Prerequisites for Remote OEM Sybase

Before installing ZENworks 2017 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.

8.1.2 Prerequisites for Remote Sybase SQL Anywhere

To use the Sybase SQL Anywhere database, 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.

8.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.

An SA user or a SYSDBA user (with sysadmin privileges), with relevant user and login credentials, are required to create a ZENworks Database or an Audit Database.

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;

8.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: Ensure that the following requirements are met:

    • You must have the database administrator credentials. Ensure that the administrator has Data Definition Language (DDL) and Redefinition rights with the Grant option enabled.

    • 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 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. Database administrator credentials are not required to install to an existing Oracle user schema.

    • You create a user 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:

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

    • The quota for the user schema is set to Unlimited on the tablespace that is required during 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_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

    IMPORTANT:The above privileges are used to modify tables only in ZENworks 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.

    For more details, see the Oracle database documentation.

    For Oracle databases, performance can be affected by whether you configure your database to use a 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 300 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.

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.

8.1.5 Prerequisites for PostgreSQL

To use the PostgreSQL database, ensure that the following prerequisites are met:

  1. Install and set up the PostgreSQL database so that it can be updated during ZENworks installation.

  2. 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 PostgreSQL database, Micro Focus 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 PostgreSQL Support .