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

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

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 11.1.1.3.0 to version 11.1.1.5.0).

2 - New Features

New Features in Oracle Business Intelligence 11g Release 1 (11.1.1.6)

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.
Advertising

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 11.1.1.6.0)

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

Advertising

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
Advertising

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

[email protected]>SELECT OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY WHERE OWNER IN
('DEV_MDS','DEV_BIPLATFORM');
 
OWNER                          VERSION                        STATUS      U
------------------------------ ------------------------------ ----------- -
DEV_BIPLATFORM                 11.1.1.6.0                     VALID       Y
DEV_MDS                        11.1.1.6.0                     VALID       Y

6.2 - Upgrading System Components

Start:

cd E:\MiddelwareHome\user_projects\domains\bifoundation_domain\bin
startWeblogic.cmd
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/upgradenonj2eeapp.sh (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
upgradenonj2eeapp.bat
   -oracleInstance E:\MiddelwareHome\instances\instance1
   -adminHost localhost
   -adminPort 7001
   -adminUsername weblogic

Result:

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
  Password:

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

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

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
s.>
Done
Command failed: NonJ2EEManagement Applicationdeployment failed.
Details are logged in E:\MiddelwareHome\instances\instance1\diagnostics\logs\OPM
N\opmn\provision.log

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

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
E:\MiddelwareHome\wlserver_10.3\server\bin>setWLSEnv.cmd
-- Start the deployer
java weblogic.Deployer  -user weblogic -password weblogic12 -listapps
weblogic.Deployer invoked with options:  -user weblogic -listapps
 wsil-wls
 analyticsRes
 oracle.bi.adf.webcenter.slib [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 oracle.bi.adf.view.slib [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 oracle.dconfig-infra [LibSpecVersion=11,LibImplVersion=11.1.1.1.0] <ACTIVE VERSION>
 oracle.jrf.system.filter
 FMW Welcome Page Application [Version=11.1.0.0.0] <ACTIVE VERSION>
 OracleRTD [Version=11.1.1.3.0]
 orai18n-adf [LibSpecVersion=11,LibImplVersion=11.1.1.1.0] <ACTIVE VERSION>
 DMS Application [Version=11.1.1.1.0] <ACTIVE VERSION>
 adf.oracle.domain [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 bioffice [Version=11.1.1]
 oracle.biopmn [Version=11.1.1] <ACTIVE VERSION>
 mapviewer [Version=11.1.1]
 oracle.bi.jbips [LibSpecVersion=11.1.1,LibImplVersion=0.1] <ACTIVE VERSION>
 oracle.applcore.model [LibSpecVersion=0.1,LibImplVersion=11.1.1.0.0]
 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>
 oracle.jsp.next [LibSpecVersion=11.1.1,LibImplVersion=11.1.1] <ACTIVE VERSION>
 oracle.adf.desktopintegration.model [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 bip-shared-libraries [Version=11.1.1]
 oracle.webcenter.composer [LibSpecVersion=11.1.1,LibImplVersion=11.1.1] <ACTIVE VERSION>
 bipublisher [Version=11.1.1.3.0]
 oracle.adf.dconfigbeans [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 ESSAPP
 adf.oracle.domain.webapp [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 jsf [LibSpecVersion=1.2,LibImplVersion=1.2.9.0] <ACTIVE VERSION>
 jstl [LibSpecVersion=1.2,LibImplVersion=1.2.0.1] <ACTIVE VERSION>
 bilocaladmin [Version=11.1.1]
 UIX [LibSpecVersion=11,LibImplVersion=11.1.1.1.0] <ACTIVE VERSION>
 adf.oracle.businesseditor [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 oracle.bi.adf.model.slib [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 emcore
 bisearch [Version=11.1.1]
 bimiddleware [Version=11.1.1]
 ActionSamples
 oracle.adf.management [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 bijdbc [Version=11.1.1.3.0]
 oracle.ess [LibSpecVersion=11,LibImplVersion=1.0.0.0.0]
 ohw-rcf [LibSpecVersion=5,LibImplVersion=5.0] <ACTIVE VERSION>
 biadminutils [Version=11.1.1] <ACTIVE VERSION>
 oracle.pwdgen [LibSpecVersion=11.1.1,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 oracle.bi.shared [Version=11.1.1] <ACTIVE VERSION>
 bi.em
 oracle.adf.desktopintegration [LibSpecVersion=1.0,LibImplVersion=11.1.1.2.0] <ACTIVE VERSION>
 oracle.ess.client [LibSpecVersion=11,LibImplVersion=1.0.0.0.0]
 analytics [Version=11.1.1]
 NonJ2EEManagement
 bijdbc [Version=11.1.1]
 biadminservices [Version=11.1.1] <ACTIVE VERSION>
 emai
 biofficeclient [Version=11.1.1]
 oracle.webcenter.skin [LibSpecVersion=11.1.1,LibImplVersion=11.1.1] <ACTIVE VERSION>
 oracle.bi.composer [LibSpecVersion=11.1.1,LibImplVersion=0.1] <ACTIVE VERSION>
 emas
 em
 wsm-pm
 oracle.bi.public [Version=11.1.1] <ACTIVE VERSION>
Number of Applications Found : 59

8 - Documentation / Reference