OBIEE 11g R1 Architecture

Below diagram depicts the standard logical architecture of Oracle business intelligence 11g system Release 1.0 .It also represents the essence of OBIEE11g pictorially with the proper workflow of the interdependent components .Note that below diagram represents single node based architecture .The horizontal and virtual clustering across multiple nodes will be demonstrated later part of this exercise or on separate thread will be discussed later …

BI Domain:

Overall system is called “Oracle BI Domain” . This comprises of Java components deployed into J2EE containers , non java system components and required configuration files, metadata, repositories, and infrastructure. Oracle Enterprise Manager(OEM) acts as “Fusion Middleware Control” which together with Weblogic Admin Console are the basic backbone,the powerhouse and the Admin Activity controller for the entire domain .

Weblogic Server Domain: The logical domain consists of Admin server and Managed server .It comprises mainly with all the Java modules to trigger the java services .A peer handshaking has been done between WLSD and Oracle BI Instance.

Administration Server:

A JEE container that runs in a dedicated Java virtual machine that contains Java components for administering the system .It typically trigger the start,stop kind of admin activity for his peer Manager server processes.

Managed Server:

A JEE container that runs in a dedicated Java virtual machine that provides the run-time environment for the Java-based services and applications within the system.The services comprises of BI plugin , Security , publisher ,SOA ,BI Office services etc .

Node Manager:

Node Manager provides process management services for the Administration Server and Managed Server processes.Its a separate java utility runs to trigger the auto start , stop , restart activities for distributed Managed server.

Oracle Process Manager and Notification Server(OPMN):

It is monitored , managed and controlled by Fusion Middleware Controller(OFMW). It is also used for distributed process start/stop/restart i.e maintains the Oracle Business Intelligence system component processes.Also used for performance collection using Dynamic Monitoring System (DMS) .

Oracle Weblogic Server (Console):

It is the replacement of Oracle 10g R3 middle tier cluster topology based on Oracle Container for Java (OC4J) . It is a Java EE application server that supports the deployment of Oracle Business Intelligence Java components and primarily host the java component services inside Managed server .

Oracle WebLogic Server Administration Console access has been provided by Fusion Middleware Control.Oracle WebLogic Server Administration Console enables to monitor and manage a WebLogic Server domain. Its capabilities include the following:

  • Monitoring health and performance of JEE servers
  • Configuring WebLogic domains
  • Stopping and starting JEE servers
  • Viewing JEE server logs

Fusion Middleware Control:

Fusion Middleware Control is a browser-based tool and the recommended method for monitoring, managing, and configuring Oracle Business Intelligence components.

Fusion Middleware Control is used principally for managing the system components of a BI domain and provides support for the following:

  • Starting, stopping, and restarting all system components (BI Server,BI Presentation Server) and Managed Servers
  • Configuring preferences and defaults
  • Scaling out of system components
  • Managing performance and monitoring system metrics(DMS-Dynamic Monitoring System)
  • Performing diagnostics and logging (ODL-Oracle Diagnostic Logging)

Fusion Middleware Control also provides access to Oracle WebLogic Server Administration Console, where you monitor and manage Oracle Business Intelligence Java components.

To be very precise OFMW contains to components ..i.e. Java Components managed by Weblogic Server and System components managed by Oracle Process Manager and Notification (OPMN) and this includes below as well including BI components :

  • Oracle HTTP Server
  • Oracle Web Cache
  • Oracle Internet Directory
  • Oracle Virtual Directory
  • Oracle Forms Services
  • Oracle Reports
  • Oracle Business Intelligence Discoverer

OFMW Environment: Oracle Fusion Middleware environment contains Oracle WebLogic Server domain (including Administration Server, two Managed Servers) , an Oracle instance and Metadata repository .

Java components: Deployed as one or more Java EE applications:

  • Administrative Components — Enterprise Management applications and JMX MBeans for managing all configuration and run-time settings for Oracle Business Intelligence.
  • Oracle BI Publisher — This component provides an enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents to employees, customers, and suppliers.
  • Oracle BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.
  • Oracle BI Action Services — This component provides the dedicated Web services that are required by the Action Framework and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions.
  • Oracle Real-Time Decisions (Oracle RTD) — This component provides enterprise analytics software solutions that enable companies to make better decisions in real-time at key, high-value points in operational business processes.
  • Oracle BI Security Services — This component provides dedicated Web services that enable the integration of the Oracle BI Server with the Oracle Fusion Middleware security platform i.e JPS (Java Platform Security) , CSF (Credential Store Framework) and users and groups managed by  BI LDAP security.
  • Oracle BI SOA Services — This component provides dedicated Web services for objects in the Oracle BI Presentation Catalog, to invoke analyses, agents, and conditions. They make it easy to invoke Oracle Business Intelligence functionality from Business Process Execution Language (BPEL) processes.
  • Oracle BI Plugin — A JEE application that routes HTTP and SOAP requests to Oracle BI Presentation Services.

System components: Deployed as non-JEE components, such as processes and services written in C++ and J2SE:

  • Oracle BI Server — This component provides the query and data access capabilities at the heart of Oracle Business Intelligence and provides services for accessing and managing the enterprise semantic model (stored in a file with a .RPD extension).
  • Oracle BI Presentation Services — This component provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.
  • Oracle BI Scheduler — This component provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler)
  • Oracle BI JavaHost — 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.
  • Oracle BI 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.

Step by Step Upgrading Oracle 10g to Oracle 11g

Hell ! Yes , my Oracle 10g in Windows XP SP2 is the older one i.e which doesn’t Support the SOA Suite installation . Oracle suggest to upgrade this to 10R2 ( or higher ) . But bit lethargic about this upgrade as I do have to again download the Patch from Metalink  i.e of  size ~972 MB . Since I have had Oracle 11g installer so best possible option is to throw my Oracle 10g DB and install 11g afresh . But again the pain is to export all Db objects and again import into new DB .What if the new DB failed to import in 11g ? What if there is Unicode/Non-Unicode character set incompatibility occurs ? I know patchset available but I can’t rely on my knowledge about applying those pathset successfully !

After lots of brainstorming the final thought come is that there might be some way to upgrade the DB from already installed 10g to 11g using the available installer rather using the upgrade patchset for 11g. So finally kickoff  11g installation after executing the setup file and follow the onscreen instruction step by step .

Here you goes …

Oracle 11g Install-1

Oracle 11g Install-2


Oracle 11g Install-3Oracle 11g Install-4

Oracle 11g Install-5Oracle 11g Install-6

Oracle 11g Install-7Oracle 11g Install-8

Oracle 11g Install-9 Oracle 11g Install-10


So I have installed 11g softwares without having any Database . My aim is to upgrade the existing 10g instance as 11g .

1) Copy file : utlu111i.sql to d:\temp (any temporary location) from “D:\Oradb11g\RDBMS\ADMIN” .

2) Connected into Oracle 10g instance while DB is up and running and execute the .sql file from SQL prompt and get the below stat .

Oracle 11g Install-11

Oracle 11g Install-12

Oracle 11g Install-13

3) To resolve the below warning :

WARNING: –> Database is using an old timezone file version.
…. Patch the database to timezone file version 4
…. BEFORE upgrading the database. Re-run utlu111i.sql after
…. patching the database to record the new timezone file version.

Execute :

SQL> select * from v$timezone_file;

WHEN 183 then 1
WHEN 355 then 1
WHEN 347 then 1
WHEN 377 then 2
WHEN 186 then case COUNT(tzname) WHEN 636 then 2 WHEN 626 then 3 ELSE 0 end
WHEN 185 then 3
WHEN 386 then 3
WHEN 387 then case COUNT(tzname) WHEN 1438 then 3 ELSE 0 end
WHEN 391 then case COUNT(tzname) WHEN 1457 then 4 ELSE 0 end
WHEN 392 then case COUNT(tzname) WHEN 1458 then 4 ELSE 0 end
WHEN 188 then case COUNT(tzname) WHEN 637 then 4 ELSE 0 end
WHEN 189 then case COUNT(tzname) WHEN 638 then 4 ELSE 0 end
FROM v$timezone_names;

Oracle 11g Install-14

If the output of this is < 4 then prior to upgrade we need to apply the Timezone patch .So I need to apply it prior to go ahead . For my Windows 32 bit the patch(5731187) could be found at Metalink.

Download the file : and un-archive to location as : D:\temp\5731187 .

4) Copy the files from location : D:\temp\5731187\files\oracore\zoneinfo and paste it to existing Oracle 10g location “D:\oracle\oracore\zoneinfo” . Make sure to keep backup of existing folder so that you  could revert if any problem occurs .

5) Stop the DB instance and Start . After that execute Step 2&3 again and the warning should be removed and timzone file version should be upgraded. Otherwise assist Oracle Support .

6) To remove below warning execute the below command from sysdba users .

WARNING: –> Database contains stale optimizer statistics.
…. Refer to the 11g Upgrade Guide for instructions to update
…. statistics prior to upgrading the database.
…. Component Schemas with stale statistics:
…. SYS

Gather Dictionary stats:

Connect as sys user and gather statistics


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

7) I skip the other warnings .To avoid showing other warnings use Oracle Documentation about Pre-Upgrade Information

Final) Now lets perform the Database upgrade steps using : Database Upgrade Assistant(DBUA) a GUI to upgrade the DB and it can be found under Start -) All Programs -) Oracle 11g Home -) Configuration and Migration Tool and follow through the onscreen steps ….

Upgrade 10g to 11g using DBUA - 0

Upgrade 10g to 11g using DBUA - 1Upgrade 10g to 11g using DBUA - 2

Upgrade 10g to 11g using DBUA - 3

Upgrade 10g to 11g using DBUA - 4

Upgrade 10g to 11g using DBUA - 5

Upgrade 10g to 11g using DBUA - 6Upgrade 10g to 11g using DBUA - 7

Upgrade 10g to 11g using DBUA - 8Upgrade 10g to 11g using DBUA - 9

Upgrade 10g to 11g using DBUA - 10Upgrade 10g to 11g using DBUA - 11

Upgrade 10g to 11g using DBUA - 12Upgrade 10g to 11g using DBUA - 13

Upgrade 10g to 11g using DBUA - 14

N.B : You if are interested about the Manual upgradation using the scripts rather using the DBUA you can take the reference of onlineappsdba or Advait Blog .

After running for quite a long time (more than ~1 hr) the upgrade finishes . But alas ! life is no longer easy and another problem crops up .Enterprise Manager console is not getting configured as  there are some problem with 11g TNS service .Apart from this, everything looks fine after post upgradation messages ! 🙂

Oracle 11g Install-15

Oracle 11g Install-16

So lets wash hands and think more . The problem was I supposed to delete the Oracle11g TNS Service for 11g from Windows Registry after Software installation only and before creating the DB using DBUA .That is the reason why the TNS fails and this inturn cause the configuration failure for EMCA . The nuisance created by me and need to solve by me only 😦 . This problem might not crops up in your case ,I suppose .Otherwise follow the below steps to create the TNS . Run the “Net Configuration Assistant” from Program files OracleHome entry of start menu .Otherwise run : D:\Oradb11g\bin\launch.exe .

Create the TNS service is pretty easy there .Add new service with a name and the entry will be added automatically in Windows service list . Check by running : services.msc from Windows Run option .

N.B : Dont try to tweak registry and copy 10g TNS listener or modify it to point to 11g . Its pretty hard believe me until you dont know the impact in Windows Heart … i.e at Registry ! Also don’t try to create service manually by using sc.exe windows utility . Rely on Oracle Native Net Config Assistant all time 🙂

Hence … My Oracle 11g TNS is ready …DB is up and running fine…See below :

Oracle 11g Install-17

Now lets resolve the problem of EMCA.Follow the below command line utilities to drop the Enterprise Manager Repository and reconfigure it .Its pretty simple …again if you know the right way of doing it and finally reconfigure it .

Oracle 11g Install-18Oracle 11g Install-19

Oracle 11g Install-20

And finally all is done and lets Cheers ! 🙂 🙂 🙂

Oracle 11g Install-21

Oracle 11g Install-22