Introduction to Oracle Business Intelligence Discoverer

Start Here

Get in touch with a
TriCore Solutions specialist

Blog | May 17, 2017

Introduction to Oracle Business Intelligence Discoverer

In the two part blog series, I will cover the steps required to install/upgrade Discoverer within an existing EBS R12 instance. In part one I will discuss about the installation of various software required for Discoverer 11.1.1.7 upgrade. Click to read Part 2.

Introduction: 
Oracle Business Intelligence Discoverer is a tool-set for ad hoc querying, reporting, data analysis and Web-publishing for the Oracle Database environment. Discoverer 11.1.1.7 is a terminal discoverer version. In the two part blog series, I will cover the steps required to install/upgrade Discoverer within an existing EBS R12 instance. In part one I will discuss about the installation of various software required for Discoverer 11.1.1.7 upgrade. 

Note**: Discoverer 11g (11.1.1.7) is now certified with Oracle E-Business Suite Release.  Discoverer 11.1.1.7 is part of Oracle Fusion Middleware 11g Release 1 Version 11.1.1.7.0, also known as FMW 11gR1 Patchset 6. 

Certified E-Business Suite releases are:

  • EBS Release 11i 11.5.10.2 + ATG RUP 7 and higher
  • EBS Release 12.0.6 and higher
  • EBS Release 12.1.1 and higher 

Certification information:

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

http://www.oracle.com/technetwork/middleware/downloads/fmw-11gr1certmatrix.xls 

Only till RHEL 6 is supported with Discoverer 11.1.1.6.0 and 11.1.1.7.0 (terminal Discoverer version). 

Referenced Oracle notes:

Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12 (Doc ID 1074326.1)

The following software should be downloaded.

  • Weblogic 10.3.5/10.3.6 (Oracle Fusion Middleware 11.1.1.7.0 is certified with WebLogic Server 10.3.5 and 10.3.6)
  • Oracle Portal, Forms, Reports and Discoverer 11g 11.1.1.2
  • Oracle Portal, Forms, Reports and Discoverer 11g Patch Set 6 (11.1.1.7.0) (patch id 16471668)
  • Repository Creation Utility for creating the database schemas 

Detailed steps: 

JDK Installation
Ensure you are not using the default JDK (for 64bit OS). In our case we have used JDK 1.7.0_07 

WebLogic Installation -- Oracle WebLogic Server 11gR1 (10.3.6)

Below eg for 64 bit install. 

Step 1 -- Start the installer using below command

<JDK_PATH>/bin/java -d64 -jar -Djava.io.tmpdir=<temp_dir_loc> ./wls1036_generic.jar -log=<loc/filename>

Step 2 -- Click next on the welcome screen

Step 3 -- Create a new middleware home – specify the location

Step 4 -- Provide Oracle support credentials (If required)

Step 5 -- Choose install type -- Typical/Custom -- Preferred Typical

Step 6 -- select local JDK installed

Step 7 -- Choose Product Installation Directories -- Specify Weblogic server location & Oracle Coherence location

Step 8 -- Installation summary -- review the installation summary/size.

Step 9 -- Review the installation log for progress and completion.

Step 10 -- Press done after installation completed.


oracle weblogic installer
oracle discoverer

Download latest RCU software (Around 350MB) and run the same this will create three new tablespaces and two new users

(This requires to store Metadata for Middleware/Discoverer, Not related to actual EULs)

 

Step 1 -- Click next on the welcome screen.

Step 2 -- Create Repository -- Choose create

Step 3 -- Database connection Details -- Provide the database connection details

Step 4 -- Select Components -- Select create new prefix -- Provide the prefix name (select the component, we selected Discoverer under Portal & BI)

Step 5 -- Schema Password – Enter the passwords here.

Step 6 -- Map Tablespaces -- Ensure correct Default & Temp tablespaces are showing, else we can modify.

Step 7 -- Summary -- Review the summary and click on create.

Step 8 -- Completion Summary

oracle db map tablespaces

Discoverer Installation 11.1.1.2

Step 1 -- Start the run installer (you can also use -ignoreSysPreReqs)

Step 2 -- Click next on the welcome screen

Step 3 -- Select install type -- Install Software -- Do not Configure

Step 4 -- Specify Installation Location -- Specify the location for Oracle Middleware Home & Oracle Home Directory

Step 5 -- Specify Security Updates -- Provide oracle support details.

Step 6 -- Installation Summary -- Review the summary and click on Install

Step 7 -- Installation Progress -- review the logs for installation progress (Run root.sh when prompted)

Step 8 -- Installation complete -- review the details and click on Finish

complete oracle discoverer installation

Upgrade Discoverer 11.1.1.2 Installation to 11.1.1.7

Step 1 -- Start the run installer

Step 2 -- Click Next on the welcome screen

Step 3 -- Specify Installation Location -- Provide details of Middleware home & directory where Discoverer is already installed (above location where we installed 11.1.1.2).

Step 4 -- Specify Security updates -- Provide Oracle support details.

Step 5 -- Installation Summary -- Review the summary and click on Install

Step 6 -- Installation Progress -- review the logs for installation progress (Run root.sh when prompted)

Step 7 -- Installation complete -- review the details and click on Finish.

 oracle fusion middleware support

Run 'config.sh' to configure the Disco instance 

Step 1 -- Run config.sh

Step 2 -- Click next on the welcome screen

Step 3 -- Select Domain -- Choose create domain provide username -- weblogic, password & Domain name

Step 4 -- Specify Security Updates -- Provide Oracle support details.

Step 5 -- Specify Installation Location -- Provide Weblogic server location, Oracle instance location and Oracle instance name

Step 6 -- Configure Components -- select the components (We choose for Oracle Discoverer)

Step 7 -- Configure ports -- Auto port config/Specify ports using config file -- We selected Auto port config

Step 8 -- Specify Schema -- Provide the connection string & Schema details (created using rcu)

Step 9 -- Specify Application OID -- Provide the hostname, port, username & password (in case you are using OID, else deselect Use Application level identity Store).

Step 10 -- Installation Summary -- Review the summary and click on configure

Step 11 -- Configuration Progress -- Review the logs/status tab on the installer screen for progress, click next once complete

Step 12 -- Installation complete -- review the details and click on Finish.

oracle idm middleware support

Conclusion: Using the above information you can install 11.1.1.7 and various required components on RHEL 6. Please note you can review part 2 of the blog for more information on how to configure the discoverer instance with Oracle applications R12 instances. For any questions on the topic click below:

Ask Abhishek