Databases supported


The BMC Database Automation solution supports the following database types:

Success

Tip

Press F to view the tables in a full screen mode.

MySQL

BMC Database Automation supports the following MySQL versions:

MySQL can be discovered as a custom application (instance and databases), and MySQL Actions can be performed for:

  • Provision Instance and Create Database
  • Upgrade
  • Start Instance
  • Stop Instance

The Guide to BMC Database Automation MySQL Support contains information on configuring your BMC Database Automation environment to discover MySQL instances, as well as the MySQL related activities that can be performed using BMC Database Automation.

DB2

The following DB2 versions are supported:

Warning

Note

For DB2 patching, Universal fixpacks are supported, but not edition-specific patches.

Microsoft SQL Server

Prerequisites

The following prerequisites are required for installing Microsoft SQL Server:

  • For SQL Server 2008 and 2008R2 on Windows 2012:
    • You must install SP3 after installing SQL Server 2008 on Windows 2012
    • You must install SP1 after installing SQL Server 2008R2 on Windows 2012
  • For SQL Server 2008 on Windows 2008 R2:
    • Clustered installations: You must install SQL Server 2008 together with SQL Server 2008 Service Pack 1 or a later update (this is also referred to as a slipstreamed version).
    • Non-clustered installations: You must install SQL Server 2008, followed by SQL Server 2008 Service Pack 1 or later. Note that SQL Server 2008 express runtime is supported on Windows 2008 R2.

Supported versions

Warning

Note

Veritas Storage Foundation 6.0.1 is supported for all the supported Microsoft SQL Server versions noted in this section.

The following SQL Server versions are supported:

Oracle

  • DBMS 10gR1, 10gR2, 11gR1, 11gR2
  • Oracle 10gR2 (32-bit) on Windows 2003 (32-bit)
  • Oracle 10gR2 (64-bit) on Windows 2003 (64-bit)
  • Oracle 11gR1 RAC and Restart on Solaris 11 (SPARC only)
  • Oracle 11.2.0.4 Standalone, Restart, and RAC on:
    • Red Hat Enterprise Linux 4
    • Red Hat Enterprise Linux 5
    • Red Hat Enterprise Linux 6
    • Solaris 10
    • Solaris 11
  • Oracle 11.2.0.4 single instance on HPUX Itanium
  • Oracle 12cR1 12.1.0.1 single instance (for Standalone, Restart, and RAC) on Red Hat Enterprise Linux releases 5 and 6

Sybase Adaptive Server Enterprise (ASE) Dataserver

The following versions Sybase ASE dataserver are supported:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Database Automation 8.3