System Administrator's Guide for Oracle Business Intelligence Enterprise Edition

457 Pages·2017·3.06 MB·English

Oracle® Fusion Middleware
System Administrator's Guide for Oracle
Business Intelligence Enterprise Edition
12c (12.2.1.4.0)
E91534-05
January 2021
Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition,
12c (12.2.1.4.0)
E91534-05
Copyright © 2015, 2021, Oracle and/or its affiliates.
Primary Author: Hemala Vivek
Contributing Authors: Christine Jacobs, Nick Fry, Stefanie Rhone.
Contributors: Oracle Business Intelligence development, product management, and quality assurance teams.
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on
behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,
any programs embedded, installed or activated on delivered hardware, and modifications of such programs)
and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government
end users are "commercial computer software" or "commercial computer software documentation" pursuant
to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such,
the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works,
and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs
embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle
computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the
license contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloud
services are defined by the applicable contract for such services. No other rights are granted to the U.S.
Government.
This software or hardware is developed for general use in a variety of information management applications.
It is not developed or intended for use in any inherently dangerous applications, including applications that
may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you
shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its
safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this
software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are
used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,
and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered
trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise
set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not
be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content,
products, or services, except as set forth in an applicable agreement between you and Oracle.
Contents
Preface
Audience xxii
Documentation Accessibility xxii
Related Documentation and Other Resources xxii
Conventions xxiii
New Features for Oracle Business Intelligence System
Administrators
New Features and Changes for Oracle BI EE 12 c (12.2.1.4.0) xxiv
New Features and Changes for Oracle BI EE 12 c (12.2.1.3.0) xxiv
New Features and Changes for Oracle BI EE 12 c (12.2.1.2.0) xxiv
New Features and Changes for Oracle BI EE 12c (12.2.1.1.0) xxv
New Features and Changes for Oracle BI EE 12c (12.2.1.0) xxv
Part I
Administering Oracle Business Intelligence
1 Introduction to Oracle Business Intelligence System Administration
What Are the Oracle Business Intelligence System Administration Tasks? 1-1
Getting Started with Managing Oracle Business Intelligence 1-2
What Is the Oracle Business Intelligence System Logical Architecture? 1-3
Oracle Business Intelligence System Architecture 1-4
Oracle Business Intelligence Components 1-4
About the Administration Server, Managed Servers, and System Components 1-5
Key Directories in Oracle Business Intelligence 1-7
What System Administration Tools Manage Oracle Business Intelligence? 1-7
Fusion Middleware Control 1-8
Oracle WebLogic Server Administration Console 1-8
Process Control Commands 1-9
Oracle WebLogic Scripting Tool (WLST) 1-9
Oracle BI AdministrationTool 1-9
iii
Catalog Manager 1-9
Job Manager 1-10
Working with the Sample Application 1-10
Oracle BI Publisher Integration 1-10
Topics of Interest in Other Guides 1-10
System Requirements and Certification 1-11
Part II
Managing Processes and Components
2 Managing Oracle Business Intelligence Processes
About Managing Oracle Business Intelligence Processes 2-1
Conditions for Starting the Oracle Business Intelligence System 2-1
Using Commands to Start, Stop, and View Status of Oracle BI EE Processes 2-2
Starting Oracle Business Intelligence Component Processes in a Domain 2-2
Stopping Oracle Business Intelligence Component Processes in a Domain 2-3
Viewing the Status of Oracle Business Intelligence Components in a Domain 2-4
Using Fusion Middleware Control to Start and Stop BI System Component
Processes 2-5
Using Fusion Middleware Control to Start and Stop Java Components 2-6
Using Oracle WebLogic Server Administration Console to Start and Stop Java
Components 2-7
Part III
Scaling and Deploying for High Availability and Performance
3 Scaling Your Deployment
About Scaling Oracle Business Intelligence 3-1
Setting Up Shared Files and Directories 3-3
Changing the Singleton Data Directory (SDD) 3-3
Setting Up the Global Cache 3-4
Managing Capacity in Oracle Business Intelligence (Vertically Scaling) 3-4
Adding System Components 3-5
Removing System Components 3-7
Managing Availability in Oracle Business Intelligence (Horizontally Scaling) 3-8
Adding New Computers 3-8
Removing Existing Computers 3-11
Validating That Your System Has Been Scaled Correctly 3-12
Using Fusion Middleware Control to View System Component Availability 3-12
iv
Using the Administration Console to View Managed Server Availability 3-13
4 Deploying Oracle Business Intelligence for High Availability
About Oracle Business Intelligence Components in a Clustered Environment 4-1
Recommendations for Availability 4-3
Using Fusion Middleware Control to Identify Single Points of Failure 4-3
Achieving High Availability Using an Active-Passive Model 4-3
Configuring Oracle Business Intelligence Components for High Availability 4-4
Optional Configuration for Oracle Business Intelligence High Availability 4-4
Setting Optional Cluster Controller Parameters 4-4
Setting Optional Presentation Services Parameters 4-5
Setting Optional Oracle BI Presentation Services Plug-in Parameters 4-6
Using the Cluster Manager 4-6
Viewing and Managing Cluster Information 4-7
Status Information 4-7
Cache Information 4-8
Session Information 4-9
Server Information 4-11
Troubleshooting a Fusion Middleware Control Clustered Environment 4-11
Avoiding Errors with Network Appliance Devices When the Oracle BI Server Is
Running on Linux or UNIX 4-11
5 Managing Performance Tuning and Query Caching
Monitoring Service Levels 5-1
Using Fusion Middleware Control to View All Oracle Business Intelligence
Metrics 5-2
Using the Administration Console to View Metrics for Java Components 5-2
About Query Performance Tuning 5-3
Setting Performance Parameters in Fusion Middleware Control 5-4
Using Fusion Middleware Control to Disallow RPD Updates 5-4
Using Fusion Middleware Control to Set the User Session Log-Off Period 5-5
Using Fusion Middleware Control to Set Configuration Options for Data in
Tables and Pivot Tables 5-5
Using Fusion Middleware Control to Set the Maximum Number of Rows
Processed to Render a Table View 5-6
About the Oracle BI Server Query Cache 5-7
Query Cache Architecture 5-7
Advantages of Caching 5-8
Costs of Caching 5-8
Disk Space 5-9
v
Administrative Tasks 5-9
Keeping the Cache Up To Date 5-9
CPU Usage and Disk I/O 5-9
Cache Sharing Across Users 5-10
About the Refresh Interval for XML Data Sources 5-10
About the Global Cache 5-10
Configuring Query Caching 5-12
Using Fusion Middleware Control to Enable and Disable Query Caching 5-13
Using Fusion Middleware Control to Set Query Cache Parameters 5-13
Manually Editing Additional Query Cache Parameters 5-13
Using Fusion Middleware Control to Set Global Cache Parameters 5-14
Manually Editing Additional Global Cache Parameters 5-14
Monitoring and Managing the Cache 5-15
Choosing a Cache Management Strategy 5-15
Disabling Caching for the System 5-15
Caching and Cache Persistence Timing for Specified Physical Tables 5-15
Configuring Oracle BI Server Event Polling Tables 5-16
Purging and Maintaining Cache Using ODBC Procedures 5-16
About ODBC Procedure Syntax 5-18
About Sharing the Presentation Services Query Cache 5-18
About Result Records 5-19
Storing and Purging Cache for SAP/BW Data Sources 5-19
How Repository Changes Affect the Query Cache 5-20
Strategies for Using the Cache 5-21
About Cache Hits 5-22
Ensuring Correct Cache Results When Using Row-Level Database Security 5-25
Running a Suite of Queries to Populate the Cache 5-25
Using Agents to Seed the Oracle BI Server Cache 5-26
Using the Cache Manager 5-27
Displaying Global Cache Information in the Cache Manager 5-28
Purging Cache in the Administration Tool 5-29
Cache Event Processing with an Event Polling Table 5-30
Setting Up Event Polling Tables on the Physical Databases 5-31
Making the Event Polling Table Active 5-33
Populating the Oracle BI Server Event Polling Table 5-34
Troubleshooting Problems with Event Polling Tables 5-34
Configuring the Data Source Cache 5-34
Creating a Data Source Cache on the File System 5-35
Creating a Data Source Cache on a Database 5-36
Managing the Data Source Cache 5-39
Managing the Oracle BI Presentation Services Cache Settings 5-40
vi
Improving Oracle BI Web Client Performance 5-42
Configuring Apache HTTP Server for Static File Caching 5-43
Configuring Oracle HTTP Server for Static File Caching 5-45
Setting the JVM Heap Size for Oracle Business Intelligence 5-45
Improving Performance when Downloading Large Reports 5-46
Capturing Metrics Using the Dynamic Monitoring Service 5-47
Using the Dynamic Monitoring Service for Metrics 5-47
Using WLST Commands for Metrics 5-47
Part IV
Resolving Issues
6 Diagnosing and Resolving Issues in Oracle Business Intelligence
What Diagnostic Tools Are Available? 6-1
Collecting Diagnostic Bundles 6-2
Viewing and Configuring Diagnostic Log Files 6-2
Using Fusion Middleware Control to View Log Information, Error Messages, and
Alerts 6-3
Configuring Log File Rotation Policy and Specifying Log Levels 6-4
Using Fusion Middleware Control to Configure Log File Rotation Policy and
Specify Log Levels 6-4
Manually Changing Additional Log File Settings 6-5
Diagnosing Issues Using the Log Viewer 6-5
Understanding Diagnostic Log Files and Log Configuration Files 6-6
What Are Diagnostic Log Files and Where Are They Located? 6-7
What Are Diagnostic Log Configuration Files and Where Are They Located? 6-8
What Are Log File Message Categories and Levels? 6-10
What is Log File Rotation? 6-11
What Messages Are Included in the System Log? 6-12
Managing the Query Log 6-12
Configuring Query Logging 6-13
Setting the Query Logging Level 6-13
Setting the Query Logging Level for a User 6-15
Using the Log Viewer 6-15
Running the Log Viewer Utility 6-15
Interpreting the Log Records 6-16
Logging in Oracle BI Server 6-17
Using the Oracle BI Presentation Services Logging Facility 6-17
Setting the Logging Levels for Oracle BI Presentation Services 6-18
Structure for the Oracle BI Presentation Services Configuration File 6-18
Examples of the Formats of Logged Messages 6-22
vii
Oracle BI Presentation Services Message Structure 6-23
Oracle BI Presentation Services Log Filters 6-23
Diagnosing Issues with Agents 6-24
Debugging Agents Using Fusion MiddlewareControl 6-24
Manually Debugging Agents 6-25
Using ODBC/JDBC Procedures to Obtain Oracle BI Server Diagnostics 6-26
About the Oracle BI Server ODBC/JDBC Procedures 6-26
Obtaining a List of Available Diagnostic Categories 6-27
Running Specific Diagnostics 6-28
About Parameters for ODBC/JDBC Procedures 6-28
Troubleshooting System Startup 6-30
Administration Server Fails to Start When the Database Is Not Running 6-30
Managed Server Is Down 6-31
Oracle BI Server Fails to Start 6-31
Cannot Log In 6-31
7 Managing Usage Tracking
About Usage Tracking 7-1
Setting Up Usage Tracking 7-2
Setting Up Direct Insertion to Collect Information for Usage Tracking 7-2
Setting Up the Usage Tracking Statistics Database 7-2
Setting Direct Insertion Parameters 7-3
Setting Optional Direct Insert Parameters 7-4
Description of the Usage Tracking Data 7-4
Part V
Configuring Oracle Business Intelligence
8 Using Tools for Managing and Configuring Oracle Business
Intelligence
Why Use Fusion Middleware Control and WebLogic Server Administration Console? 8-1
Managing Oracle Business Intelligence System Components Using Fusion
Middleware Control 8-2
Logging into Fusion Middleware Control 8-2
Displaying Oracle Business Intelligence Pages in Fusion Middleware Control 8-3
Using the Navigation Tree in Fusion Middleware Control 8-4
Tips for Using Fusion Middleware Control with Oracle Business Intelligence 8-4
Configuring Oracle Business Intelligence System Settings 8-5
Using Fusion Middleware Control 8-6
Using a Text Editor 8-7
viii
Using the WebLogic Scripting Tool (WLST) 8-7
Making Offline Configuration Changes 8-7
Making Online Configuration Changes 8-8
Updating the Java Development Kit (JDK) 8-9
Managing Oracle Business Intelligence Java Components Using the Oracle
WebLogic Server Administration Console 8-9
9 Managing Metadata and Working with Service Instances
About Oracle Business Intelligence Application Archive (BAR) Files 9-1
What Are Oracle Business Intelligence Application Archive (BAR) Files? 9-1
What Predefined BAR Files are Available? 9-1
About Importing BAR Files 9-3
Managing Service Instances 9-3
listBIServiceInstances 9-5
getBIServiceInstance 9-5
scaleOutBIServiceInstance 9-6
export_service_instance 9-6
import_bar 9-8
refreshServiceInstance 9-9
refreshDomainServiceInstances 9-9
resetServiceInstance 9-10
10 Configuring Connections to External Systems

Configuring Email and Agents 10-1
Using Fusion Middleware Control to Configure Oracle BI Scheduler Email
Settings that Affect Agents 10-1
Configuring for Actions with the Action Framework 10-2
Configuring Connections to the Marketing Content Server 10-2
Configuring Connections to Data Sources 10-3
11 Configuring Presentation Setting Defaults

Using Fusion Middleware Control to Change Presentation Setting Defaults 11-1
12 Configuring Mapping and Spatial Information

What Are the System Requirements for Map Views? 12-1
Hardware Sizing and Deployment Strategy for Maps 12-3
Sample Spatial Dataset for use with Map Views 12-3
Administering Maps 12-4
ix
Working with Maps and Layers 12-4
Associating Layers with Columns 12-4
Ordering Layers on Maps 12-5
Changes to Spatial Metadata Require Restart 12-7
Administration Page Functions 12-7
Administering Maps Using Administration Pages 12-7
Handling the Translation of Layers in Maps 12-8
13 Configuring Time Zones

Why and Where Are Time Zones Used? 13-1
Setting Time Zones 13-2
What Is the Precedence Order for Time Zones? 13-3
User-Preferred Time Zone 13-3
Where Are Time Zone Specifications Stored? 13-3
Description of Time Zone Settings 13-4
Example: Configuration File Settings for Specifying the Time Zone 13-5
14 Localizing Oracle Business Intelligence

What Is Localization? 14-1
What Components Are Translated? 14-1
Tasks for Localizing Oracle Business Intelligence Components 14-2
Localizing Oracle BI PresentationServices 14-3
Localizing the User Interface for Oracle BI PresentationServices 14-3
Understanding the Directory Structure for Localizing Presentation Services 14-4
Localizing Messages for Users' Preferred Currency 14-4
Specifying the Default Language for the Sign-In Page 14-5
Configuring the Languages and Locales for the Sign-In Page 14-5
Specifying the Scaling of Numbers in Performance Tiles 14-6
Specifying the Language in the URL 14-7
Localizing Oracle BI Presentation Catalog Captions 14-8
Step 1: Understanding the Export Process 14-8
Step 2: Exporting Text Strings in the Catalog 14-9
Step 3: Editing Exported Strings in XML Files 14-10
Step 4: Handling Duplicate Exported Text Strings 14-11
Step 5: Exposing Text Strings in the Catalog 14-13
Step 6: Managing Text Strings in the Catalog 14-14
Tip for Arabic and Hebrew in Mozilla Firefox Browsers 14-14
Setting the Current Locale in Catalog Manager 14-15
Setting the Current Locale in the Oracle BI Server 14-16
x