Applying OBIEE 11.1.1.6.5 Patches to Windows Server Environment

Oracle  released a new patch set for OBIEE 11g – 11.1.1.6.5. The patch set can be downloaded from Oracle Support. This patch set is available for Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, 11.1.1.6.2 BP1 and 11.1.1.6.4. This new patch set comprises of following patches:

• Patch 14696072 (1 of 7) Oracle Business Intelligence Installer. (generic)
• Patch 14733356 (2 of 7) Oracle Real Time Decisions. (generic)
• Patch 14678543 (3 of 7) Oracle Business Intelligence Publisher. (generic)
• Patch 14733390 (4 of 7) Oracle Business Intelligence ADF Components. (generic)
• Patch 14733413 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x. (port specific)
• Patch 14665284 (6 of 7) Oracle Business Intelligence. (port specific)
• Patch 14733370 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer (generic)

The instructions to apply the above patches are identical, and are contained in the readme file for patch 14696072.

Here are the steps to apply the patches to a Windows 64 bit install of OBIEE:
Step 1:Back up the OBIEE install and shutdown all OBIEE processes including weblogic.

Step 2: Download the zipped patch files from Oracle Support.

Download patch files

Step 3: Unzip the files and put them in your {OBIEE_HOME}/Oracle_BI1 folder. Example: C:\OBIEE11g\Oracle_BI1

Unzip the files and put them in your {OBIEE_HOME}/Oracle_BI1 folder

Step 4: Clear the files that are associated with the Oracle BI EE Catalog Manager binary cache. Go to {ORACLE_HOME}\Oracle_BI1\bifoundation\web\catalogmanager\configuration\ and remove the following files if they exist:

• org.eclipse.osgi
• org.eclipse.equinox.app

Step 5: Open a Command window and before applying the patches. Ensure you are in the {ORACLE_HOME}\Oracle_BI1 folder:

Set environment variables

set ORACLE_HOME=C:\obiee11g\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%

Step 6: Apply the sever patches in the following order:

C:\obiee11g\Oracle_BI1>cd 14696072

C:\obiee11g\Oracle_BI1\14696072>opatch apply
OPatch succeeded.

C:\obiee11g\Oracle_BI1\14696072>cd ../14733356

C:\obiee11g\Oracle_BI1\14733356>opatch apply
OPatch succeeded.

C:\obiee11g\Oracle_BI1\14733356>cd ../14678543

C:\obiee11g\Oracle_BI1\14678543>opatch apply
OPatch succeeded.

C:\obiee11g\Oracle_BI1\14678543>cd ../14733390

C:\obiee11g\Oracle_BI1\14733390>opatch apply
OPatch succeeded.

C:\obiee11g\Oracle_BI1\14733390>cd ../14733413

C:\obiee11g\Oracle_BI1\14733413>opatch apply
OPatch completed with warnings.

C:\obiee11g\Oracle_BI1\14733413>cd ../14665284

C:\obiee11g\Oracle_BI1\14665284>opatch apply
OPatch completed with warnings.

C:\obiee11g\Oracle_BI1\14665284>cd ../14733370

C:\obiee11g\Oracle_BI1\14733370>opatch apply
OPatch succeeded.

Step 7: Check the patches have been applied. Confirm that all the Oracle BI 11.1.1.6.5 patches shown above appear in the list of applied patches (along with any other patches that have previously been applied to the BI System).

C:\obiee11g\Oracle_BI1>opatch lsinventory

Step 8: Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files from the ORACLE_BI_HOME/clients/bipublisher/repository/Tools directory to the MW_HOME/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools directory.

Step 9: Start up OBIEE services and validate the patch has been applied.

Validate the patch has been applied.

NOTE:  please clear the browser cache before you login and test the new patchset.

This Patches Applying process is same even for the next pacthes released and   till 11.1.1.6.12.

Thanks

Saleem Syed (SS)