OBIEE BUNDLE PATCH 11.1.1.7.140114

Patch 17886497: BI BUNDLE PATCH 11.1.1.7.140114

The latest patchset for OBIEE 11.1.1.7 has just come out.

The Oracle BI EE Suite Bundle Patch 11.1.1.7.140114 under the top-level patch 17886497 consists of the following component patches:

Patch	Abstract
16913445	Oracle Business Intelligence Installer (BIINST)
17922352	Oracle Business Intelligence Publisher (BIP)
17300417	Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
17922552	Oracle Business Intelligence Server (BISERVER)
17922596	Oracle Business Intelligence Presentation Services (BIPS)
17300045	Oracle Real-Time Decisions (RTD)
16997936	Oracle Business Intelligence ADF Components (BIADFCOMPS)
17922577	Oracle Business Intelligence Platform Client Installers and MapViewer

This weighs in at a hefty 2.5Gb and includes 8 patches

Don't forget to clear cache and read the readme documentation.

OBIEE version 11.1.1.7.131017 has been released

The Business Intelligence Enterprise Edition 11.1.1.7.131017 patch set has been released, and is available to download from My Oracle Support (https:\\support.oracle.com).

Per the patch readme:
This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.7.0 and 11.1.1.7.1.

It is also available for Exalytics customers who have applied the Exalytics PS3 patch.

