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

    • 337,412 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for August, 2014

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

Posted in OBIEE 11g, OBIEE 11g Installations | Leave a Comment »

Reset Weblogic Password in OBIEE 11g

Posted by Santosh Kumar Gidadmani on August 6, 2014

If you have changed your weblogic password and want to reset the same during the OBIEE services star up, following the below process.

1) Navigate to the below locations of your home OBIEE directory.
D:\OBIEE11g_Home\user_projects\domains\bifoundation_domain\servers\AdminServer\security (Weblogic Server)
D:\OBIEE11g_Home\user_projects\domains\bifoundation_domain\servers\bi_server1\security (Managed Server)

2) Rename the boot.properties file to any name.

3) Restart the services, provide the weblogic id and password.

Note: The weblogic user id and password will be saved in the boot.properties file.

Thanks,
Santosh

Posted in OBIEE 11g, OBIEE 11g Errors | Leave a Comment »

 
%d bloggers like this: