3 Configuring the Oracle Business Intelligence System

This chapter describes how to configure the Oracle Business Intelligence system using Fusion Middleware Control and manually. This chapter provides information about the location of configuration files.

This chapter includes the following sections:

3.1 Configuring Oracle Business Intelligence

Oracle recommends using Fusion Middleware Control to configure Oracle Business Intelligence. However, if configuration settings cannot be changed using this method, then you can use the Oracle BI Systems Management API or the Fusion Middleware Control MBean Browser. You can also manually edit configuration files if you take the appropriate precautions.

Table 3-1 describes the methods that you can use for configuring Oracle Business Intelligence. All the methods result in changes being made in one or more configuration files.

Table 3-1 Methods for Configuring Oracle Business Intelligence

What to you want to do? What tools can you use? How are updates made?

Centrally manage configuration settings

Automatically, through Oracle BI Systems Management API methods.

For information, see Chapter 23, "Introducing the Oracle BI Systems Management API."

Programmatically change configuration settings

  • WLST (WebLogic Scripting Tool)

  • Java Program

For information, see Section 3.3, "Using the Oracle BI Systems Management API to Update Configuration Settings."

Using scripts or programs to programmatically access Oracle BI Systems Management API methods.

Manually change configuration settings

Caution: Settings managed by Fusion Middleware Control are commented as such in configuration files. You must not be manually update these settings.

You must make changes correctly in configuration files in all nodes in a cluster to avoid damage to the system.

Manually, using a text editor to enter changes in configuration files.


3.2 Using Fusion Middleware Control to Update Oracle Business Intelligence Configuration Settings

Using Fusion Middleware Control to update Oracle Business Intelligence configuration settings is the recommended method, because it manages the distribution of changes across the system, and across all computers if the system is clustered.

To update Oracle Business Intelligence configuration settings using Fusion Middleware Control:

  1. Go to the Business Intelligence Overview page, as described in Section 2.2.3, "Using Fusion Middleware Control to Manage Oracle Business Intelligence System Components."

  2. Select the appropriate page and tabs to display the settings to change.

  3. Click Lock and Edit Configuration to enable changes to be made.

    Note:

    Oracle recommends that multiple administrators do not share the same administrator account. They can unknowingly make concurrent updates to the same configuration settings.

  4. Make the appropriate changes on each page.

  5. Click Apply on each page after you have made your changes.

  6. When you have finished making your changes, do one of the following:

    • Click Activate Changes to execute your changes and release the lock to enable another system administrator to make changes.

    • Click Release Configuration to undo all changes you made since clicking Lock and Edit Configuration and release the lock to enable another system administrator to make changes.

  7. After you have activated your changes, go to the Overview page and click Restart.

3.3 Using the Oracle BI Systems Management API to Update Configuration Settings

You can use the Oracle BI Systems Management API to update Oracle Business Intelligence configuration settings that are normally managed by Fusion Middleware Control. For information, see Section 23.3.3, "Updating Configuration Settings Using the Oracle BI Systems Management API."

3.4 Using a Text Editor to Update Configuration Settings

You can manually update configuration settings that are not normally managed by Fusion Middleware Control using a text editor.

Caution:

If you manually update configuration settings that are not normally managed by Fusion Middleware Control, then you must likely make identical changes in multiple copies of configuration files on multiple computers. If you fail to make changes in all of the necessary configuration files, then the system might be damaged.

You can use a text editor to manually update Oracle Business Intelligence configuration settings that are not normally managed by Fusion Middleware Control, as described in the following procedure.

To manually update Oracle Business Intelligence configuration settings that are not normally managed by Fusion Middleware Control:

  1. Make a backup copy of the files that you plan to edit.

  2. Open the configuration file in a text editor.

    Note:

    If Oracle Business Intelligence is installed on multiple computers or in multiple locations, then a copy of the configuration file exists for each installation, and each file contains duplicate settings. Therefore, you must locate and make the same changes in each copy of a configuration file.

    For information, see Section 3.6, "Where Are Configuration Files Located?"

  3. In each configuration file to change, locate the element or create the new element if you must add a setting to the file.

  4. Enter the appropriate changes.

  5. Save your changes and close the configuration file.

  6. Restart Oracle Business Intelligence.

    For information, see Section 4.1, "About Starting and Stopping Oracle Business Intelligence."

It is possible to manually update configuration settings that are normally managed by Fusion Middleware Control. However, never attempt such updates unless you are specifically instructed to do so by Oracle Support Services. For information, see Appendix D, "Manually Updating Fusion Middleware Control Settings."

3.5 Using the Fusion Middleware Control MBean Browser to Update Configuration Settings

Use Fusion Middleware Control to update configuration settings, unless specifically directed to use the MBean Browser. For information, see Section 3.2, "Using Fusion Middleware Control to Update Oracle Business Intelligence Configuration Settings."

To update configuration settings using the Fusion Middleware Control MBean Browser:

  1. Display the Fusion Middleware Control MBean Browser.

    For information, see Section 2.4.2, "Displaying the Fusion Middleware Control MBean Browser."

  2. Lock the domain.

    Before you change any Oracle Business Intelligence-related configuration attribute settings using the Fusion Middleware Control MBean Browser, you must lock the domain as follows:

    1. Navigate to the following MBean (the first BIDomain MBean): oracle.biee.admin, Domain:bifoundation_domain, BIDomain, BIDomain.

    2. Display the Operations tab.

    3. Click the Lock operation link.

      When you have locked the domain, you can start to update settings.

  3. Expand a folder to display the details for a group of configuration file attributes.

    For example, to configure Oracle Business Intelligence email settings, expand the BIDomain.BIInstance.EmailConfiguration folder, and select the underlying node of the same name.

    To configure a different group of Oracle Business Intelligence configuration settings, expand the required folder, and select it's underlying node.

  4. Create or update a value in the following ways:

    • Entering directly into a field in the Attributes tab:

      • Enter a new value into the Value field for the appropriate row.

      • Click Apply to save the changes, or Revert to undo the changes.

    • Entering into a new page that you display from the Attributes tab:

      • Click the link in the Name column to display a new page.

      • Enter a new value in the Value field.

      • Click Apply to save the changes, or Revert to undo the changes.

      • Click Return to close the page.

  5. Click Revert to undo your changes.

  6. Repeat the previous steps to create or change other settings.

  7. Release the lock on the domain.

    After you have made changes you must release the lock on the domain by committing, or rolling back your changes as follows:

    1. Navigate to the following MBean: oracle.biee.admin, Domain:bifoundation_domain, BIDomain, BIDomain.

    2. Display the Operations tab.

    3. (Optional) Click the commit operation link to save your changes and release the lock on the domain.

      Use this option when you are satisfied with the changes and you want to release the lock on the domain.

    4. (Optional) Click the rollback operation link to undo your changes and release the lock on the domain.

      Use this option when you do not want to commit your changes and want to release the lock on the domain.

  8. Go to the Oracle Business Intelligence Overview page and click Restart.

3.6 Where Are Configuration Files Located?

Oracle Business Intelligence configuration files, used to configure the behavior of the system, are found in various locations within the Middleware home.

Each host has its own set of configuration files for the components that are deployed on that host.

Oracle Business Intelligence system component configuration files can be found under:

MW_HOME\ORACLE_INSTANCE\instancen\config\COMPONENT\bi_component_name\

For example, the configuration file for the Oracle BI Server might be located in:

D:\mw_home\instances\instance1\config\OracleBIServerComponent\ coreapplication_obis1

Table 3-2 lists the names and locations of configuration files for each Oracle Business Intelligence system component. You are advised to use Fusion Middleware Control to update Oracle Business Intelligence configuration settings and ensure that changes are correctly propagated. For information, see Section 3.2, "Using Fusion Middleware Control to Update Oracle Business Intelligence Configuration Settings."

For information about diagnostic log configuration files, see Section 8.3.2, "What Are Diagnostic Log Configuration Files and Where Are They Located?"

Table 3-2 Oracle Business Intelligence System Component Configuration File Locations

BI Component Configuration File File Location

Oracle BI Server

NQSConfig.INI

logconfig.xml

ORACLE_INSTANCE\config\OracleBIServerComponent\coreapplication_obisn

For example:

\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1

Note: Although DBFeatures.ini is also located in this directory, do not edit this file directly. See Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition for information about how to edit features for a database.

Oracle BI Presentation Services

instanceconfig.xml

ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsn

For example:

\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Note: Do not add elements to the instanceconfig.xml file unless you are overriding the stated default values. Override only those settings that are necessary for configuring the system to meet the needs of your organization.

Cluster Controller

ClusterConfig.xml

ccslogging.xml

ORACLE_INSTANCE\config\OracleBIApplication\coreapplication

For example:

\instances\instance1\config\OracleBIApplication\coreapplication

Oracle BI Scheduler

instanceconfig.xml

ccslogging.xml
(for Cluster Controller)

ORACLE_INSTANCE\config\OracleBISchedulerComponent\coreapplication_obischn

For example:

\instances\instance1\config\OracleBISchedulerComponent\coreapplication_obisch1

JavaHost

config.xml

logging_config.xml

ORACLE_INSTANCE\config\OracleBIJavaHostComponent\coreapplication_obijhn

For example:

\instances\instance1\config\OracleBIJavaHostComponent\coreapplication_obijh1

Oracle BI Presentation Services Plug-in

bridgeconfig.properties

MW_HOME\user_projects\domains\domain_name\config\fmwconfig\biinstances\coreapplication

For example:

mw_home\user_projects\domains\bifoundation_domain\config\fmwconfig\biinstances\coreapplication


For more information about Oracle Business Intelligence installations, see Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence