Thursday Oct 09, 2014

Automating the OBIEE patching process from EM Cloud Control 12c

(in via Senthil)

With Software patching being one of the more work intensive and error prone tasks in your daily business, it is nice to see that there are people constantly working to make this easier, more reliable and less demanding.

OBIEE Development has taken the time to lay out steps to automate the patching process of OBIEE by using Deployment Procedures (DP) that are already available in Enterprise Manager 12c.

A Deployment Procedure (DP) is a sequence of steps and phases, where each phase can contain sequence of steps. The steps can be scripts or commands to be run on any BI host where patch has to be applied. The DP once created can be used to:

  • Apply a patch on multiple BI environments.
  • Apply multiple patches if the steps to patch are the same.
  • Apply multiple patches having different patching instructions by customizing the DP (adding new steps and enabling/disabling certain steps).

The complete article including detailed explanations, steps and screenshots can be found in:

Automate Patching of OBIEE using EM Cloud Control (Doc ID 1919956.1)

Apart from the obvious work to create this detailed guide and the simplicity of the idea to use what already exists, what I personally like about this is that these Deployment Procedures carry the potential to work for other software that runs on a Weblogic Server just as well. 

  • They are pointed at any Weblogic Server that are managed by Enterprise Manager 12c
  • They call opatch with a user defined set of instructions

so unless we hear different, it is fairly safe to assume that the same technique can be applied to any other Weblogic based Application that uses opatch for patching.

To prevent anyone from thinking that I am are jumping to conclusions here: there is a KM note indicating this:

Master Index for Provisioning and Patching through Deployment Procedures (a Generic Note specific to a Target Type) (Doc ID 1305014.1)

definitely one to keep bookmarked to ease the troubleshooting of DPs:

Tips and Tricks on Debugging Deployment Procedures (Doc ID 463355.1)

And finally the detailed steps to use Deployment Procedures in the Oracle Enterprise Manager Lifecycle Management Administrator's Guide (  Chapter 42 "Customizing Deployment Procedures") along with the instructions how to create them in the first place ( Chapter 41.6 "Creating, Saving, and Launching User Defined Deployment Procedure (UDDP)")

(info: Senthil; text and layout: Torben; authorized: Lia)

Tuesday Aug 05, 2014

OBIEE 11g: Configuration Management for OBIEE in Enterprise Manager Cloud Control 12c

(in via Senthil)

The Oracle Business Intelligence Enterprise Edition (OBIEE) support team have provided a new knowledge article for OBIEE configuration management:

OBIEE 11g: Configuration Management for OBIEE in
Enterprise Manager Cloud Control 12c
Doc ID 1912834.1

This article will assist in understanding how to use Enterprise Manager Cloud Control to manage OBIEE configurations and includes:

  • Compare configuration data to detect changes
  • Compare patches applied across different systems
  • Create custom Comparison Templates
  • Use Configuration Extensions to collect additional files/data

The article also assists in identifying changes in configuration that maybe resulting in differences in the behavior of similar systems.

The content by itself will not fix "performance" but its use is beneficial to identify differences in configuration between slow and fast performing systems that would be expected to behave the same.

An article of interest relating to slow performing Dashboards ... visit:

OBIEE 11g: How To Diagnose Slowly Performing Dashboards
using Enterprise Manager Cloud Control
Doc ID 1668236.1

Friday Jun 13, 2014

Use Enterprise Manager Cloud Control to monitor OBIEE Dashboards

(in via Senthil

If your OBIEE is set up in the following way:

  1. The OBIEE repository is an Oracle Database and is set up as a data warehouse
  2. Usage tracking is enabled in OBIEE.
    ( For information on how to enable usage tracking in OBIEE, refer to the following link: Setting Up Usage Tracking in Oracle BI 11g )
  3. The OBIEE instance is discovered in EM Cloud Control.
    ( For information on how to discover an OBIEE instance in Cloud Control, refer to the following link: Discovering Oracle Business Intelligence Instance and Oracle Essbase Targets )
  4. The OBIEE repository is discovered in EM Cloud Control.
    ( For information on how to discover an Oracle database, refer to the following link: Discovering, Promoting, and Adding Database Targets )

then we've got news for you:

KM Article:  OBIEE 11g: How To Diagnose Slowly Performing Dashboards using Enterprise Manager Cloud Control (Doc ID 1668236.1)

takes you step by step through monitoring the SQL query performance behind your OBIEE dashboard.

This Diagnostic approach ...

  • .. will help you piece together information on BI dashboard performance, e.g. processing time from the different layers of the BI system including the repository.
  • .. should enable you to get to the bottom of slow dashboards by using the wealth of information available in EM Cloud Control on OBIEE and Oracle DB.
  • .. will NOT fix any performance issues on its own, but will help identify bottlenecks while processing dashboard requests.

(layout and post: Torben, authorized: Lia)

Tuesday Jul 17, 2012

Reminder -> Webcast: Catch the Pulse of EPM in Enterprise Manager

For all those of you who have been looking for a way to monitor the health of your EPM System at runtime, you may want to attend todays:

Advisor Webcast "Catch the Pulse of EPM".

You can find the details and registration information in  KM Note "Catch the Pulse of EPM 11.1.2.x in Enterprise Manager (Doc ID 1466864.1)"

Remember - as with all Advisor Webcasts:

  • registration / participation is free
  • toll free phone lines and audio streaming are available
  • you do not even need to be on the Oracle network to register (just follow this  direct link)
  • you only got to spend one hour of your time :)

