ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 355,718 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Installing OBIEE 11g Bundle Patch 11.1.1.7.131017 on Windows

Posted by Santosh Kumar Gidadmani on August 17, 2014

Firstly download the Patch from the Oracle site. Patch 17530796 is the top level path and it contains all of the cumulative components patches listed below.

Patches
16913445 – Oracle Business Intelligence Installer (BIINST)
17463314 – Oracle Business Intelligence Publisher (BIP)
17300417 – Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
1746339 – Oracle Business Intelligence Server (BISERVER)
17463376 – Oracle Business Intelligence Presentation Services (BIPS)
17300045 – Oracle Real-Time Decisions (RTD)
16997936 – Oracle Business Intelligence ADF Components (BIADFCOMPS)
17463403 – Oracle Business Intelligence Platform Client Installers and MapViewer

The following new features are available in the Oracle BI EE Suite Bundle Patch 11.1.1.7.131017

  • Support for Microsoft Internet Explorer 10
  • Support for Oracle BI Mobile App Designer
  • Support for Improved Exporting Functionality into Microsoft Excel

Prerequisites

  • Install OBIEE 11.1.1.7 version
  • Back up the OBIEE11g>\bifoundation\server directory.
  • Stop all the OBIEE Services (Web Server, Managed Server and System components servers)
  • Check the Interim Patch conflict detection and resolution
  • Set the ORACL_HOME, PATH and JAVE_HOME environment variables as appropriate for your OS.
  • On window, follow the below steps. If the Oracle BI Home directory is D:\OBIEE11g\Oracle_BI1, then set the environment by entering the below commands:
  • Login using the Admin user
  • Clear the files that are associated with the binary cache for the catalog Manager. On window, check in the below folder D:\OBIEE11g\Oracle_BI1\bifoundation\web\catalogmanager\configuration. If there are org.eclipse.osgi and org.eclipse.equinox.app files, just remove them.
  • If you have not already installed the Dynamic Monitoring Service patch 16569379, then download and unzip the file into the Oracle BI Home directory (D:\OBIEE11g\Oracle_BI1\16569379).

Patch Installation Steps

  1. Copy the Bundle patch in the below folder D:\OBIEE11g\Oracle_BI1\17530796.
  2. Open the CMD command prompt using admin rights and navigate to D:\OBIEE11g\Oracle_BI1\17530796 path and apply the environmental variables.

Patch Installation1

You can apply patch in two ways

  1. Apply patch on all files and the command is opatch napply –skip_duplicate
  2. Apply patch on each file separately.

To apply each patch separately, follow the below steps.

  1. Complete step 1, 2 as stated above
  2. Change the directory to D:\OBIEE11g\Oracle_BI1\17530796\17463314
  3. And enter opatch apply

Patch Installation2

This command will install that patch, to view the patch installed enter opatch lsinventory.

Patch Installation3

I have already installed patch 16913445 and now we have installed patch 17463314.

Apply all patches and check the status by entering opatch lsinventory.

Apply Dynamic Monitoring Service patch 16569379 as below

Patch Installation4

If it asks to shut the oracle instance, shut down the oracle instance, complete the opatch and restart the oracle instance.

Patch Installation5

Post Patch Installation Steps

Check if all the patches have successfully applied by entering opatch lsinventory command.

Copy the BI Publisher Desktop32 and 64 files from D:\OBIEE11g\Oracle_BI1\clients\bipublisher\repository\Tools to

D:\OBIEE11g\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Tools

Start the OBIEE services (Web Server, Managed Server and System components servers)

Open the RPD and click on Help -> About OBIEE

Patch Installation6

You can see the Version has changed to 11.1.1.7.131017 and the patch had installed the latest RPD version which is 326 (before install it was 325).

Open the OBIEE Analytics, click on Administration and you will see the version has changed to 11.1.1.7.131017.

Patch Installation7

Thanks,

Santosh

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: