Databases supported
The BMC Database Automation (BDA) solution supports the following database types:
Note
To get complete compatibility information for BDA, use the BMC Solution and Product Availability and Compatibility Utility on the Product Availability and Compatibility page.
Tip
Press F to view the tables in a full screen mode. An in a table cell indicates support for the OS corresponding to the database version in that row. An with parentheses indicates support with stipulations or limitations.
Oracle
The following Oracle versions are supported:
Notes (version 8.9.01 and later)
Oracle container database (CDB) and non-CDB database provisioning from Seed is not supported with Oracle 12.2.0.1.
- Single instance (Restart-enabled) DBMS is supported on Red Hat Enterprise Linux (RHEL) 5, RHEL 6 (64-bit only), Oracle Solaris 10 and 11, and IBM AIX 6.1 and 7.1.
- (Applicable for SLES 12) For Oracle 11.2.0.4, install the Oracle patch 18370031 as an inline patch. For Oracle 12.1.0.2, install the Oracle patch 18456643 as an inline patch. For more information, see http://ftp.suse.com .
- Currently, BDA supports Oracle 18c, Enterprise Edition.
- Currently, BDA supports Oracle 19c, Enterprise Edition.
Server | Version | RHEL 4 | RHEL 5 | RHEL 6 | RHEL 7 | OEL Linux 5 | Oracle Linux 6 | Oracle Linux 7 | SLES 10 | SLES 11 | SLES 12 |
---|---|---|---|---|---|---|---|---|---|---|---|
Single Instance | 11gR1 1 | ||||||||||
11gR2 | |||||||||||
12.1.0.1 | | | |||||||||
12.1.0.2 | | | |||||||||
12.2.0.1 | |||||||||||
18c | |||||||||||
19c 3 | |||||||||||
Single Instance (VCS) | 11gR1 1 | ||||||||||
11gR2 | |||||||||||
12.1.0.1 | | | |||||||||
12.1.0.2 | | | |||||||||
12.2.0.1 | |||||||||||
Single Instance (Restart-enabled) | 11gR1 1 | ||||||||||
11gR2 | |||||||||||
12.1.0.1 | | | |||||||||
12.1.0.2 | | | |||||||||
12.2.0.1 | |||||||||||
18c | |||||||||||
19c 3 | |||||||||||
RAC (CRS) | 11gR1 1 | ||||||||||
11gR2 | |||||||||||
12.1.0.1 | | | |||||||||
12.1.0.2 | | | |||||||||
12.2.0.1 | |||||||||||
18c | |||||||||||
19c 3 | |||||||||||
PDBs | 12.1.0.1 | | | ||||||||
12.1.0.2 | | | |||||||||
12.2.0.1 | |||||||||||
18c | |||||||||||
19c 3 |
1 Discontinued support from BDA version 8.9.02.
2 Support introduced in BDA version 8.9.03 Patch 2. This support is limited only to provisioning and patching.
3 Support introduced in BDA 2019 Release 02.
Server | Version | Windows 2008 | Windows 2008 R2 | Windows 2012 | Windows Server 2012 R2 | Windows Server 2016 | Windows Server 2019 |
---|---|---|---|---|---|---|---|
Single Instance | 11gR1 3 | 3 | |||||
11gR2 | 5 | ||||||
12.1.0.1 | 5 | ||||||
12.1.0.2 | 5 | ||||||
12.2.0.1 | 1 | 2 | 5 | ||||
18c | 4 | 4 | 4 | 5 | |||
19c 6 | 6 | 6 | 6 | 6 | |||
Single Instance (VCS) | 11gR1 3 | ||||||
11gR2 | |||||||
12.1.0.1 | |||||||
12.1.0.2 | |||||||
12.2.0.1 | |||||||
18c | |||||||
Single Instance (Restart-enabled) | 11gR1 3 | ||||||
11gR2 | |||||||
12.1.0.1 | |||||||
12.1.0.2 | |||||||
12.2.0.1 | |||||||
18c | |||||||
RAC (CRS) | 11gR1 3 | ||||||
11gR2 | |||||||
12.1.0.1 | |||||||
12.1.0.2 | |||||||
12.2.0.1 | |||||||
18c | |||||||
PDBs | 12.1.0.1 | ||||||
12.1.0.2 | |||||||
12.2.0.1 | |||||||
18c |
1 Support introduced in BDA version 8.9.02.
2 Support introduced in BDA version 8.9.03.
3 Discontinued support from BDA version 8.9.02.
4 Support introduced in BDA version 8.9.03 Patch 3.
5 Support introduced in BDA 2019 Release 01.
6 Support introduced in BDA 2019 Release 02.
Server | Version | Solaris 9 | Solaris 10 | Solaris 11 | HP-UX 11.23 | HP-UX 11.31 | HP-UX PARISC | IBM AIX 6.1 | IBM AIX 7.1 | IBM AIX 7.2 |
---|---|---|---|---|---|---|---|---|---|---|
Single Instance | 11gR1 2 | |||||||||
11gR2 | ||||||||||
12.1.0.1 | | |||||||||
12.1.0.2 | | |||||||||
12.2.0.1 | ||||||||||
Single Instance (VCS) | 11gR1 2 | 2 | ||||||||
11gR2 | 2 | | ||||||||
12.1.0.1 | ||||||||||
12.1.0.2 | ||||||||||
12.2.0.1 | ||||||||||
Single Instance (Restart-enabled) | 11gR1 2 | |||||||||
11gR2 | | |||||||||
12.1.0.1 | ||||||||||
12.1.0.2 | ||||||||||
12.2.0.1 | ||||||||||
RAC (CRS) | 11gR1 2 | |||||||||
11gR2 | ||||||||||
12.1.0.1 | ||||||||||
12.1.0.2 | ||||||||||
12.2.0.1 | ||||||||||
PDB | 12.1.0.1 | | ||||||||
12.1.0.2 | | |||||||||
12.2.0.1 |
1 Support introduced in BDA version 8.9.02.
2 Discontinued support from BDA version 8.9.02.
3 Oracle pluggable database (PDB) 12.1.0.2 with only single instance DBMS is supported on IBM AIX 7.2 for BMC Database Automation.
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
Microsoft SQL Server
The following prerequisites are required for installing Microsoft SQL Server:
- For SQL Server 2008 and 2008 R2 on Windows 2012:
- You must install SP3 after installing SQL Server 2008 on Windows 2012.
- You must install SP1 after installing SQL Server 2008 R2 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.
Install the Microsoft OLE DB Driver 18 for SQL Server (MSOLEDBSQL). This OLE DB driver complies with the latest TLS 1.2 standards.
Note
This prerequisite is mandatory for Creating a database on an instance of SQL Server and optional for Creating an instance of SQL Server.
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 for Windows Server 2019 Standard Edition, Windows Server 2016 Datacenter Edition, and Windows Server 2012 R2, 2012, 2008 R2 SP1, 2008 R2, 2008 SP2 Enterprise and Standard Editions:
SQL Server version | Editions | Instances | 2019 (x64) | 2016 (x64) | 2012 R2 (x64) | 2012 (x64) | 2008 R2 SP1 (x64) | 2008 R2 (x64) | 2008 SP2 (x64) | 2008 SP2 (x86) | 2008 (x64) |
---|---|---|---|---|---|---|---|---|---|---|---|
2017 (64-bit) | Standard, Developer, Enterprise, Enterprise Core | Standalone, Standalone on Clustered, Clustered, AlwaysOn Availability Group | |||||||||
2016 (64-bit) | Standard, Developer, Enterprise, Enterprise Core Datacenter, Business Intelligence | Standalone, Standalone on Clustered, Clustered, AlwaysOn Availability Group | |||||||||
2014 (64-bit) | Standard, Developer, Enterprise, Datacenter, Business Intelligence | Standalone, Standalone on Clustered, Clustered AlwaysOn Availability Group | |||||||||
2012 (64-bit) | Standard, Developer, Enterprise, Datacenter, Business Intelligence | Standalone, Standalone on Clustered, Clustered AlwaysOn Availability Group | |||||||||
2008 R2 (64-bit) | Standard, Developer, Enterprise, Datacenter | Standalone, Standalone on Clustered | |||||||||
2008 R2 (32-bit) | Standard, Developer, Enterprise, Datacenter | Standalone, Standalone on Clustered | |||||||||
2008 (64-bit) | Standard, Developer, Enterprise, Datacenter | Standalone, Standalone on Clustered | |||||||||
2008 (32-bit) | Standard, Developer, Enterprise, Datacenter | Standalone, Standalone on Clustered |
DB2
The following DB2 versions are supported:
Notes
- 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.
- BDA 2019 Release 01 supports direct BDA provisioning of DB2 11.1 fixpack 4.
DB2 version | RHEL 4 | RHEL 5 | RHEL 6 | RHEL 7 | RHEL 7.1 | RHEL 7.5 | IBM AIX 6.1 | IBM AIX 7.1 | IBM AIX 7.2 |
---|---|---|---|---|---|---|---|---|---|
11.5 (Enterprise Server Edition)4 | |||||||||
11.1 (Enterprise Server Edition, Advanced Enterprise Server Edition and Advanced Workgroup Server Edition) | |||||||||
10.5 (Enterprise Server Edition and Advanced Enterprise Server Editions) | |||||||||
10.1 (Enterprise Edition) | |||||||||
10.1 (Advanced Enterprise Edition) | |||||||||
9.7 (Enterprise Edition) | |||||||||
9.7 3a (Advanced Enterprise Edition) | |||||||||
9.5 (Enterprise Edition) |
1 Discontinued support from BDA version 8.9.02.
2 Support is applicable to AIX 7.1 Technology Level 5 and Service Pack 3.
3 Support is applicable to AIX 7.2 Technology Level 3 and Service Pack 2.
4 Currently, BDA supports DB2 version 11.5, Enterprise Server Edition only.
MySQL
BDA supports the following MySQL versions:
MySQL version | RHEL 5 | RHEL 6 | RHEL 7 |
---|---|---|---|
5.1.59 1 | |||
5.5.16 | |||
5.5.20 | |||
5.6 | |||
5.7 |
1 Discontinued support from BDA version 8.9.02
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.
SAP Adaptive Server Enterprise (ASE) Dataserver
The following versions of SAP ASE dataserver are supported:
ASE version | RHEL 5 | RHEL 6 | RHEL 7 | IBM AIX 6.1 | IBM AIX 7.1 | Solaris 10 (SPARC) |
---|---|---|---|---|---|---|
16.0 | ||||||
15.7.0 | ||||||
15.5.0 | ||||||
15.0.3 | ||||||
15.0.2 1 | ||||||
12.5.4 1 |
1 Discontinued support from BDA version 8.9.02.
SAP Replication Server
The following versions of SAP Replication Server are supported:
Repserver version | RHEL 5 | RHEL 6 | RHEL 7 | IBM AIX 6.1 | IBM AIX 7.1 | Solaris 10 (SPARC) |
---|---|---|---|---|---|---|
16.0 2 | ||||||
15.7.1 | ||||||
15.7.0 | ||||||
15.6.0 | ||||||
15.5.0 |
1 Discontinued support from version 8.9.02.
2 Support introduced in BDA version 8.9.03.
Comments
Log in or register to comment.