Installing the Oracle Business Intelligence Server

This chapter describes the prerequisites, instructions, and verification steps for installing the Oracle Business Intelligence Server:

Installing Oracle Business Intelligence

  1. Set up a static IP address for the Oracle Business Intelligence server.
  2. Extract the following from the installation file archive in the same file structure to the Oracle Business Intelligence server. Do not extract the files to a folder structure that contains spaces.

    /OBIEE/

    /OBIEEPatch/

    /Weblogic/

    Install_version.exe

  3. Double-click Install_version.exe to launch the installation wizard.
  4. On the Choose Install Folder page, enter the installation path or click Choose to select the installation path.
  5. On the Before We Begin page:
    1. For Would you like to install or upgrade a database with this installation for either myMicros or iCare?, select No.
    2. For Will different features connect to the myMicros Database using different database IP Addresses, select Yes if you expect to use more than one IP/SID to connect to the Enterprise Back Office database. For example, select Yes in an Oracle Real Application Cluster (RAC) environment that does not use a virtual IP and when features such as Remote Transfer Agent connect to a different node. If you select No, you can still modify the connection strings, but you cannot view individual database information screens by feature.
    3. Select Yes or No for whether you will install Gift and Loyalty (iCare), Inventory Management (myinventory), and the weather service. The installation wizard shows setup and configuration screens for each application that you select Yes.
    4. For Will myLabor be used with this installation?, select No. Labor Management must be installed with Reporting and Analytics.
  6. On the Use existing Portal configuration page, make your selection based on your installation:
    1. If you want to install with a clean set of configurations, select No to install and configure a new installation set.
    2. If you are performing an upgrade and want to keep old settings, select Yes to use existing configurations. You can then select whether to configure the feature set on the Additional Features page.
  7. On the Choose Install Set page, select OBIEE and other components that you want to install on this server.
  8. On the Check if Cluster Environment page, select No.
  9. On the WebLogic Info - Obiee Box page, configure the application server settings:

    Table 3-1 Oracle WebLogic Application Server Information

    Field Description

    WebLogic User Name and WebLogic Password

    Create the login credentials for an administrator account on the WebLogic application server. The password must be eight to 20 characters, must not contain special characters, and must include at least one number.

    Local JVM Path

    Verify the folder path to the local Java Development Kit installation. This install path must not contain spaces.

    WebLogic Admin Server Host Name and WebLogic Admin Server Port

    Enter the hostname and port of the Oracle Business Intelligence server, typically 7001.

    BI Server Port

    Enter the port used by Oracle Business Intelligence, typically 9704.

    Node Manager port

    Enter the port used by the Node Manager, typically 9556.

  10. On the OBIEE Installation page, configure the connection to the OBIEE database and Repository Creation Utility (RCU) schemas:

    Table 3-2 Oracle Business Intelligence Enterprise Edition Database Information

    Field Description

    RCU Database Location

    Enter the hostname of the Enterprise Back Office database containing the RCU installation.

    SQL Server or Oracle

    Select the database type.

    Port and Database Service Name

    Enter the port used by the database, and any additional connection parameters as necessary.

    BIPLATFORM Schema Password

    Enter the schema password you created for the RCU during database installation.

    MDS Schema Password

    Enter the schema password you created for the RCU during database installation.

  11. On the Published URL - OBIEE page, enter the published site URL. What are Published Site URLs? contains more information.
  12. On the OBIEE Repository page, create a password for OBIEE RPD files. The password must be eight to 20 characters, must not contain special characters, and must include at least one number.
  13. (Upgrades only) On the Where would you like to store a backup copy of the existing installation? page, select the folder to store a backup of the installation.
  14. On the SSL page, select Yes to enable SSL/Transport Layer Security.
  15. On the Certificate Configuration - OBIEE page, fill out the form to install the signed certificate:
    1. Enter the Keystore Password, the Private Key Password, and the Alias that was used when generating the Certificate Signing Request.
    2. Click Choose and select the certificate file, and then click Next.

      Make sure the filepath includes the following components: folder_path/file_name.extension

    3. Verify the certificate information, and then click Next.
  16. On the Database Information page, configure the connection to the Reporting and Analytics database:

    Table 3-3 Database Information

    Oracle Database Microsoft SQL Server
    1. In the Database Type section, select Oracle, and then enter the database network port and SID.

    2. Enter the database login credentials.

    3. Enter the hostname of the database server.

    4. In the Preferred Cache Type drop-down list, select Oracle.

    1. In the Database Type section, select SQL Server, and then enter the database network port.

    2. In the Additional Connection Parameters field, enter any required connection strings.

    3. Enter the database login credentials.

    4. Enter the hostname of the database server.

    5. In the Preferred Cache Type drop-down list, select Generic.

  17. On the Repository Database Information page, configure the connection to the Business Intelligence Repository database (BiRepos):

    Table 3-4 Repository Database Information

    Oracle Database Microsoft SQL Server
    1. In the Database Type section, select Oracle, and then enter the database network port and SID.

    2. Enter the login credentials to the Business Intelligence Repository database.

    3. Enter the login credentials to the Quartz Job Scheduler database.

    4. Enter the hostname of the Business Intelligence Repository database server. The information is typically filled by the installation wizard.

    5. Enter the externally-facing address for access to Enterprise Back Office. This is typically the published URL for Reporting and Analytics.

    1. In the Database Type section, select SQL Server, and then enter the database network port.

    2. Enter the login credentials to the Business Intelligence Repository database.

    3. Enter the login credentials to the Quartz Job Scheduler database.

    4. Enter the hostname of the Business Intelligence Repository database server. The information is typically filled by the installation wizard.

    5. Enter the externally-facing address for access to Enterprise Back Office. This is typically the published URL for Reporting and Analytics.

  18. (InfoDelivery only) On the InfoDelivery Configuration page, enter login credentials to the CE database.
  19. On the OBI Database Information page, enter the password to the Oracle Business Intelligence (OBI) database.
  20. On the Aggregation DB information for Obiee Repository page, configure the aggregation server to use with the Oracle Business Intelligence Enterprise Edition (OBIEE) repository:

    Table 3-5 Aggregation Database Information

    Oracle Database Microsoft SQL Server
    1. Enter the hostname and port for the database server hosting the OBIEE aggregate database.

    2. Enter the database service name in Aggregate_DB Service name.

    1. Enter the hostname and port for the database server hosting the OBIEE aggregate database.

    2. Enter additional connection parameters.

  21. On the Is this an OLAP Portal Instance page, select DUAL.
  22. On the OLAP Database Type Database Information page, configure the OLAP database connection as described in the following table:

    Table 3-6 Online Analytical Processing Database Connection

    Field Description

    OLAP Login and OLAP Password

    Enter the login credentials for the OLAP database.

    OLAP Server name or IP

    Enter the hostname of the OLAP database.

    OLAP DatabasePort

    Enter the OLAP database server port.

    OLAP DB SID

    Enter the SID for the OLAP database.

  23. (Gift and Loyalty only) On the Segmentation Data Access Login page, enter the login credentials to the Segmentation Aggregate_DB.
  24. (Gift and Loyalty only) On the iCare Database Information page, enter the address, port, and connection properties to the Gift and Loyalty database server.
  25. (Admin Server only) On the Posting/Admin Database Information page, enter the address to the server hosting the Aggregate Database server.
  26. On the Portal Mail Server page, enter the Simple Mail Transfer Protocol (SMTP) hostname and port of the server that will host the IceWarp Mail Server, and then enter the mail domain, such as example.com.

    The Mail Server is typically installed on the Reporting and Analytics application server.

  27. (Admin Server only) On the Posting/Admin Mail Server page, enter the mail domain, SMTP port, and POP3 port for the IceWarp Mail Server to be used by the Admin Server.
  28. (Master Server only) On the Master Mail Server page, enter the mail domain, SMTP port, and POP3 port for the IceWarp Mail Server to be used by the Master Server.
  29. On the InfoDelivery Mail Server page, enter the hostname of the IceWarp Mail Server or the server to host the InfoDelivery service, and then enter the SMTP port.
  30. On the Location of Master Server page, enter the hostname of the Master Server.
  31. On the Mail Users page, configure the accounts used by Enterprise Back Office:
    1. In the Mail account jobs will be sent to by the client stores field, enter the email account that the Master Server uses to receive resultSets data and deploy jobs.
    2. In the Email account that will receive errors field, enter the email account to which the Point-of-Sales stores forward error messages.
  32. (InfoDelivery only) On the Portal/InfoDelivery Settings - Font page, you can configure custom fonts for InfoDelivery as described in the following table:

    Table 3-7 Portal/InfoDelivery Font Settings

    Field Description

    Enable User Font

    Select whether to allow using a custom font when rendering PDFs. You can then enter the path to the font, or click Choose to navigate to the font.

    Limit detail query days

    Enter a date limit for executing audit/analysis detail queries. The Organization configuration can override this setting.

    Limit summary query days

    Enter a date limit for executing audit/analysis summary queries. The Organization configuration can override this setting.

    New Line Style for infoDelivery CSV format

    Select whether to use Windows, Unicode, or HTML line styling when formatting Report Mail items in CSV.

    Load reports by market segment

    Select whether to load reports dynamically by appending the organization or role market segment to the template name.

  33. (Admin Server only) On the Admin Server Configuration page, enter the login credentials for the Admin Server database and the CEDB.
  34. (InfoDelivery only) On the InfoDelivery Configuration page, enter the infoDelivery email login credentials for sending and receiving emails.
  35. (InfoDelivery only) On the InfoDelivery page, leave the Pentaho Solutions Directory blank.
  36. (Gift and Loyalty only) On the iCare Configuration for Portal page:
    1. Enter the URL for Gift and Loyalty campaigning. This is typically http://Gift and Loyalty URL:80/offers/
    2. Enter the URL for Gift and Loyalty Stored Value. This is typically the hostname of Gift and Loyalty.
    3. Enter the URL for Gift and Loyalty for RTA downloads. This is typically the hostname of Gift and Loyalty.
    4. Enter the database login credentials for the Gift and Loyalty database. This is typically the MMSQL account.
    5. Enter the URL of the ExactTarget WSDL file.
  37. (Labor Management only) On the myLabor Configuration for Portal page, you can change the port number used for non-secure connections and SSL connections. Do not change the syntax.
    1. Non secure port for myLabor: -Dhttp.browser.port=port
    2. SSL port for myLabor: -Dhttp.sslaccel.port=port
  38. (Inventory Management only) On the myInventory Settings for Portal page, select the Inventory Management database server type, enter the address and port of the database server, and then enter the external-facing published site URL for Inventory Management.
  39. Configure Reporting and Analytics:
    1. On the Portal Specific Settings page, configure Reporting and Analytics as described in the following table:

      Table 3-8 Reporting and Analytics Configurations

      Field Description

      Names of all Portal Application Servers

      Enter the hostnames of all Reporting and Analytics web application servers in a comma-separated list.

      Administrator e-mail address

      Enter the email address, without the domain, of the administrator account.

      What email user will the Portal use to send mail?

      Enter the email address, without the domain, that the Portal uses to send mail.

      What is the password for the email user?

      Enter the password for the portal email user.

      Use HTTPS protocol for portal?

      Select whether the web application uses the HTTPS protocol. This option requires a Secure Socket Layer (SSL) connection and should typically only be selected when the installation environment has an SSL accelerator.

      Password for Messaging Queue

      Enter the login credentials for the messaging queue. This field does not show when performing an upgrade.

      Username and Password for utility user

      Enter the login credentials for the UTIL account created during database installation.

      Username and Password for CE user

      Enter the login credentials for the CEDB account created during database installation.

      New Line Style for Portal CSV display

      Select whether to use Windows, Unicode, or HTML line styling when using the CSV export while viewing a report.

    2. On the Portal Specific Settings - Purge page, select whether Reporting and Analytics uses thread pooling to purge threads, and then configure the purge parameters.
    3. On the Portal Specific Settings - Aggregation and Adjustment Service page, enter the hostname of the server that will host the Adjustment and Aggregation Service in the Adjustment Server Name field.
    4. (Alert Engine only) On the Portal Specific Settings - Mobile page, enter the login credentials for the Alert Engine server.
  40. Configure Info Delivery for Oracle Business Intelligence:
    1. On the InfoDelivery Configuration page, enter the infoDelivery email login credentials for sending and receiving emails.
    2. On the Portal/InfoDelivery Settings - Font page, configure the Report Mail font settings as described in the following table:

      Table 3-9 Report Mail Font Configurations

      Field Description

      Enable User Font

      Select whether to allow using custom fonts when rendering PDFs.

      Path to user font

      Enter the path to a font, or click Choose and navigate to a font, to set the font used when rendering PDFs.

      Limit detail query days

      Enter a date limit for executing audit/analysis detail queries. The Organization configuration can override this setting.

      Limit summary query days

      Enter a date limit for executing audit/analysis summary queries. The Organization configuration can override this setting.

      New Line Style for InfoDelivery CSV format

      Select whether to use Windows, Unicode, or HTML line styling when formatting Report Mail items in CSV.

      Load reports by market segment

      Select whether to load reports dynamically by appending the organization or role market segment to the template name.

  41. On the Confirm Datasource Name page, enter the OLAP database name in the OLAPDS database name field. By default, this field uses AGGREGATE_DB.
  42. (Master Server only) On the Master Server Configuration page, configure the Master Server as described in the following table:

    Table 3-10 Master Server Configurations

    Field Description

    RTA database login and RTA database password

    Enter the RTA database login credentials for inserting and updating the RTA_Processed_job table. The account must have full permissions on the database/schema.

    COREDB login and COREDB password

    Enter the COREDB login credentials for file transport. The account must have the same level of permissions on the Core database/schema.

    Email account name for the Errors Administrator and Email account password

    Enter the e-mail account credentials for the Error Administrator.

    Merak 8.5 or higher

    Select whether Merak 8.5 or higher is installed on the environment.

    Where is the Merak installation located?

    If Merak is installed on the environment, enter the installation path.

    Server1 account password

    Enter the password for the server1 login account.

    Cache type for the Master Service

    Select the Master Service cache type from the drop-down list.

  43. (Posting Server only) On the Posting Server Configuration page, configure the Posting server as described in the following table:

    Table 3-11 Posting Server Configurations

    Field Description

    How many posting threads should run on the server simultaneously?

    Enter the number of simultaneous posting threads. Entering a number greater than eight can lead to performance degradation.

    How many days of psLogs should be saved?

    Enter the amount of days that the posting server preserves the Result sets and the entries in the RTA_Processed_job table.

    What directory should hold psLogs?

    Enter the path to the folder where the posting server saves the logs in .zip format.

    Move History by location rather than full server?

    Select or deselect whether to move history by location rather than moving history by server. If you deselect this option, the admin server stops posting for the duration of the move.

    Limit move history day range

    Select or deselect whether to limit moving history by date. You should typically only use this option when you partition databases by date.

    What name would you like to use for Temporary Menu Items?

    Enter the name the posting server uses for temporary menu items.

    What database user should posting use?

    Enter the database account name for posting.

    What is the password for this user?

    Enter the database account password for posting.

    Run alignment with definitions posting?

    Select or deselect whether to run alignment while posting definitions. Select this option if the environment contains an aggregation engine.

  44. On the InfoDelivery Configuration page, enter the Info Delivery email username for sending and receiving emails, and the Info Delivery administrator email account.
  45. (Alert Engine only) On the Alert Engine Configuration page, configure the Alert Engine as described in the following table:

    Table 3-12 Alert Engine Configurations

    Field Description

    Push alert service username and Push alert service password

    Enter the login credentials for the push alert service.

    Number of alert threads

    Enter the number of alert threads.

    Portal DB User and Portal DB Password

    Enter the Enterprise Back Office database login credentials.

    Core DB User and Core DB Password

    Enter the core database login credentials.

    Location Activity DB User and Location Activity DB Password

    Enter the location activity database login credentials.

    RTA DB User and RTA DB Password

    Enter the RTA database login credentials.

    CE DB User and CE DB Password

    Enter the CE database login credentials.

  46. (Admin Server only) On the Admin Server Configuration page, configure the Admin Server as described in the following table:

    Table 3-13 Admin Server Configurations

    Field Description

    Trailer to send in alerts from Admin Server

    Enter trailer text in the four fields provided.

    Email account to send alerts from

    Enter the email name, without the domain, that the Admin Server uses to send alerts.

    Number of hours before a location is considered out of contact

    Enter the maximum number of hours before the Admin Server flags an unresponsive location.

    Email addresses to send long alert messages to

    Enter the email name, without the domain, to which the Admin Server sends long alert messages. You can separate multiple addresses with a comma.

    Email addresses to send short alert messages to

    Enter the email name, without the domain, to which the Admin Server sends short alert messages. You can separate multiple addresses with a comma.

    Email addresses to send copies of org alerts to

    Enter the email name, without the domain, to which the Admin Server sends a copy of all alerts.

    Folder containing custom packages for Admin Server

    Enter a folder path containing custom packages.

  47. (Aggregation and Adjustment only) On the Aggregation and Adjustment Configuration page, configure the database connection to the Aggregation and Adjustment service as described in the following table:

    Table 3-14 Aggregation and Adjustment Service Login

    Field Description

    Core database login and Core database password

    Enter the core database login credentials.

    RTA database login and RTA database password

    Enter the RTA database login credentials.

    Portal database login and Portal database password

    Enter the Enterprise Back Office database login credentials.

    Location Activity database login and Location Activity database password

    Enter the location activity database login credentials.

    Name for Analysis/Aggregation Instance

    Enter a unique name for this instance of the analysis/aggregation service. The service inserts the name into the database to denote which service processed a job.

    Connection Cache Type

    Select a connection cache type from the drop-down list.

  48. (Weather Service only) On the Weather Configuration page, configure the weather service as described in the following table:

    Table 3-15 Weather Configurations

    Field Description

    What is the database login for the Weather Service?

    Enter the username for the database login, typically MSSQL.

    What is the database password for the Weather Service?

    Enter the password for the database login.

    How many days of weather should be stored in the database?

    Enter the number of days of weather information that should be stored and retained in the database.

    Enter 0 to disable database storage.

  49. On the Review page, select your preferred review type:
    • Normal: Review the install folder, features, and disk space requirements.

    • Advanced: Review and edit individual variables in the installation files, then review the install folder, features, and disk space requirements.

  50. Review the Pre-Installation Summary, and then click Install.
  51. If you are performing a fresh installation on the 64-bit version of Microsoft Windows Server 2012, the installation wizard shows the Oracle Business Intelligence has stopped working error while the Oracle Universal Installer is copying files. This error is caused by a known issue with the Oracle Business Intelligence installation. Click Close the program to ignore the message and continue installation.
  52. To set up Report Mail for OBIEE:
    1. Log in to Enterprise Manager and expand the WebLogic Domain folder.
    2. Right-click bifoundation_domain, select Security, and then select Credentials.

      This image is a screenshot of the steps listed in step 52b with the bifoundation_domain folder circled, security circled, and credentials circled.
    3. Expand the oracle.bi.enterprise folder, select mail.server, and then click Delete.

      This image is a screenshot of step 52c with the mail.server option circled and the delete button circled.
    4. Click Deployment and then click Mail. Confirm that the Username and Password fields are blank.
    5. Restart the services.

