Skip Headers
Oracle® Fusion Middleware Installation Guide for Oracle Business Intelligence
11g Release 1 (11.1.1)

Part Number E10539-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

5 Postinstallation Tasks

After completing the installation process, there may be one or more optional or required configuration-related tasks to perform. Such post installation tasks are covered in this section, including:

Some configuration and administration topics covered in other guides may be of interest. Table 5-1, "Topics Covered in Other Guides" lists these topics, and indicates where to go for more information.

Table 5-1 Topics Covered in Other Guides

Topic Where to Go for More Information

General configuration

Deployment


5.1 Installing and Deinstalling Oracle Business Intelligence Client Tools

Oracle Business Intelligence supports the following client tools on 32- and 64-bit Windows operating systems only:

This section provides information on installing and deinstalling the Oracle Business Intelligence client tools, and includes the following topics:

5.1.1 About Oracle Business Intelligence Client Tools

When you install Oracle Business Intelligence on a Windows operating system, the Oracle Business Intelligence 11g Installer automatically installs the Oracle Business Intelligence client tools. The bit-versions of the client tools that get installed depend on the bit-version on the Oracle Business Intelligence 11g Installer that you use. For example, the 32-bit version of the Oracle Business Intelligence 11g Installer installs 32-bit versions of the client tools; the 64-bit version of the Oracle Business Intelligence 11g Installer installs 64-bit versions of the client tools.

However, if you installed Oracle Business Intelligence on a computer running an AIX, Linux, or UNIX operating system, or if you installed Oracle Business Intelligence on a 32- or 64-bit Windows operating system but want to use the client tools on another computer, you must do one of the following:

  • Run the Oracle Business Intelligence Enterprise Edition Plus Client Installer. Select this option to install the Oracle Business Intelligence Administration Tool, Oracle Business Intelligence Job Manager, and Oracle Business Intelligence Catalog Manager (online mode).

  • Install another instance of Oracle Business Intelligence on a computer running a Windows operating system. Select this option to install the Oracle Business Intelligence Administration Tool, Oracle Business Intelligence Job Manager, and Oracle Business Intelligence Catalog Manager.

To continue, refer to the following topics:

For instructions on how to use the client tools, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

5.1.2 Considerations for Installing Oracle Business Intelligence Client Tools

Consider the following before installing the Oracle Business Intelligence client tools:

  • The Oracle Business Intelligence Enterprise Edition Plus Client Installer installs 32-bit versions of the Oracle Business Intelligence Administration Tool, Oracle Business Intelligence Job Manager, and Oracle Business Intelligence Catalog Manager. These client tools are supported on 32- and 64-bit Windows operating systems only.

    Note:

    Oracle Business Intelligence Enterprise Edition Plus Client installer does not install the Oracle Database Client. To access the Oracle database you must separately install the Database Client on the same machine. Similiarly, to access the IBM DB2 database, you must install the IBM DB2 CLI on the same machine. For more information, see "Importing Metadata and Working With Data Sources" in Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.

  • The Administration Tool requires its own system DSN for connecting to your Oracle Business Intelligence system. You create and configure the system DSN after you install the Oracle Business Intelligence client tools. Your Oracle Business Intelligence system administrator should supply the details required to create the system DSN. For the instructions on configuring a separate ODBC DSN, see "Configuring an ODBC DSN for the Oracle BI Server on Windows" in Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition.

  • Oracle Business Intelligence supports multiple instances of the Oracle Business Intelligence client tools on the same computer. That is, if your organization has installed multiple instances of Oracle Business Intelligence, you can install and configure the Oracle Business Intelligence client tools multiple times, or once for each instance of Oracle Business Intelligence. However, do not install the client tools on the same computers that host your Oracle Business Intelligence server instances, as the client tools are already installed on those computers (as part of the Oracle Business Intelligence installation).

5.1.3 Installing and Deinstalling Oracle Business Intelligence Client Tools with the Oracle Business Intelligence Enterprise Edition Plus Client Installer

This section describes how to install and deinstall the Oracle Business Intelligence clients using the Oracle Business Intelligence Enterprise Edition Plus Client Installer, and includes the following topics:

5.1.3.1 Prerequisites for Running the Oracle Business Intelligence Enterprise Edition Plus Client Installer

