This section details information about requirements that must be in place before beginning the installation, preinstallation tasks that you must perform and other considerations. If you are upgrading from a previous BMC TrueSight Operations Management Reporting installation, see Upgrading.
Use the following table to record the information that you must provide when you install and configure BMC TrueSight Operations Management Reporting. Having this information on hand will help you perform a seamless installation and configuration of BMC TrueSight Operations Management Reporting.
Planning sheet for installation and configuration
Decision or requirement | Your entry |
---|---|
Database Information page on the BMC TrueSight Operations Management Report Engine installation wizard |
|
Fully Qualified Database Host Name Provide the full name of the computer on which the Oracle or SQL database is installed or the Oracle RAC SCAN name. |
|
Port Provide the listener port for the database. The default port number for Oracle is 1521 and for SQL is 1433. |
|
Database Name Provide the name of the database, SID in Oracle, pluggable database name, RAC database service name, or SQL Server database name. If you are using the Oracle 12C database with pluggable option, you must enter only the pluggable Database name (For example, PDBORCL or PDBORCL.BMC.COM). |
|
Database Instance Name (applicable to SQL Server database only) Provide the name of the database instance name (SQL). | |
Database Login For Oracle: Provide the name of the database user that you created by running the create_TrueSightOperationsManagementReporting_user_tablespaces.sql script. For SQL: Provide the name of the SQL login that you created by running the create_sql_user.bat script. |
|
Database Password Provide the corresponding password for the preceding user account. |
|
BusinessObjects Information page on the BMC TrueSight Operations Management Report Engine installation wizard |
|
CMS Server Name Provide the name of the computer on which you have installed SAP BusinessObjects Enterprise. Note To determine the CMS Server Name, perform the following steps:
|
|
User Name Provide the authenticated SAP BusinessObjects user name to access the CMS server. The default user name is Administrator. |
|
Password Provide the corresponding password for the user name. You configured this password for the administrator account while installing SAP BusinessObjects Enterprise. |
|
Port Number Provide the port number through which the communication is established with the computer on which SAP BusinessObjects Enterprise is installed. The default port number is 6400. |
|
For mcell.dir file |
|
Location of the mcell.dir file on BMC TrueSight Infrastructure Management server The file is located in the BMCTrueSightIMServerInstallDir\pw\server\etc directory. |
|
fullyQualifiedHostName Provide the full name of the computer on which you have installed BMC TrueSight Operations Management Report Engine. |
|
encryptionKey Provide the encryption key for the BMC TrueSight Infrastructure Management cell that is used to control access to the cell. The default key is mc. |
|
portNumber Provide the port number at which the cell communicates with the computer on which BMC TrueSight Operations Management Report Engine is installed. The default port number is 3783. |
|
For cell_config command |
|
cellName Provide the name of the BMC TrueSight Infrastructure Management cell to be subscribed for BMC TrueSight Operations Management Report Engine. |
|
hostName Provide the name of the computer on which the BMC TrueSight Infrastructure Management cell is installed. Typically, the cell is installed in the BMC TrueSight Infrastructure Management server. |
|
portNumber Provide the port number at which the cell communicates with the host computer. The default port number is 1828. |
|
encryptionKey Provide the encryption key for the BMC TrueSight Infrastructure Management cell that is used to control access to the cell. The default key is mc. |
|
For tnsnames.ora file to configure Oracle client on the computer where SAP BusinessObjects Enterprise is installed |
|
addressName Provide the name of the protocol address of the listener. |
|
hostName Provide the name of the host server for the database. |
|
port Provide the listener port for the database. The default port number is 1521. |
|
sid Provide the database instance name, commonly known as system identifier. The default value is orcl. |
|
For User Identification dialog box when you import the universe from the repository using SAP BusinessObjects Information Design Tool |
|
System Provide the name of the computer on which you have installed SAP BusinessObjects Enterprise. |
|
User Name Provide the authenticated SAP BusinessObjects user name to access the server. The default user name is Administrator. |
|
Password Provide the corresponding password for the user name. You configured this password for the administrator account while installing SAP BusinessObjects Enterprise. |
|
Authentication Provide the Microsoft Windows authentication mode. |
|
For Login Parameters page when you select the Parameters from the File menu of SAP BusinessObjects Information Design Tool |
|
User Name For Oracle: Provide the name of the user account that you created using the create_TrueSightOperationsManagementReporting_user_tablespaces.sql script to access the database instance. For details, see Creating tablespaces and user on Oracle database. For SQL: Provide the login account created using the create_sql_user.bat script. For details, see Creating database and user on SQL Server. You can also use read only user REUNIV to create a connection for generating reports. |
|
Password Provide the corresponding password for the user name. |
|
Net Service Provide the name of the connection with which you configured the Oracle client. This is the addressName that you specified in the tnsnames.ora file. For details, see Configuring Oracle client. |
|
Database Provide the name of the connection with which you configured the JDBC driver. | |
For Configuration Parameters page when you select the Parameters in SAP BusinessObjects Information Design Tool while creating database connection |
|
Connection Pool Mode Provide the method to use to keep the connection active. This is necessary only when you use a connection pool. |
|
Pool timeout If you select the connection mode as Keep the pool active for, provide the length of time to keep the connection open. The default value is 10. |
|
Array fetch size Provide the maximum number of rows that must be authorized with each fetch. The default value is 250. |
|
Array bind size Provide the size of the bind array that the connection server must use before sending the data to the repository. The default value is 32767. |
|
Login timeout Provide the number of seconds before a connection attempt must time out and an error message is displayed. The default value is 600. |
|
Performance and scalability recommendations