From the list of contents of this webcast:

  • Attendees will learn to set up Enterprise Manager (em/console/dms) and collect useful information, slicing and dicing logs.
  • Installing/enabling Enterprise Manager
  • Identification of proactive and reactive functions in these tools that relate to Enterprise Performance Management.
  • Identify the context of collecting information with these tools versus other available tools

As Maurice is running this one, it is likely that you also hear a word about RDA as well.

All future Advisor Webcasts | All recorded Advisor Webcasts

So - tune in to "radio Bauhahn", listen and learn

Tuesday Mar 20, 2012

Enterprise Manager in EPM 11.1.2.x...a game of hide and seek!

guest article: Maurice Bauhahn:

Users of Oracle Hyperion Enterprise Performance Management and may puzzle why the URL http://<servername>:7001/em may not conjure up Enterprise Manager Fusion Middleware Control. This powerful tool has been installed by default...but WebLogic may not have been 'Extended' to allow you to call it up (we are hopeful this ‘Extend’  step will not be needed with The explanation is on pages 425 and following of the following document:

A close look at the screen dumps in that section reveals a somewhat scary prospect, however: the non-AdminServer servlets had all failed (see the red down-arrow icons to the right of their names) after the configuration! Of course you would want to avoid that scenario!

A rephrasing of the instructions might help:

  1. Ensure the WebLogic AdminServer is not running (in a default scenario that would mean port 7001 is not active).

  2. Ensure you have logged into the computer as the installing owner of EPM. Since Enterprise Manager uses a LOT of resources, be sure that there is adequate free RAM to accommodate the added load.

  3. On the machine where WebLogic AdminServer is set up (typically the Foundation Services machine), run \Oracle\Middleware\wlserver_10.3\common\bin\config ( on Unix).

  4. Select the 'Extend an existing WebLogic domain' option, and click the 'Next' button.

  5. Select the domain being used by EPM System.
    - Typically, the default domain is created under /Oracle/Middleware/user_projects/domains and is named EPMSystem.
    - Click 'Next'. Under 'Extend my domain automatically to support the following added products'
    - place a check mark before 'Oracle Enterprise Manager - [oracle_common]' to select it.
    - Continue accepting the defaults by clicking 'Next' on each page until
    - on the last page you click 'Extend'.
    - The system will grind for a few minutes while it configures (deploys?) EM.
    - Start the AdminServer.

  6. Sometimes there is contention in the startup order of the various servlets (resulting in some not coming up). To avoid that problem on Microsoft Windows machines you may start and stop services via the following analogous command line commands to those run on Linux/Unix (these more carefully space out timings of these events):
    • Ensure EPM is up:
    • Ensure WebLogic is up:
    • Shut down WebLogic:
    • Shut down EPM:

 Now you should be able to more successfully troubleshoot with the EM tool:

Wednesday Jan 25, 2012

Tips and Tricks with Enterprise Manager - troubleshooting EPM/BI

guest article by Maurice Bauhahn:

As a hopeless DIYer (do it yourself-er) I seldom start with an adequate set of the right tools to hand to complete a job (such as when I recently replaced the plug on a soymilk making machine bought in Cambodia...a project which ultimately involved multiple screwdrivers, a volt-meter, a pair of pliers, and a knife...and no documentation .

When you start DIY troubleshooting problems in the Oracle Hyperion EPM or OBIEE environments, however, you need not fear a lack of tools or a lack of documentation.

Your software elves at Oracle have bundled two large toolboxes full of useful tools with EPM 11.1.2.x and OBIEE 11g installs: Remote Diagnostic Assistant (RDA) and Enterprise Manager (EM).

Earlier in this blog you will find details on RDA in the RDA Advisor Webcast.

Our EPM developers have written some Tips&Tricks hints in a document on how you may deploy EM. (Alternatively if that file is replaced with one of a different name do a web search for: >> "Enterprise Manager" EPM Tips << )

OBIEE's installer automatically deploys the EM tool. I'm eager to prepare a Webcast Advisor on EM...but need to patiently await the next EPM release with its added functionality.

Meanwhile enjoy exploring your local http://<WebLogicAdminServer>:7001/em and http://<WebLogicAdminServer>:7001/dms

Use '/em' to slice and dice your logs and '/dms' (Dynamic Monitoring Service) to track memory and load on your Java servlets.

Feel more confident in your next EPM and OBIEE DIY troubleshooting task...the tools you need are near at hand!

Cheers, Maurice

This blog talks about the latest news and upcoming events regarding Oracle EPM and BI.
Tanya Heise


« December 2016