Before running the Oracle Business Intelligence Enterprise Edition Plus Client Installer, do all of the following:

  • Identify a computer running a supported 32-bit or 64-bit Windows operating system where you will install the Oracle Business Intelligence client tools.

  • Verify that the computer where you want to install the Oracle Business Intelligence client tools can access the Linux, UNIX, or Windows computer (32-bit or 64-bit) that hosts your Oracle Business Intelligence system.

  • Contact your system administrator to obtain the information necessary to create the system DSN for the Administration Tool.

  • Obtain the Oracle Business Intelligence Enterprise Edition Plus Client Installer file (biee_client_install.exe) using one of the following methods:

    • Access the Oracle Business Intelligence Enterprise Edition Plus Client Installer file from the Oracle BI home page by selecting the Download BI Desktop Tools link and choosing Oracle BI Client Installer. You can display the Oracle BI home page from the following URL:

      http://<host>:<port>/analytics/saw.dll?bieehome

      For example:

      http://computer1:9704/analytics/saw.dll?bieehome

    • Access biee_client_install.exe in your Oracle home and transfer a copy of it to the computer where you want to install the client tools. You can find biee_client_install.exe in the following location:

      ORACLE_HOME/clients/biserver

    • Access the Oracle Business Intelligence Enterprise Edition Plus Client Installer file on OTN and download it to the computer where you want to install the client tools. You can find the Oracle Business Intelligence Enterprise Edition Plus Client Installer file on OTN at the following link:

      http://www.oracle.com/technology/software/products/middleware/htdocs/111110_fmw.html

5.1.3.2 Running the Oracle Business Intelligence Enterprise Edition Plus Client Installer

To install Oracle Business Intelligence client tools with the Oracle Business Intelligence Enterprise Edition Plus Client Installer:

  1. Ensure that you have satisfied the prerequisites described in Section 5.1.3.1, "Prerequisites for Running the Oracle Business Intelligence Enterprise Edition Plus Client Installer."

  2. Start the Oracle Business Intelligence Enterprise Edition Plus Client Installer by accessing and double-clicking biee_client_install.exe. The installer launches and the Introduction screen opens.

    Note:

    If you installed the Oracle Business Intelligence client tools on the current computer, the Manage Instances window opens instead. Click Install a New Instance, and then click OK to open the Introduction screen.

    Click Next. The Choose Install Folder window opens.

  3. In the Choose Install Folder window, you can accept the default install location or specify another one. To specify another location, either enter the location in the text box or click Choose... and navigate to the location. To restore the path in the text box to the default location, click Restore Default Folder.

    To continue, click Next. The Choose Shortcut Folder window opens.

  4. In the Choose Shortcut Folder window, you can specify where you want the installer to create product icons for the Oracle Business Intelligence client tools. Select the appropriate option.

    To continue, click Next. The Pre-Installation Summary window opens.

  5. In the Pre-Installation Summary window, confirm your installation settings. To change a setting, click Previous and return to the screen that contains the setting you want to change.

    To begin the installation, click Install.

  6. When the installation concludes, click Done. The ODBC Data Source Administrator dialog opens.

  7. In the ODBC Data Source Administrator dialog window, configure a system DSN for the Administration Tool to connect to your Oracle Business Intelligence system. For the instructions on configuring a separate ODBC DSN, see "Configuring an ODBC DSN for the Oracle BI Server on Windows" in Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition.

For instructions on how to use the client tools after you install them, see:

5.1.3.3 Deinstalling Oracle Business Intelligence Client Tools

To deinstall the Oracle Business Intelligence client tools:

  1. Do one of the following:

    • If you chose to create product icons when you installed the Oracle Business Intelligence client, click Change Oracle Business Intelligence Enterprise Edition Plus Client Installation in the location where you created the icons (such as on your desktop or in the Oracle Business Intelligence Enterprise Edition Plus Client program group of the Programs menu).

    • If you chose not to create product icons when you installed the Oracle Business Intelligence clients, access the directory where you installed the Oracle Business Intelligence clients. In the install directory, open the _Oracle Business Intelligence Enterprise Edition Plus Client_installation folder and double-click the file Change Oracle Business Intelligence Enterprise Edition Plus Client Installation.exe.

    The Maintenance Mode window opens.

  2. In the Maintenance Mode window, click Uninstall Product, and then click Next. The Confirm Uninstall window opens.

  3. In the Confirm Uninstall window, click Next to deinstall the Oracle Business Intelligence client tools.

  4. When the deinstall process concludes, click Done.

  5. To deinstall other installations of the Oracle Business Intelligence client tools, repeat steps 1 through 4 for each installation.

5.1.4 Installing Oracle Business Intelligence Client Tools with the Oracle Business Intelligence 11g Installer

To install the Oracle Business Intelligence client tools using the Oracle Business Intelligence 11g Installer:

  1. Create a new set of BIPLATFORM and MDS schemas in your database using the RCU (see Section 3.3.6, "Running the RCU to Create Oracle Business Intelligence Database Schemas"). This set of schemas will be used by a new Oracle Business Intelligence instance for the client tools. You will install this new instance in step 3.

  2. Identify a computer running a 32-bit or 64-bit Windows operating system to host the new instance for the client tools. Verify that the Windows computer you identify can access the computer that is hosting your active Oracle Business Intelligence system.

  3. Install the new Oracle Business Intelligence instance on a computer running a 32-bit or 64-bit Windows operating system. For this, you can use the Simple Install type (see Section 4.5.1, "Simple Install").

  4. After installing the new Oracle Business Intelligence instance, shut down all of its services, including OPMN and Node Manager. See Chapter 4, "Starting and Stopping Oracle Business Intelligence" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

  5. On the computer hosting the client tools, configure a separate DSN for the Administration Tool to connect to your active Oracle Business Intelligence system. Do not use the default, centrally managed DSN to connect to your active system. For the instructions on configuring a separate ODBC DSN, see "Configuring an ODBC DSN for the Oracle BI Server on Windows" in Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition.

  6. To deinstall the client tools, follow the procedure for deinstalling Oracle Business Intelligence. See Chapter 6, "Deinstalling Oracle Business Intelligence."

5.2 Configuring Oracle Business Intelligence with the Configuration Assistant

With the Oracle Business Intelligence Configuration Assistant, you configure Oracle Business Intelligence software that was installed through the Software Only Install type. The Oracle Business Intelligence Configuration Assistant enables you to do the following:

Note:

If you used the Software Only Install type to install Oracle Business Intelligence into an existing Middleware home of another Oracle Fusion Middleware product, you can follow the procedures for any of the configuration scenarios described above (assuming your installation meets the prerequisites for those scenarios).

This section contains the following topics:

5.2.1 Considerations and Limitations for Configuring Oracle Business Intelligence with the Configuration Assistant

The following considerations and limitations apply when configuring Oracle Business Intelligence with the Configuration Assistant:

  • Do not run the Oracle Business Intelligence Configuration Assistant to scale your installation vertically. For vertical scaling, see Chapter 5 "Scaling Your Deployment" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

  • The Configuration Assistant is not supported on Oracle Business Intelligence installations that were installed with the Simple Install type.

  • You cannot extend a domain using the Oracle Fusion Middleware Configuration Wizard, which is found in ORACLE_HOME/common/bin. Specifically, you cannot use the Configuration Wizard to add more Oracle Business Intelligence components to an existing Business Intelligence or Oracle WebLogic Server domain, or to the domain of any other Oracle Fusion Middleware product.

5.2.2 Starting the Oracle Business Intelligence Configuration Assistant

Start the Oracle Business Intelligence Configuration Assistant from the bin directory in the ORACLE_HOME (default folder name is Oracle_BI1), based on your operating system:

UNIX commands:

cd ORACLE_HOME/bin

./config.sh

Windows commands:

cd ORACLE_HOME\bin

config.exe

5.2.3 Configuring a New Enterprise Installation of Oracle Business Intelligence

Note:

If you used the Software Only Install type to install Oracle Business Intelligence into an existing Middleware home of another Oracle Fusion Middleware product, you can follow the procedure described in this section to complete the configuration of your installation (assuming your installation meets the prerequisites for this configuration scenario).

To configure a new enterprise installation of Oracle Business Intelligence using the Configuration Assistant:

  1. Start the Oracle Business Intelligence Configuration Assistant. See Section 5.2.2, "Starting the Oracle Business Intelligence Configuration Assistant."

  2. On the Welcome screen, click Next.

  3. On the Prerequisite Checks screen, after the prerequisite checks conclude with no errors, click Next.

    If an error message appears, fix the error and then click Retry to run the prerequisite check again (recommended). Repeat this until all prerequisite checks conclude with no errors.

    To stop the configuration process while you fix a prerequisite error, click Abort.

    To ignore an error or warning message, and continue with the configuration process, click Continue (not recommended).

    Note:

    Your installation might not function normally if you continue without resolving the issue that caused an error or warning message during the prerequisite checks.

  4. On the Create, Scale Out, or Extend BI System screen, click Create New BI System, and then enter the following information:

    • The user name and password for the system administrator for the new Oracle Business Intelligence system

    • The domain name for the new Oracle Business Intelligence system

    Click Next.

  5. The Specify Installation Location (Enterprise) screen displays the current Middleware home and other key locations for the new installation.

    Optionally, change the following settings:

    • Domain Home Location

    • Oracle Instance Location

    • Oracle Instance Name

    Click Next.

  6. On the Configure Components screen, all products are selected by default. Click the box next to each component that you do not want to configure.

    Select all the products that you want or might want to configure. You cannot configure some products now and then configure others later in the current domain.

    Note:

    If you choose to configure Oracle Business Intelligence Enterprise Edition, Oracle Business Intelligence Publisher is configured automatically.

    After you make your selections, click Next.

  7. On the BIPLATFORM Schema screen, specify the following:

    After you specify the database settings, click Next.

  8. On the MDS Schema screen, specify the following:

    After you specify the database settings, click Next.

  9. On the Configure Ports screen, click Auto Port Configuration or Specify Ports Using Configuration File.

    If you select the latter option, you must specify a configuration file that contains the custom port values for your Oracle Business Intelligence installation. Click Browse to navigate to the file and click View/Edit to view and edit it. If you edit the file, click Save to save your changes.

    Note:

    The Oracle Business Intelligence Configuration Assistant automatically assigns the Node Manager port (default is 9556), unless you specify your Oracle Business Intelligence ports manually using a configuration file such as staticports.ini (see Section 4.2.8, "Setting Custom Port Values for Oracle Business Intelligence"). However, if configuring Oracle Business Intelligence in a shared Middleware home where Node Manager is installed, the Oracle Business Intelligence Configuration Assistant uses the existing Node Manager and its port number.

    Click Next.

  10. On the Security Updates screen, enter your My Oracle Support account information, and then click Next.

  11. On the Summary screen, click Save to save the settings for this configuration in a response file (optional), and then click Configure to start the configuration process.

  12. On the Configuration Progress screen, you can monitor the progress of your software configuration and respond to errors, if any occur.

    If a configuration task fails, an error message appears. To retry the task, click Retry. To continue with the next task, click Continue (not recommended). To stop the installation and configuration process entirely, click Abort.

    For more information, see Section 4.7, "Troubleshooting the Installation and Configuration Processes."

    Note:

    Your installation might not function normally if you choose to continue the configuration process without resolving the issue that caused an error or warning message. Oracle recommends that you attempt to resolve any issues before continuing or restarting the configuration process. See Section 4.7, "Troubleshooting the Installation and Configuration Processes."

    After the configuration concludes without any errors, click Next.

  13. On the Complete screen, click Save to save the settings for this installation in a response file (optional), and then click Finish to exit the Oracle Business Intelligence Configuration Assistant.

5.2.4 Configuring a Scaled-Out Enterprise Installation of Oracle Business Intelligence

Note:

If you used the Software Only Install type to install Oracle Business Intelligence into an existing Middleware home of another Oracle Fusion Middleware product, you can follow the procedure described in this section to complete the configuration of your installation (assuming your installation meets the prerequisites for this configuration scenario).

To configure a scaled-out enterprise installation of Oracle Business Intelligence using the Configuration Assistant:

  1. Start the Oracle Business Intelligence Configuration Assistant. See Section 5.2.2, "Starting the Oracle Business Intelligence Configuration Assistant."

  2. On the Welcome screen, click Next.

  3. On the Prerequisite Checks screen, after the prerequisite checks conclude with no errors, click Next.

    If an error message appears, fix the error and then click Retry to run the prerequisite check again (recommended). Repeat this until all prerequisite checks conclude with no errors.

    To stop the configuration process while you fix a prerequisite error, click Abort.

    To ignore an error or warning message, and continue with the configuration process, click Continue (not recommended).

    Note:

    Your installation might not function normally if you continue without resolving the issue that caused an error or warning message during the prerequisite checks.

  4. In the Create, Scale Out, or Extend BI System screen, click Scale Out BI System, and then enter the following information:

    • The host name and port number for the Administration Server domain

    • The user name and password for logging in to the WebLogic Administration Server.

    Click Next.

  5. On the Scale Out BI System Details screen, optionally change the following settings:

    • Oracle Instance Location

    • Oracle Instance Name

    Click Next.

  6. On the Configure Ports screen, click Auto Port Configuration or Specify Ports Using Configuration File.

    If you select the latter option, you must specify a configuration file that contains the custom port values for your Oracle Business Intelligence installation. Click Browse to navigate to the file and click View/Edit to view and edit it. If you edit the file, click Save to save your changes.

    Note:

    The Oracle Business Intelligence Configuration Assistant automatically assigns the Node Manager port (default is 9556), unless you specify your Oracle Business Intelligence ports manually using a configuration file such as staticports.ini (see Section 4.2.8, "Setting Custom Port Values for Oracle Business Intelligence"). However, if configuring Oracle Business Intelligence in a shared Middleware home where Node Manager is installed, the Oracle Business Intelligence script uses the existing Node Manager and its port number.

    Click Next.

  7. On the Security Updates screen, enter your My Oracle Support account information, and then click Next.

  8. On the Summary screen, click Save to save the settings for this configuration in a response file, and then click Configure to start the configuration process.

  9. On the Configuration Progress screen, you can monitor the progress of your software configuration and respond to errors, if any occur.

    If a configuration task fails, an error message appears. To retry the task, click Retry. To continue with the next task, click Continue (not recommended). To stop the installation and configuration process entirely, click Abort.

    For more information, see Section 4.7, "Troubleshooting the Installation and Configuration Processes."

    Note:

    Your installation might not function normally if you choose to continue the configuration process without resolving the issue that caused an error or warning message. Oracle recommends that you attempt to resolve any issues before continuing or restarting the configuration process. See Section 4.7, "Troubleshooting the Installation and Configuration Processes."

    After the configuration concludes without any errors, click Next.

  10. On the Complete screen, click Save to save the settings for this configuration in a response file (optional), and then click Finish to exit the Oracle Business Intelligence Configuration Assistant.

