Book Image

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial

By : Christian Screen, Haroun Khan, Adrian Ward
Book Image

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial

By: Christian Screen, Haroun Khan, Adrian Ward

Overview of this book

<p>The Oracle Business Intelligence Enterprise Edition 11g (OBIEE) suite delivers a full range of analytic and reporting capabilities, coupled with powerful user experience for creating reports, dashboards and more with your business data. "<em>Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial"</em> will have you unleashing that power in no time, helping you to take action and make the right decisions ataglance. <br /><br /><em>"Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial"</em> provides you with valuable insight and the step-by-step know-how you need to take advantage of everything the Oracle BI suite has to offer you, all utilizing real world case studies for a true implementation in action.<br /><br /><em>"Oracle Business Intelligence Enterprise Edition 11g: A Hands- on Tutorial"</em> takes you on a journey right from inception to a full working OBI 11g System. Using a real-world data walkthrough you’ll explore topics like architecture, reporting and leveraging Essbase as a data source, as well as building the Oracle BI 11g metadata repository (RPD), and developing reports and dashboards in the new Fusion Middleware interface. This practical implementation guide equips you with from the coalface advice which will help you achieve a successful working application by journey’s end.</p>
Table of Contents (26 chapters)
Oracle Business Intelligence Enterprise Edition 11: A Hands-On Tutorial
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

WebLogic Server


Let's talk a little more in detail about the enterprise application server that is at the core of Oracle Fusion Middleware—WebLogic. The Oracle WebLogic Server is a scalable, enterprise-ready Java Platform Enterprise Edition (Java EE) application server. Its infrastructure supports the deployment of many types of distributed applications. It is also an ideal foundation for building service-oriented applications.

The WebLogic Server is a robust application in itself. In previous versions of Oracle BI, the Oracle BI administrator and other developers took less effort to modify, configure, or otherwise maintain the Java application server. In Oracle BI 11g, the WebLogic Server is more crucial to the overall implementation, not only for installation but also throughout the Oracle BI 11g life-cycle. Learning the management components of the WebLogic Server, which ultimately controls the Oracle BI components, is critical for the success of an implementation. These management areas within the WebLogic Server are referred to as the WebLogic Administration Server, WebLogic Manager Server(Servers), and WebLogic Node Manager.

A few software nuances

