Page tree

Important

To get complete compatibility information for BDA, use the BMC Solution and Product Availability and Compatibility Utility on the Product Availability and Compatibility page. 

The BMC Database Automation (BDA) solution supports the following database types:

Tip

Press F to view the tables in a full screen mode. An remove in a table cell indicates support for the OS corresponding to the database version in that row. An remove with a parenthesis indicates support with stipulations or limitations.

MySQL

BDA supports the following MySQL versions:

MySQL VersionRHEL 5RHEL 6RHEL 7

5.1.59

remove

  

5.5.16

removeremove 
5.5.20removeremove 

5.6

removeremoveremove
5.7removeremoveremove

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 BDA environment to discover MySQL instances, as well as the MySQL related activities that can be performed using BDA.

DB2

The following DB2 versions are supported:

DB2 VersionRHEL 4RHEL 5RHEL 6RHEL 7IBM AIX 5.3IBM AIX 6.1IBM AIX 7.1
10.5 (Enterprise Server Edition and Advanced Enterprise Server Editions) removeremove   remove removeremove

10.1 (Enterprise Edition)

 removeremove  removeremove

10.1 (Advanced Enterprise Edition)

 removeremove  removeremove

9.7 (Enterprise Edition)

 removeremove removeremoveremove
9.7 3a (Advanced Enterprise Edition) removeremove removeremoveremove
9.5 (Enterprise Edition)removeremoveremove removeremoveremove

Note

BDA does not support DB2 database partitioning.

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

In BDA 8.9, direct BDA provisioning of DB2 10.5 fixpacks 6 and 7 is supported.

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

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:

SQL Server VersionEditionsInstances

Windows Server 2012 R2 Enterprise and Standard Editions (x64)

Windows Server 2012 Enterprise and Standard Editions (x64)Windows Server 2008 R2 SP1 Enterprise and Standard Editions (x64)Windows Server 2008 R2 Enterprise and Standard Editions (x64)Windows Server 2008 R2 Enterprise and Standard Editions (x86)Windows Server 2008 SP2 Enterprise and Standard Editions (x64)Windows Server 2008 SP2 Enterprise and Standard Editions (x86)Windows Server 2008 Enterprise and Standard Editions (x64)
2016 (64-bit)Standard, Developer, Enterprise, Datacenter, Business Intelligence

Standalone, Standalone on Clustered, Clustered,

AlwaysOn Availability Group

removeremove      
2014 (64-bit)Standard, Developer, Enterprise, Datacenter, Business IntelligenceStandalone, Standalone on Clustered, Clusteredremoveremoveremove  remove  

2012 (64-bit)

Standard, Developer, Enterprise, Datacenter, Business IntelligenceStandalone, Standalone on Clustered, Clusteredremoveremoveremove  remove  

2008 R2 (64-bit)

Standard, Developer, Enterprise, DatacenterStandalone, Standalone on Clustered remove remove remove  

2008 R2 (32-bit)

Standard, Developer, Enterprise, DatacenterStandalone, Standalone on Clustered remove  remove remove 
2008 (64-bit)Standard, Developer, Enterprise, DatacenterStandalone, Standalone on Clustered remove remove   remove
2008 (32-bit)Standard, Developer, Enterprise, DatacenterStandalone, Standalone on Clustered remove  remove remove 

Oracle

The following Oracle versions are supported:

ServerVersionRHEL 4RHEL 5RHEL 6RHEL 7Oracle Linux 5Oracle Linux 6Oracle Linux 7SLES 10SLES 11Windows 2003Windows 2008Windows 2008 R2Windows 2012Solaris 9Solaris 10Solaris 11HP-UX 11.11HP-UX 11.23HP-UX 11.31HP-UX PARISCAIX 6.1AIX 7.1

Single Instance

11gR1

removeremoveremoveremoveremoveremoveremove  remove (no patching)remove (no patching)  removeremove  removeremove remove 
11gR2removeremoveremoveremoveremoveremoveremoveremoveremoveremoveremoveremove  removeremove  removeremoveremoveremove
12c remove (64-bit only)remove (64-bit only)removeremoveremoveremove remove     removeremove  remove (Itanium only, no patching) removeremove
Single Instance (VCS)11gR1removeremoveremoveremoveremoveremoveremove      removeremove     remove (no patching) 
11gR2removeremoveremoveremoveremoveremoveremoveremoveremove     removeremove   removeremove (no patching)remove (no patching)
12c remove (64-bit only)remove (64-bit only)removeremoveremoveremove remove     removeremove      

Single Instance (Restart-enabled)

 

11gR1                      
11gR2removeremoveremoveremoveremoveremoveremoveremoveremove     removeremove (no patching)   removeremoveremove
12c remove (64-bit only)remove (64-bit only)removeremoveremoveremove remove     removeremove    removeremove
RAC (CRS)11gR1removeremove remove                remove 
11gR2removeremoveremoveremoveremoveremoveremoveremoveremove     removeremove   removeremoveremove
12c remove (64-bit only)remove (64-bit only)removeremoveremoveremove remove     removeremove    removeremove
PDBs12c  removeremove              remove(Itanium only)  remove

Note

Single instance (Restart-enabled) DBMS is supported on Red Hat Enterprise Linux (RHEL) 5, RHEL 6 (64-bit only), Solaris 10 and 11, and AIX 6.1 and 7.1.

Beginning with version 8.7.00, BDA is certified for use on Oracle Exadata systems.

The following versions are supported:

  • Oracle 11.2 and 12.1 using Oracle Enterprise Linux (OEL) 5.10 or 6.7 on X3-2 and X4-2 Exadata systems

The following use cases are supported:

  • Provisioning operations
    • Create database
    • Remove database
    • Add instance
    • Remove instance
  • Management operations
    • Stop/start instance
    • Start instance
    • Apply/rollback patch (DB patches only)
    • Run action (script and SQL)
  • Miscellaneous operations
    • Reports

Sybase Adaptive Server Enterprise (ASE) Dataserver

The following versions Sybase ASE dataserver are supported:

ASE VersionRHEL 5RHEL 6RHEL 7IBM AIX 5.3IBM AIX 6.1IBM AIX 7.1Solaris 8 (SPARC)Solaris 10 (SPARC)
16.0removeremove removeremoveremove remove

15.7.0

removeremove   removeremoveremoveremove remove

15.5.0

removeremove removeremoveremove remove

15.0.3

removeremove removeremoveremoveremoveremove
15.0.2removeremove    removeremove
12.5.4remove     removeremove

Note

Sybase Repserver 15.7.1 is also supported on RHEL 7.