Database requirements
The BMC Network Automation application server requires a database. Currently, BMC Network Automation supports the following databases:
- Embedded PostgreSQL
The embedded PostgreSQL database is packaged and installed with the product. It is configured to function with minimal maintenance.The product administrator is responsible for configuring options for the external databases. - Remote PostgreSQL (RPostgreSQL)
- Oracle
- Microsoft SQL Server
Recommendation
BMC strongly recommends that an external database be administered by a qualified database administrator (DBA) to configure, monitor resources (such as disk space and table space), make backups, and troubleshoot the external database.
This topic describes the supported database versions and a few considerations for external databases.
Note
For additional database-related requirements associated with the installation of the application server, see Installing the application server on Windows or Installing the application server on Linux.
Supported databases
Note
If you would like BMC Network Automation to support any particular version of database, log an IDEA on
BMC Communities
.
The following databases are supported for use with the application server:
- Oracle Database 12c RAC1 (external database encryption)
- Oracle Database 12c1 (external database encryption)
- Oracle Database 11g release 2 RAC (external database encryption)
- Oracle Database 11g release 2 (external database encryption)
- Microsoft SQL Server 2016 (support for encrypted connections)
- Microsoft SQL Server 2014 (support for encrypted connections)
- Microsoft SQL Server 2012 (support for encrypted connections)
- Microsoft SQL Server 2008 R2 SP 3 (support for encrypted connections)
- Microsoft SQL Server 2008 (support for encrypted connections with SQL Server 2008 Service Pack 3 and later)
- PostgreSQL 9.6.42
PostgreSQL 9.5.5
PostgreSQL 9.5.3
Note
1. The supported version of 12c is 12.1.0.2 with pluggable database (PDB).
2. When you choose the embedded database option, BMC Network Automation uses the following PostgreSQL versions:
BMC Network Automation version PostgreSQL version 8.9.02 9.6.4 8.9.01 9.5.5 8.9.00 9.5.3
Warning
BMC Network Automation does not support database compression. Therefore, you must disable database compression prior to installing or upgrading BMC Network Automation.
Considerations during a fresh BMC Network Automation installation
- For SQL Server and RPostgreSQL databases, you can create a new database or use an existing one. When using an existing database, the existing database must be clean or empty.
- For an Oracle database, you can create a new database or use a existing one. When using an existing database, the database schema must be fresh.
- For an Embedded PostgreSQL database, BMC Network Automation handles the database requirements.
- Disable database compression.
Important
You cannot change the database type during upgrade.
Oracle and SQL Server database requirements
The following table lists the parameters supported by Oracle and Microsoft SQL Server database servers:
Parameter | Supported by | Supported by |
---|---|---|
| Yes | Yes |
| No | No |
| Default | Default |
| Yes | Yes |
Is_Application_logging_in_DB 1 | No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| Yes | Yes |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
| No | No |
1 This parameter is used to determine whether the application stores its logs on the application server or in the database.
Related topics
Configuring databases for Windows
Configuring databases for Linux
Comments