Oracle BI Cluster Server Components

The components that comprise the BI Cluster Server feature are

• Oracle Business Intelligence Cluster Controller
• Clustered BI Servers
• Master BI Server
• BI Scheduler
• Cluster Manager

Oracle Business Intelligence Cluster Controller

Whenever a new request arrives from BI Presentation Services and other clients, BI Cluster Controller serves as the first point of contact.The Cluster Controller determines which BI Server should be selected from the cluster to do the work or process the request.The Cluster Controller determines which BI Server in the cluster to direct the request to, based on BI Server availability and load. It monitors the operation of servers in the cluster.

The Cluster Controller is deployed in active-passive mode.

• Primary Cluster Controller : This controller is the active cluster controller.
• Secondary Cluster Controller : This controller is the secondary cluster controller.It assumes the role of the primary cluster controller if the primary controller is unavailable.

Clustered BI Servers

The BI Cluster Server feature supports up to 16 BI Servers in a network domain to act as a single server. BI Servers in the cluster share requests from multiple Oracle BI clients.

Master BI Server

A clustered Oracle Business Intelligence Server is designated as the Master BI Server. The Oracle Business Intelligence Administration Tool connects to the master BI Server for online repository changes.

BI Scheduler

BI Scheduler instances participate in the Cluster Server feature in active-passive mode.The active BI Scheduler instance processes jobs and executes iBot requests.The inactive BI Schedulers remain idle and do not process jobs until called on to take over the role in the event of failure of an active Scheduler.

Cluster Manager

The Cluster Manager is available in the Administration Tool when a repository is open in online mode. The Cluster Manager enables Oracle BI Server clustered instances, and activates Oracle BI Scheduler clustered instances.

How To Change/Reset The Password Of OBIEE Repository(Rpd) / How To Open OBIEE Repository(Rpd) In Offline Mode Without Password

Hi Friends,

You can follow the below steps

• Copy the RPD which you want to open to your local system.
• Make sure that the BI Server is not running.You can check that by typing services.msc from Start-->Run.
• Navigate to the NQSConfig.ini file on your local system. It is present at “OracleBI\server\Config”
• Open the NQSConfig.ini file using notepad.
• Under the Security/Authentication section in the NQSConfig.ini file, search for the below text and uncomment it.
  “AUTHENTICATION_TYPE = BYPASS_NQS;”
• Save the file.
• Restart the BI Server services.
• Try to open the RPD in offline mode without giving any password.

NQSConfig.INI

The default Authentication type for OBIEE is NQS but when we uncomment AUTHENTICATION_TYPE=BYPASS_NQS by removing the # symbol,it bypasses the default authentication and enables the user to open the RPD without any password.It can also be used for resetting the password of the RPD or sharing your RPD with others without sharing the credentials.To revert it back, modify the NQSConfig.ini file and comment out the AUTHENTICATION_TYPE = BYPASS_NQS again. Restart the BI services.

Server Instances in an OBIEE?

There are two server instances in OBIEE cluster

1. Master Server
2. Slave Server

What is Oracle BI Server?

Oracle BI Server

• is a stand-alone process that maintains the logical data model which it provides to BI Presentation Services through ODBC.
• high-impact query, reporting and analysis server that provides its services to the other components of OBIEE such as Answers, Dashboards etc.
• an analysis server providing a calculation and aggregation engine that integrates data from multiple relational, unstructured, OLAP, and other sources.

Components of OBIEE,Oracle Business Intelligence Enterprise Edition

 

The components of OBIEE include 

• Oracle BI Server read...
• Oracle BI Admin Tool read...
• Oracle BI Answers read...
• Oracle BI Interactive Dashboards read...
• Oracle BI Delivers read...
• Oracle BI Disconnected Analytics read...
• Oracle BI Publisher read...
• Oracle BI Briefing Books read...
• Oracle BI Office Plug-In read...
• Hyperion Financial Reporting read...
• Hyperion Interactive Reporting read...
• Hyperion SQR (Structured QueryReporter )Production Reporting read...
• Hyperion Web Analysis read...

Services in OBIEE and OBIEE Services Port number?

OBIEE consists of following services:

• Oracle Business Intelligence Server (Oracle BI Server)
• Oracle Business Intelligence Presentation Services (Oracle BI Presentation Server)
• Oracle Business Intelligence Scheduler (Oracle BI Scheduler)
• Oracle Business Intelligence Javahost (Oracle BI Java Host)
• Oracle Business Intelligence Cluster Controller (Oracle BI Cluster Controller)
• Web Server

Oracle BI Server

