OBIEE 11G - In-Place Upgrade - Moving from to

In Progress

1 - About

Patching involves copying a small collection of files over an existing installation. A patch is normally associated with a particular version of an Oracle product and involves updating from one minor version of the product to a newer minor version of the same product (for example, from version to version

2 - New Features

New Features in Oracle Business Intelligence 11g Release 1 (

2.1 - Installation

  • The separate, standalone installer for the Oracle Business Intelligence client tools (previously included only Oracle Business Intelligence Administration Tool and Job Manager), now also installs Oracle Business Intelligence Catalog Manager (online mode). The client installer is supported on computers running 32- and 64-bit Windows operating systems only.
  • The ability to install BI Composer by extending an Oracle WebLogic Server domain to include BI Composer run-time implementation shared libraries, and configuring Oracle BI Presentation Services configuration file.

4 - Pre-Patching Tasks

4.1 - Backup and services

  • Backup all (Middleware Home, Domain Home and Oracle Instances)
  • Stops all server and process (WebLogic Servers, Node Manager, OPMN)

net stop "beasvc bifoundation_domain_bi_server1" -- weblogic bi server
net stop "beasvc bifoundation_domain_AdminServer" -- weblogic Admin server
net stop "OracleProcessManager_instance1" -- OPMN
net stop "Oracle WebLogic NodeManager (E_MiddelwareHome_wlserver_10.3)" -- Node Manager

Verify that the process (beasvc.exe, …) are not running.

4.2 - Patch Oracle WebLogic Server

Oracle WebLogic Server must be to the latest version (10.3.5). If Oracle WebLogic Server is already installed on your system, make sure you have patched Oracle WebLogic Server to either version 10.3.6 or 10.3.5 (both are supported in Release

Check your Weblogic Version and if the version is not 10.3.6 or 10.3.5, you have to patch the weblogic server.

5 - Patching

5.1 - Installer

Download the product installer. The product installers for Oracle Business Intelligence can be used to patch an existing Oracle Fusion Middleware installation.

These installers also offer a configuration option. When using them to apply a patch set, you must select the option to install the software only. Do not select the option to configure the software. The domain you are patching is already configured and does not require any reconfiguration.

The product installer will upgrade the weblogic domain.

  • Welcome
  • My Oracle Support Update
  • Installation Type: Software Only Update
  • Prerequisites Check
  • Installation Location

  • Install

Installation Successful. 
Starting execution of post install scripts 
Applying one off patches 
Execution of post install scripts completed

6 - Post-Patching Tasks

6.1 - Upgrading the database repository schema MDS and BIPLATFORMK

Schemas That Require Updating for the Latest Release

  • Start Psa in graphique mode: E:\MiddelwareHome\Oracle_BI1\bin>psa -help
  • Welcome
  • Select Component: Oracle BI

  • Prerequisites: Check all
  • Schema information: Enter the information for the MDS and the BIPLATFORM schema

  • Examine > Upgrade Summary > Upgrade Progress > End of Upgrade

Recompile all objects:

SET ORACLE_HOME=E:\app\Administrator\product\11.2.0\dbhome_1
sqlplus / as sysdba
[email protected]>@?/rdbms/admin/utlrp.sql
[email protected]>SELECT owner, object_name FROM all_objects WHERE status='INVALID';
no rows selected

Verify the repository version


OWNER                          VERSION                        STATUS      U
------------------------------ ------------------------------ ----------- -
DEV_BIPLATFORM                            VALID       Y
DEV_MDS                                   VALID       Y

6.2 - Upgrading System Components


  • The Administration Server. <note warning>Don't start the Windows Service because it starts also the components.</note>

cd E:\MiddelwareHome\user_projects\domains\bifoundation_domain\bin

E:\MiddelwareHome\Oracle_BI1\bin>opmnctl start

E:\MiddelwareHome\Oracle_BI1\bin>opmnctl status

Processes in Instance: instance1
ias-component                    | process-type       |     pid | status
coreapplication_obiccs1          | OracleBIClusterCo~ |     N/A | Down
coreapplication_obisch1          | OracleBIScheduler~ |     N/A | Down
coreapplication_obijh1           | OracleBIJavaHostC~ |     N/A | Down
coreapplication_obips1           | OracleBIPresentat~ |     N/A | Down
coreapplication_obis1            | OracleBIServerCom~ |     N/A | Down

  • script: ORACLE_HOME/opmn/bin/ (on UNIX operating systems) or ORACLE_HOME\opmn\bin\upgradenonj2eeapp.bat (on Windows operating systems). Syntax

set ORACLE_HOME="E:\MiddelwareHome\Oracle_BI1"
cd %ORACLE_HOME%\opmn\bin
   -oracleInstance E:\MiddelwareHome\instances\instance1
   -adminHost localhost
   -adminPort 7001
   -adminUsername weblogic


E:\MiddelwareHome\Oracle_BI1\opmn\bin>upgradenonj2eeapp.bat -oracleInstance E:\M
iddelwareHome\instances\instance1 -adminHost localhost -adminPort 7001 -adminUse
rname weblogic
Unregister instance...

Command requires login to weblogic admin server (localhost):
  Username: weblogic

Unregistering instance
Command succeeded.
redeploy NonJ2EEManagement.ear...

Command requires login to weblogic admin server (localhost):
  Username: weblogic

Redeploying NonJ2EEManagement Application...weblogic.Deployer invoked with optio
ns:  -adminurl localhost:7001 -username weblogic -name NonJ2EEManagement -source
 E:\MiddelwareHome\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear -redeploy
-upload -noexit
<23-mrt-2012 15:08:45 uur PDT> <Info> <J2EE Deployment SPI> <BEA-260121> <Initia
ting redeploy operation for application, NonJ2EEManagement [archive: E:\Middelwa
reHome\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear], to configured target
Command failed: NonJ2EEManagement Applicationdeployment failed.
Details are logged in E:\MiddelwareHome\instances\instance1\diagnostics\logs\OPM

opmnctl redeploy: failed.

opmnctl redeploy -oracleInstance E:\MiddelwareHome\instances\instance1 -adminHost localhost -adminPort 7001 -adminUsername weblogic 

7 - Support

7.1 - Installation hangs on "An application server must be installed"

You must not concatenate the disks content in one map but let them as is to start the installer.

7.2 - version of oracle.jdk in the shiphome <> version of ORACLE_BI_HOME

[2012-03-23T11:57:50.572-07:00] [as] [NOTIFICATION] [] [] [tid: 13] 
[ecid: 0000JP0urqP5yW^5xV_AiW1FRCU0000004,0] 
Version of oracle.jdk in the oracle home: E:\MiddelwareHome\Oracle_BI1 is:
[2012-03-23T11:57:50.572-07:00] [as] [NOTIFICATION] [] [] [tid: 13] 
[ecid: 0000JP0urqP5yW^5xV_AiW1FRCU0000004,0] : 
E:\MiddelwareHome\Oracle_BI1 is: < the version of oracle.jdk in the shiphome: 
\\tsclient\E\kiosque\obiee\11.6\bi_windows_x86_111160_32\bishiphome is:

7.3 - Application List with their version number

The -adminurl option (http://localhost:7001) of the deployer (weblogic.Deployer) is not needed if your run it from the server.

-- Set the weblogic environment
-- Start the deployer
java weblogic.Deployer  -user weblogic -password weblogic12 -listapps
weblogic.Deployer invoked with options:  -user weblogic -listapps
 analyticsRes [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION> [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION>
 oracle.dconfig-infra [LibSpecVersion=11,LibImplVersion=] <ACTIVE VERSION>
 FMW Welcome Page Application [Version=] <ACTIVE VERSION>
 OracleRTD [Version=]
 orai18n-adf [LibSpecVersion=11,LibImplVersion=] <ACTIVE VERSION>
 DMS Application [Version=] <ACTIVE VERSION> [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION>
 bioffice [Version=11.1.1]
 oracle.biopmn [Version=11.1.1] <ACTIVE VERSION>
 mapviewer [Version=11.1.1] [LibSpecVersion=11.1.1,LibImplVersion=0.1] <ACTIVE VERSION>
 oracle.applcore.model [LibSpecVersion=0.1,LibImplVersion=]
 oracle.wsm.seedpolicies [LibSpecVersion=11.1.1,LibImplVersion=11.1.1] <ACTIVE VERSION>
 ohw-uix [LibSpecVersion=5,LibImplVersion=5.0] <ACTIVE VERSION>
 oracle.bpm.mgmt [LibSpecVersion=11.1.1,LibImplVersion=11.1.1] <ACTIVE VERSION> [LibSpecVersion=11.1.1,LibImplVersion=11.1.1] <ACTIVE VERSION>
 oracle.adf.desktopintegration.model [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION>
 bip-shared-libraries [Version=11.1.1]
 oracle.webcenter.composer [LibSpecVersion=11.1.1,LibImplVersion=11.1.1] <ACTIVE VERSION>
 bipublisher [Version=]
 oracle.adf.dconfigbeans [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION>
 ESSAPP [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION>
 jsf [LibSpecVersion=1.2,LibImplVersion=] <ACTIVE VERSION>
 jstl [LibSpecVersion=1.2,LibImplVersion=] <ACTIVE VERSION>
 bilocaladmin [Version=11.1.1]
 UIX [LibSpecVersion=11,LibImplVersion=] <ACTIVE VERSION> [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION> [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION>
 bisearch [Version=11.1.1]
 bimiddleware [Version=11.1.1]
 ActionSamples [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION>
 bijdbc [Version=]
 oracle.ess [LibSpecVersion=11,LibImplVersion=]
 ohw-rcf [LibSpecVersion=5,LibImplVersion=5.0] <ACTIVE VERSION>
 biadminutils [Version=11.1.1] <ACTIVE VERSION>
 oracle.pwdgen [LibSpecVersion=11.1.1,LibImplVersion=] <ACTIVE VERSION> [Version=11.1.1] <ACTIVE VERSION>
 oracle.adf.desktopintegration [LibSpecVersion=1.0,LibImplVersion=] <ACTIVE VERSION>
 oracle.ess.client [LibSpecVersion=11,LibImplVersion=]
 analytics [Version=11.1.1]
 bijdbc [Version=11.1.1]
 biadminservices [Version=11.1.1] <ACTIVE VERSION>
 biofficeclient [Version=11.1.1] [LibSpecVersion=11.1.1,LibImplVersion=11.1.1] <ACTIVE VERSION> [LibSpecVersion=11.1.1,LibImplVersion=0.1] <ACTIVE VERSION>
 wsm-pm [Version=11.1.1] <ACTIVE VERSION>
Number of Applications Found : 59

8 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap