OBIEE 11g – Up-gradation Catalog and Env/Config Issues/Challenges and Fixes (11.1.1.6 & 11.1.1.5)


Since(Oct 2011) I had started working on OBIEE 11g (11.1.1.5) for four different projects in parallel to up-grade the 10g to 11g lot of challenges have been faced specially with the Catalog and Environment issues. (You can see the already reported RPD issues under: https://debaatobiee.wordpress.com/2012/01/26/obiee-11g-up-gradation-rpd-gotchas-and-glitches/ )

I could report all of them in below threads with the possible resolution but as I am writing this blog now (actually I am bit late posting this thread L ) some of them already taken care of in 11.1.1.6 version however not all and bit surprised that though Oracle agreed to release the patch in .6 version and file the bug report they didn’t work out yet on those mentioned issues reported during .5 up-grade.

Worth to see the link here for possible changes in BI reports due to new features before taking the assumption that it is a bug.

As par my latest up-gradation from 10g to 11.1.1.6 is concerned it went well but still some of the defects which are already noticed in .5 not fixed yet, some of them appeared new and some of them totally ridiculous and critical too as per business perspective and some of them not reported yet to Oracle and hence no relevant information found in Support.

I am happy to categorizing them into two different areas below: (I have used .5 and .6 interchangeably to mean 11.1.1.5 and 11.1.1.6)

Environment and Configuration Issues

  • Up-gradation of RPD and Catalog separately could cause the issue with the Dashboard Privileges and Object permissions. I had experiencing the issue when upgrade the catalog first and then RPD and reason which I could think of is that until the RPD up-gradation completed successfully by the UA it doesn’t going to reflect all the Users/Groups information in the Weblogic Security store. So if you are experiencing the issue recommendation is to at-least perform the RPD first and then catalog.
  • During the migration process we have followed the approach to up-grade the same 10g RPD in the higher environment (say Test or UAT) to ensure the security store upgrades taken care of by the UA automatically. Other approach could be taken the export of the security store from the Weblogic Console for my security realm and then Import the security details to target env which basically perform a XML upgrade of security details in target environment
  • Job ManagerPassword is not upgraded with RPD upgrade .It still retains the password of source RPD and target RPD password needs to be changed manually. At-least the behavior has been seen in 11.1.1.5 and have not tried yet this in the .6 version
  • Upgrade can’t be done if the parameters are locked in FMW EM console: Upgrade will fail with below status. Need to release the lock and retry.
  • Take extra caution when you are enabling the RPD Read only option in the EM as I found this is quite weird but finally checking and un-checking multiple time resolves my problem. So there is possible bug around this features in .5 didn’t try the .6 yet.
  • Never try to deploy the RPD using the undocumented and wrong procedures except from EM .Otherwise you will find “CSK Key not found” issue during RPD deployment process.
  • Missing Application roles in catalog results the new roles to be created inside Weblogic Admin Console and map to the groups i.e. required.
  • Deploying EAR file gives: “Deployer:149082 You cannot deploy application ‘analytics’ without version” . OBIEE 11g: Error: ” <[WebAppModule(analytics [Version=11.1.1]:analytics)] Error Parsing Descriptor in Web Application” Whilst Deploying Analytics.ear File . This is 11g bug . See the resolution and patch note in Support
  • While changing the password of Administrator account in EM and Weblogic make sure both are in synchronize.
  • Loglevel Bug – NULL loglevel value set against user in external table based authorization scheme cause the user login failure however the same configuration in database level works perfectly okay with 10g setup. Resolution is to have must non-null values against all users in database records. This persists till .5 version and did not check yet the .6 version.
  • While executing OPatch utility to apply the patches provided by Support to .5 env it displays with below information:

    Running prerequisite checks…

    Prerequisite check “CheckActiveFilesAndExecutables” failed.

    The details are:

    Following files are active :

    D:\Oracle\Middleware\Oracle_BI1\bifoundation\server\bin\nqsexecutionexpr64.dll

    D:\Oracle\Middleware\Oracle_BI1\bifoundation\server\bin\nqsexecutionlist64.dll

    D:\Oracle\Middleware\Oracle_BI1\bifoundation\server\bin\nqsserviceinterfacemgr64.dll

    D:\Oracle\Middleware\Oracle_BI1\bifoundation\server\bin\nqssimutility64.dll

    ApplySession failed during prerequisite checks: Prerequisite check “CheckActiveFilesAndExecutables” failed.

    System intact, OPatch will not attempt to restore the system

    OPatch failed with error code = 74

    Resolution is to change the Privilege of “C:\Program Files\Oracle\Inventory” directory from read-only to Read-Write with Full-Control . However that was never documented in Oracle OPatch Readme.

  • While changing the BISystemUser password make sure those are in sync with EM security store and Weblogic Console and till .5 version there was issue with using special character as BISystemUser password. Make sure that it should not have special characters.

Catalog Issues

  • “Act As” doesn’t populate the list of users and throwing functionality disabled by Admin. For Act As to work for the LDAP based users required configuration needs to be done (except what is the to-do configuration for 10g) as the security model for 11g is different from 10g. I will detail the change in “Act As” process in separate thread.
  • There are always problem with the report or prompts decimal issues .Either new decimal value appended , decimal value missing, 3 decimal places appears in place of 2 or decimal values not appearing at all in Charts mouse over option. Also the issue persist in aggregate calculations which possibly results the wrong value in Sub-Total or Grand total. The problem needs to be diagnosed and isolated before fixing.
  • 11.1.1.6 causing the issue for Multi Path navigation . While there is single navigation path in 10g there is no needs to have a pop-up with the Action link text name but UA not being able to trace the link name while it is a single path. Also if there is ‘&’ character in the Action Link text it improperly translate it as ‘&’. However there is no quick fix available as of now and you need to go to individual navigation where problem exist and fix it by clicking option ‘don’t show pop-up in place of single navigation”
  • Upgrade Assistant (UA) not really able to up-grade properly the navigated links/interactions against column header, value name and hence post up-gradation we had to manually remove all the unwanted navigation paths from column values. This typically occurs if any column of the table/pivot view has interaction, it is going to add the same interactions/Action Links to the measures columns across the reports.
  • Typical problem has been faced in the Aggregate calculation and the conditions specified in the pivoted report. Those have been faced case by case.
  • There is severe issue with Count Distinct measures specially to calculate the Grand Total and results the calculation mismatch between 10g/11g reports.
  • Sorting of columns having the hard-coded customized values not works for Combined request. Special tweaking needs to be done to fix the issue by appending some space characters once, twice, thrice etc.
  • Problem with SQL_TSI_WEEK function and Can’t properly cast the value caused CASTing errors. Not sure if that fixed in .6 version and not tried yet.
  • iBots causing the issue after executing it and reports : “AgentID: /shared/Test – DxP/DxP_iBot” , Invalid subscribers skipped: DEBA . The reason is SASystemSubject area enabled . The problem found in .5 version and the fix is to disable the SystemSubjectArea using the special tag inside instanceconfig.xml file
  • OBIEE 11g: Error While Fetching a Large Pivot Table: “Exceeded Configured Maximum Number of Allowed Input Records” while downloading the reports with more than millions of rows . However it has been observed that the problem not exist in 10g and aligning the required parameter in instanceconfig doesn’t resolve the issue. The same issue persists if download operation of the report triggered using the JavaScript’s and the iBots scheduler. Below error reported in the downloaded excel file. So far the issue persists in .5 and bug opened for that. Not sure if that is fixed in .6 yet

                 “Exceeded configured maximum number of allowed input records” onclick=”SAWMoreInfo(event)

                 Error Codes: EKMT3FK5

  • Redundant Legend for Chart View in OBIEE Pivot and Table based Charts causing the weird legend display. However part of that has been fixed and still some of the customized charts the issue retained in .6 version.
  • 45 degree angle Chart axis label causing blurred labeling which is un-readable and pretty difficult to understand. Support suggests ‘EmbedFonts’ tag under instancconfig which also doesn’t help and I have seen the problem still persists in .6 release.
  • Some of the crowded/busy charts axis labeling doesn’t plot the label value at all in the axis .However data and bar shows perfectly fine during hovering but the axis label under some of the vertical or horizontal bar seems missing. Resolution as of now is to increase the charts width and height, reduce the axis label fonts and make the label as 0 or 90 degree. The problem typically found in .6 version
  • Pivot table column header formatting not properly upgraded for some of the reports and not all. The problem typically found in .6 version
  • Additional row in every table or pivot view cause the format difference with 10g reports. Not sure when the fix or ever the fix will be available
  • In .5 release if we want to remove some column from the view of the table in Dashboard page it was possible but you couldn’t add those later and never find those removed column. But it seems that Oracle fixed the issue in .6 release.
  • In .6 version critical data issue exist if the presentation column (P1) (where P1 and P2 refers the same logical column) used in reports with combination of other measures. In those cases it was causing weird data issues. So has been fixed by pulling correct relational presentation dimension column relevant to the logically same place of the metrics
  • Critical catalog issue has been observed while Navigating from the Chart or Pivoted Chart where the value in the database having & character like (‘HOME & BEAUTY’) .In those case navigation to the detail report caused no results as the value itself from the chart passing to DB is like ‘HOME & BEAUTY’ in the where clause of the query. Didn’t got any response yet from Oracle about the fix and the patch. Latest Update(June/08/2012) — Oracle agreed the defect and raise the priority bug fix with no estimated SLA .However the issue escalated and waiting for Development team response. They also confirmed that the same issue will be there while Drill down from data value having special characters (like ‘&’) .
  • In Chart pivoted result one of the metric value which is NULL, appeared in Pivot table and not in Chart for 10g, but in 11g it is coming for both Pivot and Chart . No solution apart from segregating the view into new Chart view.
  • The expression like “CAST(((max(saw_3 by saw_1) /max(saw_4 by saw_1))*100) AS VARCHAR(50)))” no more valid in 11g at-least in .5 version.
  • Presentation variable report filter default values are no more Case sensitive in 11g at-least observed in .5 version
  • BI Publisher issue in one of the up-graded report as “oracle.xdo.XDOException: oracle.xdo.XDOException: Unable to create saw session. Please verify the server connection” and entire report needs to redesign for that using different security approach.
  • Sometime it will be seen that until the Results tab returns the values if you bring the column from presentation area to criteria it will not reflect and sounds like column not added yet .However after results returns come back to Criteria you will see the column added. There are possible synchronization issue which still persists in .5 and .6 version.
  • Clicking on Hierarchy column will show the results in left pane while we are in Results tab but same doesn’t exist if we click the column left pane in Criteria tab. This could be possible enhancement req on top on .6 version
  • In 10g we can press Control from keyboard against the presentation column and the filter condition pop-up can be appeared automatically but same feature doesn’t exist in 11g .This could be a future and very useful enhancement request.
  • In 11g .6 version has some issue with the Saved Filter post up-gradation and clicking on that filter view doesn’t pop-up the filter criteria and even the view doesn’t display anything in Dashboard page if we clicked it. However building the Saved filter from scratch resolves the problem. So issue there in catalog copy post .6 up-gradations. The problem identified later with the Integer value based column in filter criteria and the resolution is convert that to advanced SQL based values and that will sort out the problem . This is definitely another 11g .6 version bug.
  • Sorting issues are there for charts and on measure while using RANK order
  • In some of our Charts we have seen there is display issue in IE8/9 and Chrome but not in Mozilla Firefox after up-gradation . However re-creating or building the same using IE8/9 browser fixes all the display issues and it is working perfectly fine. Also in some situation I have observed creating new view doesn’t help, in that case bring the attribute from presentation once again and create the derived expression once again and that sorts out the issue.
  • In one of our request we have found the partial data  issue/mismatch with Combined request with Union . After digging into the details it has been found that the issue is due to a calculated column in pivot section (whereas the same view didn’t have any calculated column in 10g !!) .The issue is bit strange . Deleting the unnecessary calculated columns/ or recreating the same view from scratch caused the issue fixed.
  • Couple of the iBots not properly up-graded by UA and cause Bad XML instance error while executing the same. Even those iBots are not editable and can’t be saved during the XLM error. Support bug opened for that but not sure whether it has been fixed in .6 yet.
    This thread will be updated frequently to add more and more defects observed and the progress/resolution for it .
    So stay tuned 🙂
    Also just keep eye on OBIEE 11.1.1.6.1 and 11.1.1.6.2 patches and the related bug fixes to be up-to-date !