Verifying the Oracle Business Intelligence Server Installation

  1. Check the installation wizard logs for error, exception, and fail:
    • root\temp\MM_Log.log

    • root\temp\MMInstaller.log

    • root\myMicros\Uninstall_myMicros\myMicros_Install_datetime.log

  2. Check the Oracle Business Intelligence log in root\Program Files\Oracle\Inventory\logs\ for error messages.
  3. Perform the following checks in the Oracle WebLogic console:
    1. In a web browser, navigate to OBI server hostname:7001/console and log in using the WebLogic administrator account credentials created during the installation.
    2. Click Environment from the menu, and then click Servers. Verify that you see AdminServer (admin) and Bi_server1 as Running.
    3. Click Deployments from the menu, click Customize this table, and then select Exclude libraries when displaying deployments. Verify that all components are set as Active except for the portal.
  4. Verify the following Microsoft Windows services are running:
    • beascv bifoundation_domain_AdminServer

    • beasvc bifoundation_domain_bi_server1

    • Oracle Process Manager (ORCLRNA)

    • Oracle WebLogic NodeManager(path to Oracle Middleware wlserver installation)

  5. Use opmnctl to verify that all components are set as Alive:
    1. In a command prompt, navigate to root\myMicros\Oracle\Middleware\instances\ORCLRNA\bin\
    2. Enter opmnctl status
    3. Verify that the components are set as Alive.

      Figure 3-2 Two-Server OBIEE opmnctl Status

      This image is a screenshot of the output of opmnctl status after installing the OBIEE server, with the five service components set to the Alive state.