Before we move on to the description of each of the management areas within WebLogic, it is important to understand that the WebLogic Server software, which is used for the installation of the Oracle BI product suite, carries a limited license. Although the software itself is the full enterprise version—logically containing 100 percent of the product's functionality—the license that ships with Oracle BI 11g is not a full enterprise license for the WebLogic Server. This book hardly deals with software licensing, but here are a few nuances that one should keep in mind as they go about an Oracle BI 11g implementation:

  • The WebLogic Server license, which is provided with Oracle BI 11g, does not grant horizontal scale-out. An enterprise WebLogic Server license needs to be obtained for this advanced functionality.

  • The WebLogic Server does not provide a separate HTTP server with the installation. The Oracle BI Enterprise Deployment Guide (http://docs.oracle.com/cd/E21764_01/doc.1111/e15722/toc.htm) discusses the separation of the application tier from the web/HTTP tier and suggests Oracle HTTP Server (OHS). OHS is part of the Oracle FMW web tier and must be downloaded separately (http://www.oracle.com/technetwork/java/webtier/downloads/index.html). The other web/HTTP servers that can be used are Apache and Windows IIS, which we will discuss in the Chapter 4, Installation Options.

These items are simply a few nuances of the product suite in relation to Oracle BI 11g. Most software products have a very short list of nuances like the preceding one. However, once you understand the nuances, it will be easier to ensure that you have a more successful implementation. It also allows your team to be prepared for implementations. Be sure to consult your Oracle sales representative to assist you with the licensing concerns.

Note

In order to learn more about the installation features, configuration options, administration, and maintenance of the WebLogic Server, we recommend that you reference the documentation of the WebLogic Server itself and not just the material on how it relates to Oracle BI 11g. The core of the WebLogic Server doesn't change just because Oracle BI 11g integrates into it. Understanding this approach should provide you with more efficient results.

WebLogic Domain

The highest unit of management for controlling the WebLogic Server installation is called a domain. A domain is a logically related group of WebLogic Server resources that you manage as a unit. A domain always includes, and is centrally managed by, one Administration Server. Additional WebLogic Server instances which are controlled by the Administration Server for the domain are called Managed Servers. The configuration for all the servers in the domain is stored in the configuration repository, the config.xml file, which resides on the machine hosting the Administration Server. The config.xml files, by default, are stored in the path <FMW_HOME>\user_projects\domains\bifoundation_domain\ where <FMW_HOME> is the path on the server to which you have installed Oracle BI 11g.

Upon installing and configuring Oracle BI 11g, the domain named bifoundation_domain is established within the WebLogic Server. This domain is the recommended name for each Oracle BI 11g implementation and should not be modified.

WebLogic Administration Server

The WebLogic Server is an enterprise software suite that manages a myriad of application server components mainly focused on Java technology. It is also comprised of many ancillary components that enable the software to scale well, and also make it a good choice for distributed environments and high availability.

Clearly, it is good enough to be at the core of Oracle Fusion Middleware. One of the most crucial components of the WebLogic Server is the WebLogic Administration Server. When installing the WebLogic Server software, the WebLogic Administration Server is automatically installed with it. It is the Administration Server that not only controls all subsequent WebLogic Server instances called Managed Servers, but also controls aspects such as security, Persistence Stores, and other application server-related configurations.

The WebLogic Server gets installed on the operating system and ultimately runs as a service on that machine. The WebLogic Server can be managed in several ways. The two main methods are via the Graphical User Interface (GUI) web application called the WebLogic Administration Console or via the command line using the WebLogic Scripting Tool (WLST). You can access the WebLogic Administration Console from any machine using a web-based client (that is, web browser) that can communicate with the WebLogic Administration Server through the network and/or firewall.

The WebLogic Administration Server and the WebLogic Server are basically synonymous. If the WebLogic Server is not running, the WebLogic Administration Console will be unavailable as well. If the WebLogic AdminServer is not running, no administrative tasks can be made to the system, although concessions are made for a High Availability configuration.

WebLogic Managed Server

Web applications, Enterprise Java Beans (EJB), and other resources are deployed on to one or more WebLogic Managed Servers in a WebLogic Domain. A WebLogic Managed Server is an instance of a WebLogic Server in a WebLogic Server domain. Each WebLogic Server domain has at least one instance which acts as the WebLogic Administration Server which we have just discussed. Only one Administration Server per domain must exist, but one or more Managed Servers may exist in the WebLogic Server domain. Having one or more managed servers, allow for deployed JEE applications to be logically delineated. They also provide a means to independently configure application server port numbers and they provide a barrier for runtime issues such as a server crash. You can deploy applications, EJBs, and other resources on the WebLogic Managed Servers and use the WebLogic Administration Server only for configuration and management purposes.

In a production deployment, Oracle BI 11g is deployed into its own Managed Server. The Oracle BI 11g installer comes with three installation types—simple, enterprise, and software. The latter two installation types configure two WebLogic Server instances, the Administration Server and another Managed Server called bi_server1. Oracle BI 11g is deployed into the Managed Server called bi_server1 and is configured by default to resolve to port 9704. The simple installation type configures only the administration server, deploys Oracle BI 11g into it, and resolves to port 7001. For the simple installation type, only one WebLogic Server instance exists.

Note

The simple installation type is not recommended for anything more than sandbox, test environment development, or demonstrations.

When administering the WebLogic Server via the Administration Console, the WebLogic Administration Server instance appears in the same list of servers that also includes the Managed Servers. The WebLogic Administration Server should be used only for configuration and management of the WebLogic Server and should not contain any additionally deployed applications, EJBs, and so on.

Note

One thing to note is that the Enterprise Manager Fusion Control is actually a JEE application deployed to the Administration Server instance, which is why its web client is accessible under port 7001. It is not necessarily a native application deployment to the core WebLogic Server, but gets deployed and configured during the Oracle BI 11g configuration. In the deployment's page within the Administration Console, you will find a deployment named em.

WebLogic Node Manager

The general idea behind the Node Manager is that it takes on somewhat of a middle-man role. That is to say, the Node Manager provides a communication tunnel between the WebLogic Administration Server and any WebLogic Managed Servers configured within the WebLogic Domain. When the WebLogic Server environment is contained on a single physical server, it may be difficult to recognize the need for a Node Manager. However, its real power comes into play when Oracle BI 11g is scaled out horizontally on one or more physical servers. Each scaled-out deployment of WebLogic Server will contain a Node Manager. If the Node Manager is not running on the server on which the Managed Server is deployed, then the core Administration Server will not be able to issue start or stop commands to that server. As such, if the Node Manager is down, communication with the overall cluster will be affected.

The following diagram shows how machines A, B, and C are physically separated—each of them contains a Node Manager. You can see that the Administration Server communicates with the Node Managers and not directly to the Managed Servers:

System tools controlled by WebLogic

We have briefly discussed the WebLogic Administration Console which controls the administrative configuration of the WebLogic Server Domain. This includes the components managed within it such as security, deployed applications, and so on. The other management tool which provides control on the deployed Oracle BI application ancillary deployments, libraries, and several other configurations is called the Enterprise Manager Fusion Middleware Control.

Note

This seems to be a long name for a single web-based tool. As such, the name is often shortened to Fusion Control or Enterprise Manager. Reference to either abbreviated title in the context of Oracle BI should ensure fellow Oracle BI teammates understand what you mean.

To discuss the vast amount of individual configuration points contained within the WebLogic Administration Console and Fusion Control, you can warrant an entire chapter devoted to this subject. In fact, a subsequent chapter, Chapter 5,Understanding the Systems Management Tools is dedicated to it.