The Oracle Business Intelligence Server is a stand-alone process that maintains the logical data model which it provides to BI Presentation Services via ODBC. Metadata is maintained for the data model in a local proprietary file called the repository file(rpd). On the back-end, the BI Server connects to customer data stores via data source adaptors.The Port no is 9703

The Oracle BI Server infrastructure includes facilities such as:

• OBI Server is principally a query and analysis server software that can integrate data via sophisticated capabilities from multiple sources.
• The Oracle BI Server Design offers several performance and scalability optimizations including sophisticated optimization algorithms and parallel query and computation execution engines.
• The Oracle BI Server loads all the metadata stored and processes queries based on what is configured in the repositories (It can access multiple repositories)
• Compile incoming query requests into executable code, and execute the code.

The Oracle BI Server infrastructure includes facilities such as:

• session and query management, cancellation,
• statistics logging (log),
• monitoring (usage tracking, …),
• security, using standard protocols e.g. LDAP, Active Directory or OID.

How to find Oracle BI Server port no?
To find Oracle BI Server port no, navigate to OracleBI\server\Config\NQSConfig and search for RPC_SERVICE_OR_PORT.

Oracle BI Presentation Server

The Oracle Business Intelligence Presentation Services provides the framework and interface for presentation of Business Intelligence data to web clients. It maintains a Presentation Catalog service on the file system for the customization of this presentation framework. It is a standalone process and integrates with the Oracle Business Intelligence Presentation Services Plug-in from which it receives web client requests. It communicates with the Oracle Business Intelligence Server using ODBC over TCP/IP.The Port no is 9710

• It is a pure Web Environment.
• It visualize data from the Oracle BI Server through the creation of Interactive Dashboards and Oracle Answers. 

The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services. On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler

The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services.

Oracle BI Presentation Server interacts with the Oracle BI server as an ODBC client and provides a number of important services.The services provided are

1. It generates the Answers and Dashboards user interface.
2. It responds to user selections, generates logical SQL for the Oracle BI Server, and caches logical SQL statements and their results
3. It records the specifications the user makes about how data should be presented and interacts with the charting engine to create charts;
4. It pivots and aggregates data after the Oracle BI Server generates the result set
5. Provides user and group security for all of the Dashboards and Dashboard objects (reports). 

How to find Oracle BI Presentation Server port no?

To find Oracle BI Presentation Server port no,navigate to OracleBIData\web\config\isapiconfig.xml–localhost port

Oracle BI Scheduler

Oracle BI Scheduler is a server application that:

• manages and schedules jobs
• provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler.)

The Oracle BI Scheduler is an extensible scheduling application for scheduling reports to be delivered to users at specified times.It is the engine behind the Oracle Business Intelligence Delivers feature. The Port no is 9705.

Oracle BI Scheduler supports two kinds of jobs:

Scripted jobs

Scripted jobs are set up and submitted using the Job Manager feature of the Oracle Business Intelligence Server Administration Tool.For scripted jobs, Oracle BI Scheduler communicates with Oracle BI Server. Oracle BI Scheduler supports two published Java interfaces and two scripting languages.

• Supported Java interfaces:
• SchedulerJavaExtension.java
• SchedulerJobInfo.java
• Supported script languages (Windows Platform only):
• VBScript
• JScript 

Unscripted jobs, called (iBots|Agent)

(iBots|Agent) delivers reports and alerts/content to end users. Content can be analyses, dashboards, briefing books, or alerts. After delivering content, agents can also execute actions. Actions include Java actions, URL actions, Web service actions, and server script actions. (iBots|Agent) are configured and submitted for execution using Oracle BI Delivers.

Oracle BI Scheduler communicates with Oracle BI Presentation Services for unscripted jobs.

How to find Oracle BI Scheduler port no?

To find Oracle BI Scheduler port no,navigate to OracleBI]/server/Config/NQClusterConfig.INI—search for SCHEDULERS

Oracle BI Java Host

The Oracle Business Intelligence Javahost provides services to BI Presentation Services for Charts, Gauges and PDFs. The services are provided based on request-response model. This component provides component services that enable Oracle BI Presentation Services to support various components such as Java tasks for Oracle BI Scheduler, Oracle BI Publisher, and graph generation.The Port no is 9810.

• Oracle BI Java Host is for graphical representation of dashboards.

Oracle Business Intelligence Cluster Controller

This components distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain

Web Server

With installation of OBIEE we get OC4J as default web server.There are some drawbacks in this,so we migrate to other servers like Apache Tomcat,JBOSS etc. By default OC4J port number is 9704.