Patch 17530796 - OBIEE BUNDLE PATCH 11.1.1.7.131017 (Patch) is comprised of the following patches, which are not available separately:

    Patch 16913445 - Patch 11.1.1.7.131017 (1 of 8) Oracle Business Intelligence Installer (BIINST)
    Patch 17463314 - Patch 11.1.1.7.131017 (2 of 8) Oracle Business Intelligence Publisher (BIP)
    Patch 17300417 - Patch 11.1.1.7.131017 (3 of 8) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM))
    Patch 17463395 - Patch 11.1.1.7.131017 (4 of 8) Oracle Business Intelligence Server (BIS)
    Patch 17463376 - Patch 11.1.1.7.131017 (5 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 17300045 - Patch 11.1.1.7.131017 (6 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 16997936 - Patch 11.1.1.7.131017 (7 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 17463403 - Patch 11.1.1.7.131017 (8 of 8) Oracle Business Intelligence Platform Client Installers and MapViewer

Also you must download:

Patch 16569379 - Dynamic Monitoring Service patch

The instructions to apply the bundle patch are given in the patch readme along with some important notes if you are upgrading from 11.1.1.6.x versions.

The new functionality in this patch includes:

    Support for Microsoft Internet Explorer 10
    Support for Oracle BI Mobile App Designer
    Support for improved exporting functionality into Microsoft Excel
For more information please refer to document:
OBIEE 11g 11.1.1.7.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics (Doc ID 1595219.1)
In addition we strongly recommend you review this document:
OBIEE Suite Bundle Patches (Doc ID 1591422.1), which explains the new naming convention, the strategy behind bundle patches and other interesting facts about OBIEE patching. Please take some time to review it.

OBIEE 11g 11.1.1.7.1 is Available

The Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.1 patch set has been released.  This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.7.0. 

Now available to download from My Oracle Support  

Patch 16556157: OBIEE BUNDLE PATCH 11.1.1.7.1

This single OBIEE 11.1.1.7.1 patch set download is comprised of the following:

• 1 of 6 Oracle Business Intelligence Installer (BIINST)
• 2 of 6 Oracle Business Intelligence Publisher (BIP)
• 3 of 6 EPM Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM))
• 4 of 6 Oracle Business Intelligence Server (BIS)
• 5 of 6 Oracle Business Intelligence Presentation Services (BIPS)
• 6 of 6 Oracle Business Intelligence Platform Client Installers and MapViewer

Ensure to review the readme file on the Installer download for important installation instructions
The following is also required to be downloaded and applied:
Patch 16569379: Dynamic Monitoring Service patch

Additional important notes are available in  the following document:
Document 1566124.1: OBIEE 11g 11.1.1.7.1 is Available for Oracle Business Intelligence Enterprise Edition

Upgrade a Simple install to 11.1.1.7

Upgrading a simple install to 11.1.1.7 from 11.1.1.6.2 BP1

Following on from the previous article on upgrading an enterprise install of OBIEE here's how to do the same for a simple install.

Not as straightforward as the upgrade of the enterprise install where it is all wizard driven. For this upgrade you can start out as for the enterprise upgrade for the first couple of steps and then do the rest manually.

As with the enterprise upgrade do a software only install specifying the middleware home that you want patched

Then run the patch set assistant for the MDS and BIPLATFORM schemas. If you do this step manually make sure that you upgrade MDS first.

Now instead of running the configuration wizard, which runs all the steps for you, you will run the following manually.

Assume the following: 

the simple install is in the directory C:\obiee11g on windows.
our simple install is version 11.1.1.6.2 BP1

1. Upgrade the system components.

cd C:\obiee11g\user_projects\domains\bifoundation_domain\bin
startweblogic.cmd
(once the server is in the RUNNING state)
set ORACLE_HOME=C:\obiee11g\Oracle_BI1
cd C:\obiee11g\instances\instance1\bin
opmnctl startall
cd c:\obiee11g\Oracle_BI1\opmn\bin
--note replace localhost with your servername if appropriate
run 
upgradenonj2eeapp.bat -oracleInstance c:\obiee11g\instances\instance1 -adminHost localhost -adminPort 7001 -adminUsername weblogic

Unregister instance...

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

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

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

Redeploying NonJ2EEManagement Application...weblogic.Deployer invoked with optio
ns:  -adminurl V01228730:7001 -username weblogic -name NonJ2EEManagement -source
 C:\obiee11g\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear -redeploy -uploa
d -noexit
<23-Apr-2013 14:12:42 o'clock BST> <Info> <J2EE Deployment SPI> <BEA-260121> <In
itiating redeploy operation for application, NonJ2EEManagement [archive: C:\obie
e11g\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear], to configured targets.
>
Task 0 initiated: [Deployer:149026]deploy application NonJ2EEManagement on Admin
Server.
Task 0 completed: [Deployer:149026]deploy application NonJ2EEManagement on Admin
Server.
Target state: redeploy completed on Server AdminServer

Done
Command succeeded.
re-register instance...

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

Registering instance
Command succeeded.
Successfully upgraded NonJ2EEManagement.ear and the registeration.
C:\obiee11g\instances\instance1\bin>

2. update the shared libraries and security.

cd C:\obiee11g\user_projects\domains\bifoundation_domain\bin
stopWeblogic.cmd
cd C:\obiee11g\oracle_common\common\bin
wlst
upgradeJRF('c:/obiee11g/user_projects/domains/bifoundation_domain')
upgradeOpss(jpsConfig="c:/obiee11g/user_projects/domains/bifoundation_domain/config/fmwconfig/jps-config.xml", jaznData="c:/obiee11g/oracle_common/modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml")
exit()

wls:/offline> upgradeJRF('c:/obiee11g/user_projects/domains/bifoundation_domain'
)
upgradeJRF: skip, JRF is up-to-date.
wls:/offline>upgradeOpss(jpsConfig="c:/obiee11g/user_projects/domains/bifoundati
on_domain/config/fmwconfig/jps-config.xml", jaznData="c:/obiee11g/oracle_common/
modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml")
{upgradeJseStoreType=null, auditStore=null, password=null, user=null, url=null,
jdbcDriver=null, jaznData=c:/obiee11g/oracle_common/modules/oracle.jps_11.1.1/do
main_config/system-jazn-data.xml, jpsConfig=c:/obiee11g/user_projects/domains/bi
foundation_domain/config/fmwconfig/jps-config.xml}
Starting upgrade of opss configuration and security stores.
WLS ManagedService is not up running. Fall back to use system properties for con
figuration.
23-Apr-2013 14:28:05 oracle.security.jps.wls.JpsWlsPlatformFactory$2 run
WARNING: Cannot get server log directory. Reason: Cannot get audit log path by e
nvironment setting..
23-Apr-2013 14:28:07 oracle.security.jps.wls.JpsWlsPlatformFactory$2 run
WARNING: Cannot get server log directory. Reason: Cannot get audit log path by e
nvironment setting..
23-Apr-2013 14:28:07 oracle.security.jps.internal.tools.utility.JpsUtilMigration
AuditStoreImpl migrateAuditStoreData
INFO: Migration of Audit Store data in progress.....
23-Apr-2013 14:28:07 oracle.security.jps.internal.tools.utility.JpsUtilMigration
AuditStoreImpl migrateAuditStoreData
INFO: Migration of Audit Store data completed, Time taken for migration is 00:00
:00
23-Apr-2013 14:28:08 oracle.security.jps.internal.tools.utility.destination.apib
ased.JpsDstPolicy <init>
WARNING: No identity store associated with policy store found.
23-Apr-2013 14:28:09 oracle.security.jps.internal.tools.utility.destination.apib
ased.JpsDstPolicy migrateDataInternal
INFO: Migration of Admin Role Members started
23-Apr-2013 14:28:09 oracle.security.jps.internal.tools.utility.destination.apib
ased.JpsDstPolicy migrateDataInternal
INFO: Migration of Admin Role Members completed in 00:00:00
Upgrade of opss configuration and security stores is done.
wls:/offline>

3. Upgrade the catalog.

edit the instancecofig.xml
and replace the "false" with "true" in the upgradeandexit tag.


cd C:\oracle\Middleware\instances\instance1\bin\

opmnctl startproc ias-component=coreapplication_obips1

then set the instanceconfig.xml back to "false"

opmnctl stopproc ias-component=coreapplication_obips1

4. Start node manager, adminserver, managed server and OPMN.

OBIEE 11.1.1.7 Upgrade

I have just upgraded a test server from OBIEE 11.1.1.6.2 BP1 to the latest and greatest version 11.1.1.7

After past experiences of upgrade I was half expecting to have no nails left and be pulling my hair out, but this time it went right.

Note: If you are running a simple install, ie. everything runs from port 7001, this whole process will not work for you, and at some stage in the next week or two I'll document exactly what you have to do.

This is for the Enterprise Install only.

Software Only Installer

1. Shut down all BI processes, OPMN and node manager.
2. Run the installer and choose Software only install.
    The installer will do a few checks.
    Find the default middleware home
    Find the weblogic install
    and finally start the install.

So that is fairly painless and in about 20 minutes or so you have updated binaries.

Patch Set Assistant

1. Navigate to {middleware home}/oracle_common/bin directory

2. Run psa.bat
3. Select the component to upgrade. (Oracle Business Intelligence)
4. Then, much like most of the GUI installers, fill in the connection details of the MDS and BIPLATFORM schemas.

5. Once you verify you have backed up and are running an appropriate version of the database

6. You are asked to upgrade.

Start Weblogic

Now start the Node Manager Service 

and, navigate to {middleware_home}\user_projects\domains\bifoundation_domain\bin

and run startWebLogic.cmd

When the server is in the running state

Configuration Assistant

1. Start the configuration assistant

   {middleware_home}\Oracle_BI1\bin and run config.bat

2. Select the upgrade option

3. Fill in the details to connect to the admin server (usually 7001)

4. And off it goes.

The configuration assistant will do stopping and starting of all the appropriate services at various times and leave you with a updated OBIEE 11.1.1.7 

Compared to the previous updates this was easy, but be warned, updating a simple install means that you have to do all the steps covered by the configuration assistant manually.

I'm just getting to grips with the new features and visualisations, and hope to bring you more over the coming weeks.

Update
Here are the manual steps for upgrading a simple install. Please keep me informed of any issues you encounter.

OBIEE 11.1.1.5.4 bundle patch is now available for download

Oracle Business Intelligence Enterprise Edition - OBIEE 11.1.1.5.4 (a.k.a 11.1.1.5.0BP4) bundle patch is now available for download from My Oracle Support (https://support.oracle.com). The OBIEE 11.1.1.5.4 bundle patch includes 40 bug fixes.

It is cumulative, so it includes everything in 11.1.1.5.0PS1, 11.1.1.5.0BP2 and 11.1.1.5.0BP3.

Please note that this release is only recommended for BI customers.

This patch is available for these supported platforms:

Microsoft Windows (32-bit)

Linux x86 (32-bit)

Microsoft Windows x64 (64-bit)

Linux x86-64 (64-bit)

Oracle Solaris on SPARC (64-bit)

Oracle Solaris on x86-64 (64-bit)

IBM AIX PPC (64-bit)

HPUX- IA (64-bit)

Patching support for OBIEE 10.1.3.4.1 ends on 30th September

Patching support for OBIEE 10.1.3.4.1 ends on 30th September 2012.

After September, there will be no more one-off patches available for OBIEE 10.1.3.4.1 or lower versions. If you wish to continue receiving one-off patches, should the situation arise, please apply the OBIEE 10.1.3.4.2 patch set.

Patching 11.1.1.6 to 11.1.1.6.2

The patch for upgrading to 11.1.1.6.2 is available. Details here.

Pretty much a straightforward upgrade, though a few things to watch out for:
1. Set your environment variables correctly

       set ORACLE_HOME=C:\mwhome\Oracle_BI1
       set PATH=%ORACLE_HOME%\bin;%PATH%
       set JAVA_HOME=%ORACLE_HOME%\jdk
       set PATH=%JAVA_HOME%\bin;%PATH%
       set PATH=%ORACLE_HOME%\OPatch;%PATH%

2. Make sure you run opatch from the correct directory

Open a command window (with the correct environment variables set - see 1) in the Oracle_BI1 directory.

3. When you come to Part 2. JDeveloper patch 13952743

Unpack the patch into oracle_common.
Change directory to oracle_common
Using the environment variables set in step 1 run

opatch apply 13952743 -OH C:\mwhome\oracle_common

This will patch the oracle_common directory, otherwise the patch reports nothing to upgrade.