5.2.5 Extending an Oracle WebLogic Server Domain with Oracle Business Intelligence

Note:

If you used the Software Only Install type to install Oracle Business Intelligence into an existing Middleware home of another Oracle Fusion Middleware product, you can follow the procedure described in this section to complete the configuration of your installation (assuming your installation meets the prerequisites for this configuration scenario).

You can use the Oracle Business Intelligence Configuration Assistant to configure an instance of Oracle Business Intelligence that was previously installed into an existing Middleware home of an Oracle WebLogic Server domain. This is referred to as extending the domain.

Before you use the Oracle Business Intelligence Configuration Assistant to extend an existing Oracle WebLogic Server domain, ensure the following:

  • Oracle WebLogic Server was previously installed and the associated domain was created using the WebLogic Server Configuration Wizard. For more information, see Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server.

  • Oracle Business Intelligence was previously installed into an existing Middleware home using the Software Only Install type. For more information, see Section 4.5.4, "Software Only Install."

  • The domain exists on the same computer where you installed Oracle Business Intelligence. Extending domains remotely is not supported.

  • The domain is empty.

  • The domain is running.

  • The Administration Server for the domain is named AdminServer. Other names for the Administration Server are not supported.

To extend an Oracle WebLogic Server domain with Oracle Business Intelligence using the Configuration Assistant:

  1. Start the Oracle Business Intelligence Configuration Assistant. See Section 5.2.2, "Starting the Oracle Business Intelligence Configuration Assistant."

  2. On the Welcome screen, click Next.

  3. On the Prerequisite Checks screen, after the prerequisite checks conclude with no errors, click Next.

    If an error message appears, fix the error and then click Retry to run the prerequisite check again (recommended). Repeat this until all prerequisite checks conclude with no errors.

    To stop the configuration process while you fix a prerequisite error, click Abort.

    To ignore an error or warning message, and continue with the configuration process, click Continue (not recommended).

    Note:

    Your installation might not function normally if you continue without resolving the issue that caused an error or warning message during the prerequisite checks.

  4. On the Create, Scale Out, or Extend BI System screen, click Extend BI System, and then enter the following information:

    • The host name and port number for the existing WebLogic Server domain

    • The user name and password for the administrator account that was created when Oracle WebLogic Server was installed and configured

    Click Next.

  5. The Specify Installation Location (Enterprise) screen displays the current Middleware home and other key locations for the new installation.

    Optionally, change the following settings:

    • Domain Home Location

    • Oracle Instance Location

    • Oracle Instance Name

    Click Next.

  6. On the Configure Components screen, all products are selected by default. Click the box next to each component that you do not want to configure.

    Select all the products that you want or might want to configure. You cannot configure some products now and then configure others later in the current domain.

    Note:

    If you choose to configure Oracle Business Intelligence Enterprise Edition, Oracle Business Intelligence Publisher is configured automatically.

    After you make your selections, click Next.

  7. On the BIPLATFORM Schema screen, specify the following:

    • The type of database for your Oracle Business Intelligence system.

    • The connect string for your database. See Section 4.2.9, "Specifying a Database Connect String."

    • The user name for the Business Intelligence Platform schema.

    • The password for the Business Intelligence Platform schema.

    After you specify the database settings, click Next.

  8. On the MDS Schema screen, specify the following:

    After you specify the database settings, click Next.

  9. On the Configure Ports screen, click Auto Port Configuration or Specify Ports Using Configuration File.

    If you select the latter option, you must specify a configuration file that contains the custom port values for your Oracle Business Intelligence installation. Click Browse to navigate to the file and click View/Edit to view and edit it. If you edit the file, click Save to save your changes.

    Note:

    The Configuration Assistant refers to the Domain and Node Manager ports for the existing WebLogic Server domain, and ignores any Domain and Node Manager port values specified in a custom configuration file, such as staticports.ini (see Section 4.2.8, "Setting Custom Port Values for Oracle Business Intelligence").

    Click Next.

  10. On the Security Updates screen, enter your My Oracle Support account information, and then click Next.

  11. On the Summary screen, click Save to save the settings for this configuration in a response file (optional), and then click Configure to start the configuration process.

  12. On the Configuration Progress screen, you can monitor the progress of your software configuration and respond to errors, if any occur.

    If a configuration task fails, an error message appears. To retry the task, click Retry. To continue with the next task, click Continue (not recommended). To stop the installation and configuration process entirely, click Abort.

    For more information, see Section 4.7, "Troubleshooting the Installation and Configuration Processes."

    Note:

    Your installation might not function normally if you choose to continue the configuration process without resolving the issue that caused an error or warning message. Oracle recommends that you attempt to resolve any issues before continuing or restarting the configuration process. See Section 4.7, "Troubleshooting the Installation and Configuration Processes."

    After the configuration concludes without any errors, click Next.

  13. On the Complete screen, click Save to save the settings for this installation in a response file (optional), and then click Finish to exit the Oracle Business Intelligence Configuration Assistant.

5.3 Installing and Configuring BI Composer for Oracle BI EE

To install and configure BI Composer for an Oracle Business Intelligence installation you must first apply the Oracle Business Intelligence Release 11.1.1.6.2 patch to the Oracle Business Intelligence Release 11.1.1.6.0 installation and then run a script. The script extends the Oracle WebLogic Server domain to include the BI Composer application and the BI Composer run-time implementation shared libraries on the installed computer and on any scaled-out computers.

Note:

If you have previously installed and configured BI Composer and subsequently applied the 11.1.1.6.2 patch, then you must run the same script to re-configure BI Composer.

For more information, see "Applying the Latest Oracle Fusion Middleware Patch Set" in Oracle Fusion Middleware Patching Guide.

To install and configure BI Composer for Oracle BI EE:

  1. Ensure that the Administration Server, Managed Server, and OPMN components are running.

    For more information, see "Starting and Stopping the Administration Server and All Oracle Business Intelligence Java Components on Windows and UNIX" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition

  2. You install BI Composer by performing the following steps:

    • On UNIX:

      1. Open a shell prompt and change the directory to MW_HOME/wlserver_10.3/common/bin

      2. At the prompt, run the following command:

        ./wlst.sh ORACLE_HOME/bicomposer/install/configureComposer.py DOMAIN_HOME <administration_server_home> <Port_Number> <Admin_User_Name>
        

        For example:

        ./wlst.sh mw_home/BI1/bicomposer/install/configureComposer.py mw_home/user_projects/bifoundation mycomputer 7001 jdoe

      3. When prompted, enter the password for the administration user.

    • On Windows:

      1. Open a command prompt and change the directory to MW_HOME\wlserver_10.3\common\bin.

      2. At the prompt, run the following command:

        run wlst.cmd ORACLE_HOME\bicomposer\install\configureComposer.py DOMAIN_HOME <administration_server_host_name> <Port_Number> <Admin_User_Name>
        

        For example:

        run wlst.cmd mw_home\BI1\bicomposer\install\configureComposer.py mw_home\user_projects\bifoundation mycomputer 7001 jdoe

      3. When prompted, enter the password for the administration user.

  3. Start the Administration Server.

    You need to start the Administration Server, because the script stops it.

    For more information, see "Starting and Stopping the Administration Server and All Oracle Business Intelligence Java Components on Windows and UNIX" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition

  4. Stop the Managed WebLogic Server.

    Note:

    The system does not include a Managed WebLogic Server if Simple Install type was selected during installation.

    To stop the Managed WebLogic Server, perform the following steps:

    • On UNIX:

      1. Open a shell prompt and change the directory to MW_HOME/user_projects/domains/bifoundation_domain/bin.

      2. At the prompt, run the following command (which requires the administrator user name and password), for example:

      ./stopManagedWebLogic.sh bi_server1 http://<administration_server_host_name>:7001
      
    • On Windows:

      1. Open an MS_DOS window and change the directory to MW_HOME\user_projects\domains\bifoundation_domain\bin.

      2. At the prompt, run the following command (which requires the administrator user name and password), for example:

      stopManagedWebLogic.cmd bi_server1 http://<administration_server_host_name>:7001
      
  5. Start the Managed WebLogic Server.

    To start the Managed WebLogic Server, perform the following steps:

    • On UNIX:

      1. Open a shell prompt and change the directory to MW_HOME/user_projects/domains/bifoundation_domain/bin.

      2. At the prompt, run the following command (which requires the administrator user name and password), for example:

      ./startManagedWebLogic.sh bi_server1 http://<administration_server_host_name>:7001
      
    • On Windows:

      1. Open an MS_DOS window and change the directory to MW_HOME\user_projects\domains\bifoundation_domain\bin.

      2. At the prompt, run the following command (which requires the administrator user name and password), for example:

      startManagedWebLogic.cmd bi_server1 http://<administration_server_host_name>:7001
      
  6. Stop the Oracle Process Manager and Notification Server (OPMN).

    1. Go to the following directory that contains the OPMN command-line tool:

      ORACLE_INSTANCE/bin

    2. Run the following command:

      ./opmnctl stopall

      Stops OPMN and all Oracle Business Intelligence system components.

      For more information, see "Using the OPMN Command Line to Start, Stop, Restart, and View the Status of System Components" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition

  7. Start the Oracle Process Manager and Notification Server (OPMN).

    1. Go to the following directory that contains the OPMN command-line tool:

      ORACLE_INSTANCE/bin

    2. Run the following command:

      ./opmnctl startall

      Starts OPMN and all Oracle Business Intelligence system components.

      For more information, see "Using the OPMN Command Line to Start, Stop, Restart, and View the Status of System Components" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

  8. (Optional) Display the Oracle WebLogic Server Administration Console.

  9. (Optional) In the left pane, click Deployments.

    You perform the above step to confirm a successful configuration.

    If the configuration is successful the BI Composer application and shared libraries are displayed as follows:

    • bicomposer (11.1.1)

    • oracle.bi.composer (11.1.1,11.1.1)

    • oracle.bi.jbips (11.1.1,11.1.1)

    Note that the stub libraries oracle.bi.composer (11.1.1, 0.1) and oracle.bi.jbips (11.1.1, 0.1) will always be present, but must not be confused with the deployed libraries shown above.

    BI Composer is now available in Oracle Business Intelligence. For more information, see "Availability of BI Composer in Oracle BI Enterprise Edition" in Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition.

5.4 Creating a DSN for IBM DB2 or Microsoft SQL Server

If you installed the Oracle Business Intelligence schemas using the RCU on an IBM DB2 or Microsoft SQL Server database, and you have scaled out your system on multiple hosts, you must create an ODBC data source name (DSN) on each node where you scaled out Oracle Business Intelligence. You create each ODBC DSN by using the same data source details of the ODBC DSN used by the BI Scheduler on the primary node of the cluster. The steps that you perform depend on the operating systems of the computers where you scaled out Oracle Business Intelligence.

To create an ODBC DSN on the scaled-out nodes of an Oracle Business Intelligence cluster:

  1. Log in to Fusion Middleware Control.

  2. Open the Scheduler tab of the Deployment page to identify the IBM DB2 or Microsoft SQL Server data source of the primary node of the cluster.

  3. Close Fusion Middleware Control.

  4. Access the primary node of your Oracle Business Intelligence cluster and identify the data source details, as follows:

    • UNIX:

      The data source details are available in odbc.ini. Open odbc.ini from the following location:

      ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/

    • Windows:

      The data source details are available in the ODBC Data Source Administrator window. To access this window, click Start, select Settings, and click Control Panel.

      In Control Panel, double-click Administrative Tools. In the Administrative Tools window, double-click Data Sources (ODBC).

      In the ODBC Data Source Administrator window, click the System DSN tab, select the SQL Server or DB2 data source of the primary node of the cluster, and then click Configure.

  5. Make a note of the driver types and the data source details. The BI Scheduler uses ODBC data sources, which appear in the following formats, depending on your database type:

    • IBM DB2:

      instancename_DB2

    • Microsoft SQL Server:

      instancename_MSSS

  6. Close odbc.ini or the ODBC Data Source Administrator window, depending on your operating system.

  7. On each scaled-out node, do the following depending on your operating system:

    • UNIX:

      Open odbc.ini from the following location:

      ORACLE_INSTANCE/bifoundation/OracleBIApplication/ coreapplication/setup/

      Update odbc.ini with the same data source details as those of the primary node. Save your changes and close odbc.ini.

    • Windows:

      Click Start, select Settings, and click Control Panel. In Control Panel, double-click Administrative Tools, and then double-click Data Sources (ODBC).

      In the ODBC Data Source Administrator window, click the System DSN tab, and then click Add. In the Create New Data Source window, select the driver type and click Finish.

      Then, follow the steps in the wizard to enter the data source details of the primary node.

