Tuesday 7 August 2012

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.            

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis