Databases

One of the following supported databases is required to run Configuration Management System (CMS) 2018.05:

  • Oracle Server
  • Microsoft SQL Server
  • PostgreSQL Server

The table below describes hardware requirements for database server:

Deployment CPU Memory Linux Swap Windows Virtual Memory Free Disk Space
Enterprise 24 Cores 64 GB 64 GB 96 GB 300 GB

Note  

  • It is strongly recommended to host database server (Oracle, Microsoft SQL, or PostgreSQL) on a physical machine, and it should be an independent server without other applications (including the UCMDB server) running on it.

    Also, if the database server machine is a virtual machine, the resource MUST be dedicated for the database server.

  • Apart from the embedded PostgreSQL database server, installing UCMDB server and database server (Oracle, Microsoft SQL, or PostgreSQL) together on the same machine is not supported.

  • The hardware requirements could be the same as those for UCMDB server, but the DB SPACE depends on the data scale. For example, for a data scale of 30 millions CIs, we recommended 500 GB or more space for data files and 200 GB or more space for log files.

Oracle System Requirements

The following table lists the Oracle Servers supported for working with Universal CMDB. A supported option means that Micro Focus quality assurance personnel have successfully performed basic tests on that option.

Database Version Edition System Type Supported Products

Oracle 12c *

(With or without the Oracle Advanced Security Option enabled)

  • Standard
  • Enterprise
64-bit
  • UCMDB
  • UCMDB Integration Service
  • RAC Enterprise **
 
  • UCMDB

Oracle 11.2 (11g R2) *

(With or without the Oracle Advanced Security Option enabled)

  • Standard
  • Enterprise
64-bit
  • UCMDB
  • Configuration Manager
  • UCMDB Integration Service
  • RAC Enterprise **
64-bit
  • UCMDB
  • Configuration Manager

Note   

  • It is strongly recommended to apply the latest critical Oracle patches per your operating system. For details, consult the Oracle documentation.
  • The UCMDB server(s) should be located in the same LAN with the database servers (without a proxy and firewalls between them). Otherwise, your system's performance may be impacted.
  • For information about how to configure UCMDB to support the Oracle Advanced Security Option (ASO), see the Hardening section of the UCMDB Help.
  • * Consult the Oracle documentation for supported platforms.

  • ** The connection from UCMDB to an Oracle RAC environment is supported only by using the Oracle native drivers. For detailed instructions, see Database section of UCMDB Help.

Examples of Tested Deployments

The following table details the deployment environments that have been rigorously tested by Micro Focus quality assurance personnel.

Database Release Version Edition System Type Operating System
Oracle 12.1.0.2.0 Enterprise 64-bit Windows Server 2012 Standard Edition (64-bit)
Oracle 12.1.0.2.0 Enterprise 64-bit Oracle Enterprise Linux with Unbreakable Enterprise Kernel v6.x
Oracle 11.2.0.1.0 Enterprise 64-bit Windows Server 2012 Datacenter Edition (64-bit)
Oracle 11.2.0.1.0 Enterprise 64-bit Red Hat Enterprise Linux Server 6.4
Oracle 11.2.0.1.0 Enterprise 64-bit Windows Server 2016

Microsoft SQL System Requirements

The following table lists the Microsoft SQL Servers supported for working with Universal CMDB. A supported option means that Micro Focus quality assurance personnel have successfully performed basic tests on that option.

Database Version Edition System Type Service Packs Supported Products
Microsoft SQL Server 2017
  • Standard
  • Enterprise
64-bit  
  • UCMDB
  • UCMDB Integration Service
Microsoft SQL Server 2016
  • Standard
  • Enterprise
64-bit SP1 (incl. high availability mode (AlwaysOn))
  • UCMDB
  • UCMDB Integration Service
Microsoft SQL Server 2014
  • Standard
  • Enterprise

64-bit

SP2 (incl. high availability mode (AlwaysOn))
  • UCMDB
  • UCMDB Integration Service
Microsoft SQL Server 2012
  • Standard
  • Enterprise
64-bit SP3
  • UCMDB
  • UCMDB Integration Service
Microsoft SQL Server 2012 Failover Cluster
  • Enterprise
64-bit SP1
  • UCMDB
  • UCMDB Integration Service

Note  

  • Only supported service packs should be installed, with latest patches.
  • Consult the Microsoft documentation for supported platforms.
  • The UCMDB server(s) should be located in the same LAN with the database servers (without a proxy and firewalls between them). Otherwise, your system's performance may be impacted.

Examples of Tested Deployments

The following table details the deployment environments that have been rigorously tested by Micro Focus quality assurance personnel.

Database Release Version

Edition System Type Service Packs Operating System
Microsoft SQL Server 2017 Enterprise 64-bit   Oracle Enterprise Linux with Unbreakable Enterprise Kernel 7.X
Microsoft SQL Server 2017 Enterprise 64-bit   Red Hat Enterprise Linux Server 7.4
Microsoft SQL Server 2016 Enterprise 64-bit   Windows Server 2012 R2 Datacenter Edition (64-bit)
Microsoft SQL Server 2016 Enterprise 64-bit SP1 Oracle Enterprise Linux with Unbreakable Enterprise Kernel 7.X
Microsoft SQL Server 2012 Cluster Enterprise 64-bit SP1 Windows Server 2012 Datacenter Edition (64-bit)
Microsoft SQL Server 2012 Cluster Enterprise 64-bit SP1 Windows Server 2012 Standard Edition (64-bit)

PostgreSQL System Requirements

The following table lists the PostgreSQL Servers supported for working with Universal CMDB. A supported option means that Micro Focus quality assurance personnel have successfully performed basic tests on that option.

Database Version Edition System
Type
Supported Products
PostgreSQL 10.3

Enterprise

64-bit
  • UCMDB
  • UCMDB Integration Service
PostgreSQL 9.6

Enterprise

64-bit
  • UCMDB
  • UCMDB Integration Service
PostgreSQL 9.5

Enterprise

64-bit
  • UCMDB
  • UCMDB Integration Service
PostgreSQL 9.4.15 Embedded * 64-bit
  • UCMDB
  • UCMDB Integration Service

PostgreSQL 9.4

 

Enterprise

64-bit
  • UCMDB
  • UCMDB Integration Service
PostgreSQL 9.3

Enterprise

64-bit
  • UCMDB
  • UCMDB Integration Service
PostgreSQL Server 9.22

Enterprise

64-bit
  • UCMDB

Note  

  • Only supported service packs should be installed, with latest patches
  • The UCMDB server(s) should be located in the same LAN with the database servers (without a proxy and firewalls between them). Otherwise, your system's performance may be impacted.
  • Embedded PostgreSQL is not supported on Enterprise deployments of UCMDB.
  • * Embedded PostgreSQL is supported on Linux systems after the local PostgreSQL is uninstalled. Therefore, to be able to use embedded PostgreSQL, make sure you uninstall the local PostgreSQL that comes with the Linux installation.

Examples of Tested Deployments

The following table details the deployment environments that have been rigorously tested by Micro Focus quality assurance personnel.

Database Release Version Deployment System Type Operating System

PostgreSQL Server 9.4.8

Embedded 64-bit Windows Server 2016

PostgreSQL Server 9.4

 

Enterprise 64-bit Windows Server 2012 Standard Edition
PostgreSQL Server 9.22 External 64-bit Windows Server 2012 Standard Edition

PostgreSQL Server 9.22

Standalone 64-bit Red Hat Enterprise Linux Server 6.4
PostgreSQL Server 9.22 Standalone 64-bit Red Hat Enterprise Linux Server 6.5