Field | Description |
---|---|
Host name |
Name of the Management database server. Host name is not displayed when Management DB on Oracle RAC is selected or when both Management DB on Oracle RAC and Profile DB on Oracle RAC are selected. |
Port | Port number to query the Management database server. Port number is not displayed when Management DB on Oracle RAC is selected. |
Database instance |
System Identifier (SID) of the Management database instance. Database instance is not displayed when Management DB on Oracle RAC is selected. Note: For information about the database host name, port number, and SID, contact your HP Business Service Management administrator. |
Database type | The type of database engine that is used to create the Management database. It can either be Oracle or MSSQL. |
Windows Authentication |
If you have selected MSSQL as the database type, you have the option to enable Windows authentication for MSSQL, that is, the user can use the same credentials to access SQL Server as that of the Windows system hosting the database. |
ManagementDB on Oracle RAC | This option appears only if you have selected Oracle as the database type. If only ManagementDB on Oracle RAC is selected and Profile DB on Oracle RAC is not selected, the profile database details are configured automatically. |
ProfileDB on Oracle RAC | This option appears only if you have selected Oracle as the database type. Configure the profile database parameters only when this option is selected. |
Database name | Name of the database. This field appears only if MSSQL is selected as the database type. |
Service name |
This option appears only if Management DB on Oracle RAC is selected Note:Service name is displayed instead of the Host name when users select only Management DB on Oracle RAC or both Management DB on Oracle RAC and Profile DB on Oracle RAC. |
User name |
Name of the Management database user, which was specified in the BSM Configuration Wizard when setting up the Management database. Note: If the Windows Authentication option is selected, this field is disabled. |
Password |
Password of the Management database user, which was specified in the BSM Configuration Wizard when setting up the Management database. Note: If the Windows Authentication option is selected, this field is disabled. |
Saved Successfully
message appears in the Information message panel.Note: You can only create a single Management database data source connection, after which the Create New button is automatically disabled.
After you save the newly created Management database connection, SHR retrieves the Profile database information from the Management database data source and lists all the available Profile database data sources under the Profile Database section.
To view details of the Profile database data source connection:
Field | Description |
---|---|
Host name | Name of the Profile database server. |
Port | Port number to query the Profile database server. |
Database instance |
System Identifier (SID) of the Profile database instance. |
DB type | The type of database engine that is used to create the Profile database. It can either be Oracle or MSSQL. |
Database name | Name of the Profile database. |
User name |
Name of the Profile database user. |
Note:Set up parameters for the profile management database, only if Profile DB on Oracle RAC is selected, or when both Management DB on Oracle RAC and Profile DB on Oracle RAC are selected. In such an instance, the Create New option under Profile Database is displayed.
Data collection for the Profile database data source is enabled by default. In addition, the collection frequency is scheduled for every one hour.
Note: Copy the seed.properties and encryption.properties files from the %topaz_home%\Conf folder on HP BSM DP Server to the %PMDB_HOME%\config folder on the HP SH Reporter system to discover Profile DB.In case of Oracle RAC copy bsm-tnsnames.ora in addition to these files.