Migration of the Security Stores – OBIEE11g


In my recent up-gradation projects after doing the Up-gradation in Dev Environment it is a obvious question that how I get my security setup migrated to say Test environment . One easy way to do this is just up-grade your Test env and during the up-grade process your user/group list will be automatically updated to the security store of 11g and will be automatically done by Upgrade assistant behind the scene. However this is a work around but this process is not the Oracle suggested method for security policy store migration.

The actual process to do this is using the Migration assistant under Security realm of  Weblogic Console. See below image . Go to Export tab and put any directory name where you want the exported copy like : D:\Share\Security …

The .dat file list would be like below:

Now once you get this list click on Import button of the target environment (say. Test) and simply click the update button . You will see all list of users and groups will be automatically migrated from Dev to Test .

Cheers…

OBIEE 11g LDAP with HTTPS – SSL Setup


Hypertext Transfer Protocol Secure (HTTPS) is a combination of the Hypertext Transfer Protocol (HTTP) with SSL protocol to provide encrypted communication and secure identification of a network web server. HTTPS connections are often used for payment transactions on the World Wide Web and for sensitive transactions in corporate information systems.

The purpose of the thread is to establish the connection between web via OBIEE11g front-end and the weblogic app server using  HTTPS protocol . The first part of the below thread describes it. The second part of the thread describes how to enable the communication between the OBIEE components,Weblogic Admin and Managed servers via secure SSL protocol. This will ensure the communication using the SSL Certificates.

In my case it is presumed that OBIEE11g Repository already configured with LDAP server based authentication.

Part One – Configuration under Weblogic Admin


Rest of the settings described as below:

1) Login to Weblogic Administration Console .

2) Click on Environments -) Servers -) AdminServer (admin) -) General tab

3) Click Lock and Edit from the left pane.

4) Check the ‘SSL Listen Port Enabled’ as 7002 (this is not default SSL port enabled for all browsers , So please check yours ad modify based on that)

This will ensure that you will be able to access the URL using 7002 port using https://

5) Check also ‘Listen Port Enabled’ if you also want to access BI URL using http://

6) Save the configuration

7) Activate the changes from left pane

8 ) Change the StartStopServices.cmd file from : “<MiddleWare Home>\instances\instance1\bifoundation\OracleBIApplication\coreapplication” as below for below parameters only:

set BI_URL=https://%wls.host%:%wls.mgd.port%/analytics

set wls.mgd.port=7002

9) Restart the Weblogic Servers(Admin/Managed) and BI Servers components

10) Accept the exception in browser when it prompts for it and continue accessing BI URL in secure HTTPS protocol

(Note that once this has been made as https:// you have to access OFWM EM Control page and Weblogic Console page also in https:// going forward)

Part Two – Configuration under OFMW Enterprise Manager

1) Navigate to “<OFMW Home>\user_projects\domains\bifoundation_domain\bin” and take backup of startManagedWebLogic.cmd

