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 the ‘OBIEE 11g Installations’ Category

Installing OBIEE 11g Bundle Patch 11.1.1.7.140715 on Windows

Posted by Santosh Kumar Gidadmani on October 17, 2014

The installation of the bundle patch 11.1.1.7.140715 is similar to 11.1.1.7.131017.

Patch 18818588 is the top-level patch and it contains all of the cumulative component patches.

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

Download the patch and copy 18818588 file into D:OBIEE11g_HOMEOracle_BI118818588

And unzip all the files under 18818588 directory.

Set variables as below

Check for patch conflicts by entering the following command: opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Installation Instructions

Unzip all the sub folders under main patch folder

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, navigate to each sub directory and type opatch apply

I have applied all at once.

If you have updated old patch like 17300417, it will roll back and apply new patches.

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:OBIEE11gOracle_BI1clientsbipublisherrepositoryTools to

D:OBIEE11guser_projectsdomainsbifoundation_domainconfigbipublisherrepositoryTools

Remove the jsp_servlet subdirectory associated with Oracle BI Publisher (if it exists), as follows:

D:OBIEE11g_HOMEuser_projectsdomainsbifoundation_domainserversAdminServertmp_WL_userbipublisher_11.1.1gyyvtujsp_servlet

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

Thanks,

Santosh

Advertisements

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

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

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

OBIEE11g – Import Data – Connection Failed Error

Posted by Santosh Kumar Gidadmani on May 12, 2012

If you get “The connection has failed” error while trying to import data from the database using OCI call interface in RPD, perform the below steps.

1. Add the tnsnames.ora file in the BI Home Directory
Ensure, you add all the data source tns entry details in the tnsnames.ora file
Copy the tnsnames.ora file from Oracle Home (Root directory: \App\User\Product\Network\Admin) and paste the file to the below location in OBIEE11g directory
Root directory: \OBIEE11g\Oracle_BI1\network\admin and
Root directory: \OBIEE11g\oracle_common\admin

2. Add the tnsnames file location path in User.cmd file
Add the tnsnames file location path from one of the above location in the user.cmd file. The user.cmd file is found in the below location
Root directory: \OBIEE11g\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

Now, it should work. Still if you are unable to get the data, close your RPD and try it.
Restart the services if RPD is still not importing data.

– Santosh

Posted in OBIEE 11g, OBIEE 11g Errors, OBIEE 11g Installations, OBIEE 11g RPD | 6 Comments »

 
%d bloggers like this: