Oracle Business Intelligence Enterprise Edition …

1 Oracle Business Intelligence Enterprise Edition deployment GuideVersion 2006 Part Number: B40058-01 Copyright 2006, Oracle . All rights Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is information contained in this document is subject to change without notice.

2 If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is GOVERNMENT RIGHTS. Programs, software, databases, and related documentation and technical data delivered to Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations.

3 As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR , Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the , JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates.

4 Other names may be trademarks of their respective Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services.

5 Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party. Oracle Business Intelligence Enterprise Edition deployment guide 1: What s New in This ReleaseChapter 2: Overview of Oracle BI Enterprise DeploymentChapter 3: Clustering, Load Balancing, and Failover in Oracle Business IntelligenceOracle BI Cluster Server Components 13 Clustering of Oracle BI Components of the Presentation Layer 15 Communication Between Oracle BI Components in a Clustered Environment 15 Failover Mechanisms for Oracle BI Components 19 Shared Files and Directories 21 About the Cluster-Aware Cache 22 Configuration of BI Components for Clustering, Load Balancing.

6 And Failover 24 Setting Parameters in the File 24 Setting Parameters in the File 26 Configuring BI Presentation Services 28 Configuring BI Scheduler 30 Configuring BI Presentation Services Plug-in 33 Modifying BI ODBC Data Sources For Communication With BI Cluster 36 Best Practices for Setting Up an Oracle BI Clustered Environment 37 Troubleshooting an Oracle BI Clustered Environment 37 Monitoring and Managing BI Servers and BI Schedulers in a Cluster 38 Deploying Oracle Business Intelligence Publisher for High Availability 39 Integrating BI Publisher with Oracle BI Clustered Environment 40 Integrating BI Publisher in BI Presentation Services User Interface 42 Chapter 4.

7 Deploying Oracle Business Intelligence for High Availability Planning For the Installation 45 Installation of Oracle BI Components 46 Installing Oracle BI Client Tools (Windows) 46 Oracle Business Intelligence Enterprise Edition deployment guide Version 4 Installing Oracle BI Cluster Controllers 46 Installing Oracle BI Server 47 Installing Oracle BI Scheduler 47 Installing Oracle BI Presentation Services and Oracle BI Javahost 48 Installing Oracle BI Presentation Services Plug-in 49 Shared Files and Directories 51 Configuration of Oracle BI Components for Clustering, Load Balancing, and Failover 52 Pre-Configuration Tasks 52 Setting Parameters in the File 52 Setting Parameters in the File 53 Configuring BI Presentation Services 55 Configuring BI Scheduler 57 Configuring BI Presentation Services Plug-in 59 Modifying BI ODBC Data Sources For Communication With BI Cluster 61 Deploying Oracle Business Intelligence Publisher for High Availability 63 Installing BI Publisher 63 Deploying BI Publisher Engine on J2EE Based Application Servers 64 Configuring BI Publisher to Use a Shared File System Repository 64 Integrating BI Publisher in BI Presentation Services User Interface

8 65 Integrating BI Publisher with Oracle BI Clustered Environment 66 Chapter 5: Oracle BI Presentation Services Credential StoreCredentials and Aliases 69 Supported Storage Types 69 Configuring BI Presentation Services to Identify Credential Stores 70 Credential Store Storage Types 72 File System Store (XML File Store) 72 Java Keystore 78 Custom Store 80 Chapter 6: Enabling Secure Communication in Oracle Business IntelligenceProcess for Enabling Secure Communication for Oracle BI Components 84 Creating Certificates and Keys 84 Generating Certificates and Keys Using openssl 85 Creating the Certificate Authority (CA)

9 Certificate 85 Generating the Hash Version of the CA Certificate File 87 Contents Oracle Business Intelligence Enterprise Edition deployment guide Server Certificate and Server Private Key 87 Creating the Client Certificate and Client Private Key 89 Creating Passphrase Files or Passphrase-Producing Programs for Server and Client Keys 90 Creating the Java Keystore 91 Generating the Private Key 91 Generating the Certificate 91 Signing the Client Certificate 91 Importing the Certificate Authority File to a Java Keystore 92 Importing the Certificate to the Java Keystore 93 Configuring Oracle Business Intelligence to Communicate Over SSL 93 Configuring Oracle BI Cluster Controller 95 Configuring Oracle BI Cluster Controller in Minimum Security Scenario 96 Configuring Oracle BI Cluster Controller in Near-Maximum Security Scenario 96 Configuring Oracle BI Server for Communication Over SSL 98 Configuring Oracle BI Server in Minimum Security Scenario 99 Configuring Oracle BI Server in Near-Maximum Security Scenario 99 Configuring Oracle BI Server Client 101 Configuring Oracle BI Scheduler 104 Configuring Oracle BI Job Manager 110 Configuring Oracle BI Presentation Services for Communication Over SSL

10 111 Configuring Oracle BI Presentation Services Plug-In for Communication over SSL 113 Configuring BI Presentation Services (Java Servlet) for Communication over SSL 114 Configuring BI Presentation Services Plug-in (ISAPI) for Communication Over SSL 117 Configuring Oracle BI Javahost for Communication Over SSL 117 Configuring BI Presentation Services and BI Publisher When SSL is Enabled 119 Chapter 7: Oracle Business Intelligence Authentication MechanismsChapter 8: Implementing Single Sign-On Products With Oracle Business IntelligencePrerequisites for SSO Systems to Integrate With Oracle Business Intelligence 125 Understanding How Oracle BI Presentation Services Operates in an SSO Environment 126 Enabling SSO Authentication for Oracle Business Intelligence 127 Configuring Oracle BI Presentation Services to Use Impersonator User 127 Configuring Oracle BI Presentation Services to Operate in an SSO Environment 132 Important Considerations For Implementing SSO for Oracle Business Intelligence 133 Oracle Business Intelligence Enterprise Edition deployment guide Version 6