2) Edit and locate section with below content::

set JAVA_OPTIONS=-Dweblogic.security.SSL.trustedCAKeyStore=”<OFMW Home>\wlserver_10.3\server\lib\cacerts”

3) Replace the above with below:: (Kindly note that you have to change the OFMW Home path as applicable to your environment)

set JAVA_OPTIONS= -Djavax.net.ssl.trustStore=”<OFMW Home>\wlserver_10.3\server\lib\DemoTrust.jks” -Djavax.net.ssl.trustStorePassword=”

4) Restart all the services of Weblogic (Admin/Managed/opmnctl/Node Manager/Process Manager)

5) Now in the next step System MBean browser will be configured to enable SSL across all BI components

6) Login OFMW Control Enterprise Manager page

7) Invoke the Lock of BIDomain.

8 ) Now we have to Generates the certificates required as a prerequisite for enabling SSL, using the specified passphrase to protect both certificate stores and private keys.This enables internal https calls to the web server. The certificate type (pem or der) must be explicitly stated.

Hence navigate to oracle.biee.admin –> bifoundation_domain –> BIDomain.BIInstance.SecurityConfiguration and click on the BIDomain.BIInstance.SecurityConfiguration MBean.Click on the operation tab click on “generateSSLCertificates”.

9) Enter the details asked for: For my case I have included below:

Passphrase  : dxp12345

webServerCACertificatePath : \wlserver_10.3\server\lib\CertGenCA.der

certificateEncoding is: der

10) Now click on Invoke

11) Return to the path specified in step 7 and click on simpleCommit.

12) Now click on attributes tab of the step 8 and click on ‘SSLEnabled’ .Change the value to True from False and click on Apply.

13) Repeat step 7 to lock and perform step 11 for simpleCommit.

14) Repeat Step 4

15) Return to Step 8 and click on “runSSLReport” ,Invoke it and find the output as below to ensure correct SSL communication across all BI components:

That’s All for today …. See you next time … 🙂 stay tuned !

OBIEE 11g Security Policy


There are combinations of different stores (Identity Store,Policy Store,Credential Store) which take active role defining OBIEE 11g security including both Authentication and Authorisation . The below diagram mostly describes the process flow and the integrated components. Description for the flow (with the components) will be available in the same thread updated … keep watching my space 🙂

Identity Store: It is directory server to perform the authentication. It contains user name , password and groups membership information .When a user name and password combination is entered at log in, the authentication provider searches the identity store to verify the credentials provided.

Policy Store: Contains the definition of Application Roles, Application Policies, and the mapping between them.A policy store can be file-based or LDAP-based.Oracle Business Intelligence permissions are granted by mapping users and groups from the identity store to Application Roles and permission grants located in the policy store.

Credential Store: It is responsible for securely storing and providing access to credentials required by Oracle Business Intelligence Applications components internally.For e.g, SSL Certificates stored here.

Two way the authentication can be done . Oracle Weblogic Administrator Console used to manage Embedded directory server (LDAP) to authenticate Users and Groups.Sometimes Oracle Internet Directory is used as authentication provider and OID console is used to manage user and groups.

After the authentication done , the authorisation will be done across Policy store and Credential store where application role and group mapping will be executed .

Application and System related security credential will be store inside the Credential Store (oracle wallet) .

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.

Oracle Business Intelligence Enterprise Edition(OBIEE) 11g Installation


Below screenshots will guide you through step by step installation of OBIEE 11 g Fusion Middleware product .Before start the setup make sure Oracle 11g database installed and RCU setup completed.

Step 1: Download OBIEE 11g (11.1.1.3.0) version from below link of OTN .

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence11g-240521.html

Prerequisite has been installed as  : Oracle 11g DB R2 and RCU 11.1.13.3 .

Now extract the download copy into two different folders ….

Merge the two folders content into single directory “..\bi_windows_x86_111130_32_disk1_1of2\bishiphome” .

Step 2: For DHCP computer having no permanent IP Address you need to configure Microsoft default Loopback address .Follow the steps provided under section “Installing a Loopback Adapter on Windows 2003 or Windows XP”  from Nicolas Loopback Adapter Configuration .The glimpse of it as below:

Step 3: Execute the setup.exe .

Oracle Universal Installer (OUI) pre-requisite verification started .

Then the OFMW 11g Installer template initiated.

Step 4: Click Next on Welcome screen appeared below.

Step 5: Select the “Installation Type” as ‘Simple’ .This is most easiest and recommended for first try .All the parameters will be set by default.

N.B:- Enterprise installation is mostly required in Scalable system having the configuration required across multiple Weblogic domain or joining a existing domain to existing Weblogic Server .The “Software Only Install” requires the configuration done in different phase after the enterprise wide installation is over .

Step 6: Pre-requisites check has been done .

Step 7: Specify the installation location .

Step 8: Enter the ‘Weblogic’ Admin credentials . In my case the password is : ‘weblogic#1’ (without quotes to meet Oracle Password standard) .

Step 9: Configuring the components . In my case I select all .

Step 10: Specify the connection parameters ..

N.B:- Be aware of the joker type error message thrown here during my first installation as “INST-08029 Unable to connect to Database with given credentials.” It seems to be an Oracle BUG .See the issue in screenshot .



The reason of this error is the BIPLATFORM schema password .In RCU utility if you provide the password same as Schema name it would be creating trouble. Not sure whether it doesn’t accept the same password or it doesn’t accept the underscore(‘_’) character .I have not investigate further on it 😦

Anyway I get rid of it after dropping the RCU schema for BI and recreate the same with password as ‘rcu’ .This password has been provided here .

Step 11: Specify security update section .

Step 12: Finalise the installation .

The installation started …..

After installation done the configuration Process starts …

Step 13: The installation and configuration completed .Click Finish .

So finally OBIEE11g has been installed successfully with the below access details for different application :


Type: Simple Install
Installation Details
Middleware Home: E:\OraFMW11g
BI Oracle Home: E:\OraFMW11g\Oracle_BI1
WebLogic Server Home: E:\OraFMW11g\wlserver_10.3
BI Domain Home: E:\OraFMW11g\user_projects\domains\bifoundation_domain
BI Domain Name: bifoundation_domain
Instance Home: E:\OraFMW11g\instances\instance1
Instance Name: instance1
Configure Components
WebLogic Console
http://deba:7001/console
Oracle Enterprise Manager
http://deba:7001/em
Business Intelligence Enterprise Edition
http://deba:9704/analytics
Business Intelligence Publisher
http://deba:9704/xmlpserver
Real-Time Decisions
http://deba:9704/ui

Step 14: After the installation concludes , Weblogic Server and BI Server started , IE browser window opens automatically with the homepage of Oracle Business Intelligence instance .Logging in using the weblogic server User name and password given at Step 8 .

Voici … OBIEE11g installation has been completed successfully .