Database requirements

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.

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.

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.

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.

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.

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.

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.

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.

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.