5.5 Configuring IBM DB2 to Support Multibyte Data

When Oracle Business Intelligence is installed with an IBM DB2 database, the Oracle Business Intelligence installer configures an ODBC 2.0 driver, which can result in issues with multibyte data. To avoid these issues, use Oracle Fusion Middleware Control to configure Oracle Business Intelligence to use the native DB2 CLI driver instead.

To configure Oracle Business Intelligence to use DB2 CLI driver with IBM DB2:

  1. Install the IBM DB2 client software on the computers where Oracle Business Intelligence resides, and create a data source for your scheduler database.

  2. After installing Oracle Business Intelligence, log in to Fusion Middleware Control.

  3. Expand the Business Intelligence folder and select the coreapplication node.

  4. Go to the Scheduler tab.

    Click the Help button on the page to access the page-level help for its elements.

  5. Click Lock and Edit Configuration.

  6. Click the Call Interface drop-down list and select DB2 CLI - Unicode.

  7. In the Data Source field, enter your data source name.

  8. Click Apply, and then click Activate Changes.

5.6 Managing the OPMN Service on Windows Operating Systems

After installation, the OPMN Service appears as stopped in the Services list on Windows operating systems, as Oracle Business Intelligence 11g Installer starts OPMN directly. You can manage OPMN by running opmnctl.bat, which is located in the following directory:

ORACLE_INSTANCE\bin

The OPMN Services is set to manual, therefore, you must manually restart it if you restart your system.

5.7 Configuring Sample Reports for BI Publisher

Oracle Business Intelligence provides several sample reports that you can access through BI Publisher. Some reports depend on data models that source data from the OE sample schema provided by Oracle Database. For these reports to run correctly, unlock the OE sample schema and configure the "demo" JDBC connection on the BI Publisher Administration page as described in the following procedure.

To configure the sample reports for BI Publisher:

  1. Unlock the OE sample schema and obtain the connection string for it. For more information, see Oracle Database Sample Schemas.

  2. In a supported Web browser, open the BI Publisher Admin page for the JDBC Data Source Connections.

  3. In the demo JDBC Data Source connection details, specify and save the connection string for the OE sample schema.

    For example:

    Connection String: jdbc:oracle:thin:@foobar.com.example:1521:orcl

    Username: OE

    Password: oe password

Note:

If you do not have access to an OE schema or privileges to update the demo JDBC Data Source, some sample reports are very likely to fail with errors of the following form:

Error:

The report cannot be rendered because of an error, please contact the administrator.

Error Detail Parameter name:

param Invalid number format for port number

5.8 Changing the Default Password for SampleAppLite.rpd

When you install Oracle Business Intelligence, the Oracle Business Intelligence installer automatically installs the SampleAppLite.rpd file with a default repository password of Admin123. If you intend to use the SampleAppLite.rpd file in a production system, Oracle recommends that you change the repository password for security reasons. For more information, see "Changing the Repository Password" in Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.

You can download the Sample Application (full version) from the following location on OTN:

http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

5.9 Changing Administration Server or Managed Server Port Numbers on Windows Operating Systems

If you change the Administration Server or Managed Server port numbers after you finish installing Oracle Business Intelligence on a Windows operating system, you must also update their values in the StartStopServices.cmd file.

To change port number settings in StartStopServices.cmd file after making post installation Administration Server or Managed Server port number changes on Windows operating systems:

  1. Open the StartStopServices.cmd file for editing, from the following directory:

    INSTANCE\bifoundation\OracleBIApplication\coreapplication

  2. Update the port values for the Administration Server and Managed Server as required, for example:

    set wls.admin.port=7002

    set wls.mgd.port=9705

    The above example from the StartStopServices.cmd file, shows the updated values you would need to enter if you had changed the Administration Server and Managed Server ports to 7002 and 9705 respectively.

  3. Save the StartStopServices.cmd file.