Important

   

Starting from version 8.9.03, BMC Network Automation is renamed to TrueSight Network Automation. This space contains information about TrueSight Network Automation 8.9.03 and the later service packs for 8.9. For earlier releases, see BMC Network Automation 8.9.

Database requirements

The TrueSight Network Automation application server requires a database. Currently, TrueSight 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 tablespace), make backups, and troubleshoot the external database.

This topic describes the supported database versions and a few considerations for external databases. 

Note

Supported databases

Note

If you would like TrueSight 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 18c (supported only for version 8.9.04, external database encryption)
  • Oracle Database 12RAC1 (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 33 (not supported for version 8.9.04, support for encrypted connections)
  • Microsoft SQL Server 20083 (not supported for version 8.9.04, support for encrypted connections with SQL Server 2008 Service Pack 3 and later)
  • PostgreSQL 10.22
  • PostgreSQL 9.6.4
  • 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, TrueSight Network Automation uses the following PostgreSQL versions:

    TrueSight Network Automation versionPostgreSQL version
    8.9.04.003
    8.9.04.002
    8.9.04.001
    8.9.04
    10.2
    8.9.0310.2
    8.9.029.6.4
    8.9.019.5.5
    8.9.009.5.3

    3. Not supported for version 8.9.04 and later

Warning

TrueSight Network Automation does not support database compression. Therefore, you must disable database compression prior to installing or upgrading TrueSight Network Automation.

Considerations during a fresh TrueSight 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, TrueSight 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
SQL Server

Supported by
Oracle Server

Are_there_heap_tables

Yes

Yes

Require_DBM (Database Mirroring)

No

No

Preferred Fill Factor for indexes

Default

Default

Is_Data_Archievable

Yes

Yes

Is_Application_logging_in_DB 1  

No

No

Is_Linked_Sever_leveraged

No

No

Is_Bulk_Data_Loaded

No

No

Is_SQLCLR_leveraged (Dot Net CLR)

No

No

Is_Non_Default_Collation_leveraged

No

No

Are_Extended_SPROCs_leveraged (Extended Stored Procedures)

No

No

Is Master_DB called (For SQL Server)

No

No

Is_Partitioning_leveraged

No

No

Are_Materialzied_Views_leveraged

No

No

Are_Triggers_leveraged

No

No

Is_Auditing_leveraged

No

No

Is_Dynamic_SQL_leveraged

Yes

Yes

Is_DB_Trustworthy_Enabled

No

No

Is_forced_parameterization_leveraged

No

No

is_db_chaining_leveraged

No

No

Is_Encryption_leveraged

No

No

Is_Object_Level_Encrytion_leveraged

No

No

Is_Replication_leveraged

No

No

Is_Service_Broker_leveraged

No

No

Is_TDE_Encryption_leveraged

No

No

Is_Full_Text_leveraged

No

No

Is_FileStream_Leveraged

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

Was this page helpful? Yes No Submitting... Thank you

Comments