Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Database requirements

Not every product in the BMC Cloud Lifecycle Management solution requires a database. Certain products can share a database with other products in the solution, as explained in the Windows database requirements for supporting products and the Linux database requirements for supporting products sections. You can install the database on the same host as the BMC product, or you can install a remote database. Regardless of where you install the database, you can use the pre-create database option if you meet the requirements listed in this topic.

This topic explains the database requirements for the following products:

  • BMC Remedy AR System & IT Service Management Suite
  • BMC Remedy AR System Server – Cloud Database
  • BMC Server Automation
  • BMC Network Automation
  • BMC ProactiveNet Performance Management Central Server (Linux only)
  • BMC ProactiveNet Performance Management Server (Linux only)

This topic provides the following information:

Requirements common to database platforms

This section outlines the requirements that are common to Microsoft SQL Server and Oracle.

Supported database versions

The BMC Cloud Lifecycle Management solution supports the following databases:

  • Microsoft SQL Server 2008 R2 Enterprise 64-bit (if you require Cluster capabilities) on Microsoft Windows 2008 R2 64-bit OS.
    Otherwise, you can use Microsoft SQL Server 2008 R2 Standard 64-bit for single installations.

    Microsoft Support provides useful information on determining the version and edition of SQL Server and its components.

  • Oracle Database 11g R2 64-bit on Red Hat Enterprise Linux 5.5 64-bit OS

Unicode and character set requirements for databases

The following Unicode and character set requirements apply to both MS SQL Server and Oracle databases:

  • You must synchronize all your databases so that their character sets and Unicode settings are correctly aligned with their <product>, for example, BMC Remedy AR System settings.
  • You must run Unicode to Unicode or non-Unicode to non-Unicode. Do not mix these settings.
  • For Oracle, you must set the character sets to AL32UTF8.
  • For MS SQL Server, you must set the Unicode data types to nchar, nvarchar, and ntext.

Oracle requirements for Linux

This section explains the Oracle requirements for a Linux installation, such as pre-create options, tablespace requirements, and database requirements. The BMC Cloud Lifecycle Management solution supports Oracle Database 11g R2 64-bit on the Red Hat Enterprise Linux 5.5 64-bit OS.

Package Managers required for the Oracle client

Install these packages for products that require an Oracle client.

    Page not found for multiexcerpt macro.
The page: Common product host requirements was not found. Please check/update the page name used in the 'multiexcerpt-include macro.

Tablespace and database instance requirements

For products in the solution that require a database, you can use a local or remote database. Certain products in the solution can share a database. Therefore, you can apply a specific Oracle database instance to one or more product installations, as explained in the product-specific database requirements. Before you begin your product installations, make sure that the database software and the instance that you created are running.

Additionally, you can use a pre-created tablespace or allow the installer to create a tablespace for a given product, if the product supports it, during the installation. To use the pre-created tablespace option, you must have required system user and password credentials. For more information about the tablespace and database requirements per product in the solution, see the product-specific database requirements.

Note

The instance name that you provide must be less than or equal to 8 characters. Otherwise, the installer does not accept the instance name.

Oracle RAC ASM requirements

If you are using Oracle Real Application Clusters (RAC) Automatic Storage Management (ASM) in your environment, ensure that the DB_CREATE_FILE_DEST property is set to an appropriate value. Otherwise, the tablespace is not created successfully.

Example

ALTER SYSTEM SET DB_CREATE_FILE_DEST = '+DATA2';

Pre-create database support and requirements for Linux

In the table in the product-specific database requirements, the valid values for the pre-created tablespace support for Oracle are as follows:

  • Yes, but optional — A pre-created tablespace is supported. However, you can choose to have the installer create the tablespace during the installation process.
  • No, mandatory — A pre-created tablespace is not supported. You must allow the installer to create a tablespace. However, you must create default, index, and temporary tablespaces for the user in advance.

Note

The BMC Cloud Lifecycle Management Installer creates Oracle tablespaces with default file sizes and with auto-extend set to on, as listed in the following table, and users for products that require them. If you want to use the pre-created database option, ensure that you use the file size details listed in the table. You must have database administrator (DBA) credentials to create the tablespace and users for the pre-created database and installer-created database option.

For more information about pre-created databases, see the documentation for the respective product in the documentation for related products.

Linux database requirements for supporting products

The following table lists the requirements for Linux databases. For specific preparatory tasks that you must perform before you complete product installation, see the Additional information column.

SQL Server requirements for Windows

For SQL Server databases, you can have the installer create a database during the installation process or you can pre-create a database for your products, as indicated in the table in product-specific database requirements. However, the installer requires you to authenticate a pre-created database. The BMC Cloud Lifecycle Management solution supports Microsoft SQL Server 2008 R2 Enterprise 64-bit (if you require Cluster capabilities) on Microsoft Windows 2008 R2 64-bit OS. Otherwise, you can use Microsoft SQL Server 2008 R2 Standard 64-bit for single installations.

Note

You must have DBA credentials to create the database and users for the pre-created database and installer-created database option.

Pre-create database support and requirements for Windows

In the table in product-specific database requirements, the values for the pre-created database support for SQL Server are as follows:

  • Yes, but optional — A pre-created database is supported. However, you can optionally choose to have the installer create the database during the installation process.
  • Yes, and mandatory — You must use a pre-created database.
  • No — A pre-created database is not supported. You must allow the installer to create a database and a user.

Note

The BMC Cloud Lifecycle Management Installer creates an SQL Server database with the default data and log file sizes listed in the table in the following section, and users for products that require them. If you want to use the pre-created database option, ensure that you use the file size details listed in the table.

For more information about pre-created databases, see the documentation for the respective product in the documentation for related products.

Windows database requirements for supporting products

The following table lists the requirements for SQL Server databases. For specific preparatory tasks that you must perform before you complete product installation, see the Additional information column.

Where to go from here

End-to-end installation flow

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

Comments