Tuesday Jun 02, 2015

Caution using Microsoft Active Directory with OBIEE 11.1.1.9.0

Please be aware that if you are using Microsoft Active Directory (MSAD) or a 3rd Party LDAP as the Identity Store, and also use the virtualize=true option you will be unable to log in to Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.9.0. This relates to Bug 20188679.

Customers should apply Patch 20188679 for this issue on their installation platform prior to upgrading or after installing OBIEE 11.1.1.9.0.

Information can be found in document:

OBIEE 11g: Alert: Users Unable to Log in to OBIEE 11.1.1.9.0 if Using MSAD or Other Third-Party LDAP as the Identity Store and Virtualization is Set to true. (Doc ID 2016571.1)

Post Update 3-May-2015: Article updated to extend reference to 3rd party LDAP in addition to MSAD.

Thursday May 14, 2015

Oracle Business Intelligence Enterprise Edition 11.1.1.9.0

We are pleased to announce the release of:.

Oracle Business Intelligence Enterprise Edition
OBIEE 11.1.1.9.0


The download is available from the Oracle Software Delivery Cloud and Oracle Technology Network (OTN):

Oracle Software Delivery Cloud | Oracle Business Intelligence

OTN | Oracle Business Intelligence (11.1.1.9.0) Downloads

IMPORTANT NOTE:

Ensure to download this OBIEE release from the Oracle Software Delivery Cloud for production environments. 

Please note the OTN download is provided for non-production environments such as developing, testing and demonstrating, etc. 

For more information refer to the Oracle license agreement made available prior downloading within Oracle Software Delivery Cloud and OTN. The OTN license is also made available for review via Oracle Technology Network License Agreement.

DOCUMENTATION:

Access OBIEE Documentation via Oracle Help Center:

Oracle Fusion Middleware 11g Release 1 (11.1.1.9)

Release notes for OBIEE 11.1.1.9 have been made available via:

Oracle Fusion Middleware Release Notes for Oracle Business Intelligence

New Features information is outlined within

OBIEE 11g: New Features in OBIEE 11.1.1.9.0 [Doc ID 2010034.1]

OBIEE Supported Systems Configuration information is available for downlaod from OTN:

OTN | Oracle Fusion Middleware Supported System Configurations


Keep up to-date with the latest OBIEE Patches and Patch Set Updates by visiting

OBIEE 11g: Required and Recommended Patches and Patch Sets
Doc ID 1488475.1


Footnote 19th May 2015: The content on this Blog post was updated to reflect download availability from Oracle Software Delivery Cloud.

Tuesday May 05, 2015

Locating OBIEE Maintenance Resources

(in via Ian)

We are pleased to report the publication of the KM note:

OBIEE: Resources for Maintenance Strategy
Doc ID 2003308.2 )

As can be guessed from its name, this interactive KM note is a collection of resources and information related to the maintenance of OBIEE systems.

Its main chapters refer to 

  • Patches
  • Certification Information
  • Lifetime Support Policy
  • Error Correction Policy and
  • Upgrade Information and Upgrade Advisors


It definitely is one to be bookmarked if your tasks include maintenance of OBIEE systems.

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



Wednesday Apr 22, 2015

New Whitepaper: OBIEE to Essbase Authentication Methods

(in via Steve)


We are happy to announce that Product Management has created a new Whitepaper:

OBIEE To Essbase Supported and Recommended Authentication Methods ( Doc ID 1993210.1 )

This is a clean up and compilation of some of the following KM notes:

  •  OBIEE 11g: How To Implement Single Sign-On Using CSS Token for Integration with Essbase ( Doc ID 1480755.1 )
  • Configuring OBIEE 11g to use Hyperion SSO Tokens when Communicating with Essbase, HFM,EPM ( Doc ID 1940079.1 )
  • OBIEE 11g Implement Single Sign-On Using CSS Token For Integration With Essbase ( Doc ID 1608620.1 )
  • OBIEE 11g: How To set up Credential Pass Through from OBIEE to Essbase ( Doc ID 1519240.1 )
  • OBIEE 11g: How to Set up Single Sign-On between OBIEE and Hyperion ( Doc ID 1982665.1 )

These notes have either been archived, deleted or corrected. They are listed here for your reference, and not to be bookmarked.

If you had these notes bookmarked, it is recommended to bookmark the new KM Note 1993210.1 and remove the obsolete references, to keep one single valid reference for all your Essbase/OBIEE authentification needs.


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

Monday Mar 30, 2015

KM Doc: How to change your OBIEE / Essbase passwords

(in via Steve)

Another KM Doc with the rating "bookmark-worthy" has just been published:

Managing passwords for the OBIEE and EPM System can be quite a task, and to successfully juggle all the locations and passwords you would not only need to know where they are, but how to change them as well.
Thanks to the Product Assurance Team, we have a new KM Doc out that tells you in broad terms AND in detail where and how to change the passwords.

OBIEE 11g: How To Change And Encrypt All Passwords For OBIEE And Essbase
( Doc ID 1992361.1)

This KM note contains a PDF with screenshots and detailed set of instructions, to alter e.g:

  • WebLogic Embedded LDAP User's Password
  • Credentials for BISystemUser
  • Weblogic user credentials
  • External LDAP Authenticator Principal User’s password
  • Scheduler DB Schema User password
  • Database Schema password in the EPM System Registry

and a few more.

We hope you find this of use.

Remember to bookmark the note if it is.


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

Friday Mar 13, 2015

Feedback request from the Oracle BI Doc Team

(in via Ian)

Fresh from the UK OUG SIG for Business Analytics in London, Andy Page, Director of BI Documentation, has asked Proactive Support to spread the news and we gladly comply:

The BI Documentation team is asking for your feedback on how to make the documentation even better.

Of course, we from Proactive Support wholeheartedly support this request and therefore endorse his call for survey participation.

OBIEE User Assistance - Moving Beyond Documentation:
What's new, what's coming and how you can help shape the future

If you haven't visited in a while, check out  docs.oracle.com to see the changes that have been made.
More products, more releases, better search - all in one place like never before.

The doc team want to go even further, and they need your help.

How can we improve the product information we provide?

  • More detail? 
  • Less detail? 
  • Fewer concepts, more tasks?
  • Videos?
  • eBooks?
  • ePages?
  • QuickStart Guides?

Together, let's shape the future of BI EE User Assistance!

Click on this link ( http://svy.mk/1y9GY90 ) to complete the brief BI Documentation Survey. 

And if you'd be willing to help even more, include your contact info so the team can follow up directly.

So now its on you to participate and let the doc team know what you need.

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

Sunday Feb 15, 2015

OBIEE 11g: Troubleshooting Crash Issues

(In via Debbie)

We are pleased to advise the following NEW Knowledge Document for Oracle Business Intelligence Enterprise Edition (OBIEE)  which is now available in My Oracle Support:


OBIEE 11g: Troubleshooting Crash Issues
Doc ID 1964727.2


This Knowledge Document guides you through a series of steps to assist in investigating a crash in an OBIEE 11g environment.

Along with the Overview and Getting Started sections, details are provided for Investigating a Crash and Common Crash Symptoms. If an issue is not resolved, the important information to provide within a Service Request are also outlined.

Where more information is required, the References section provides links to related documents, and a useful list of the Log & Configuration File Locations.

Additional Information:

If encountering Stuck Threads or Hang Issues, refer to our previous Blog post:

OBIEE 11g: Troubleshooting Stuck Threads or Hangs

Before proceeding to troubleshoot any issues Oracle highly recommends the latest Bundle Patch Set available be installed. For more information on the latest releases please refer to the following Knowledge Document:

OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets
Doc ID 1488475.1

Questions specific to OBIEE ...

For questions or an issue that you can not identify - visit the OBIEE Community as a first step on your way to a solution: :

My Oracle Support Community
OBIEE

Thursday Feb 12, 2015

OBIEE 11g: Troubleshooting Stuck Threads or Hangs

(In via Debbie)

We are pleased to advise the following NEW Knowledge Document for Oracle Business Intelligence Enterprise Edition (OBIEE)  which is now available in My Oracle Support:

OBIEE 11g: Troubleshooting Stuck Threads or Hangs
Doc ID 1962112.2

Please note this document replaces the article mentioned in this previous announcement

This Knowledge Document describes the steps and methods to assist with troubleshooting Stuck Thread Issues in an OBIEE 11g installation.

The Getting Started section describes Stuck Threads and how to check for them. This is followed on by details on how to troubleshoot and avoid Stuck Threads. Links to examples of Stuck Thread Issues and Stuck Thread Log File entries are also provided.

Before proceeding to troubleshoot a Stuck Thread Issue Oracle highly recommends you install the latest Bundle Patch Set available. For more information on the latest releases please refer to the following Knowledge Document:

OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets
Doc ID 1488475.1

Questions specific to OBIEE ...

For questions or an issue that you can not identify - visit the OBIEE Community as a first step on your way to a solution: :

My Oracle Support Community
OBIEE

Wednesday Jan 21, 2015

Bundle patch: OBIEE 11g 11.1.1.7.150120 Bundle Patch is Available for Oracle Business Intelligence Enterprise Edition and Exalytics

(in via Ian)

The following Patch Set Update (PSU) has been released for Oracle Business Intelligence Enterprise Edition 11.1.1.7 .

This PSU download is available from the
My Oracle Support | Patches & Updates section.

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g 11.1.1.7.150120 patch set
Patch 20124371


Per the patch readme:
This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition:

  • 11.1.1.7.0,
  • 11.1.1.7.1,
  • 11.1.1.7.131017,
  • 11.1.1.7.140114,
  • 11.1.1.7.140225,
  • 11.1.1.7.140415,
  • 11.1.1.7.140527,
  • 11.1.1.7.140715 and
  • 11.1.1.7.141014.

It is also available for Exalytics customers who have applied the Exalytics PS3 patch.

OBIEE bundle patch 11.1.1.7.150120 can be downloaded as Patch 20124371 and is comprised of the following patches, which are not available separately:

  • Patch 16913445 - Patch 11.1.1.7.150120 (1 of 8) Oracle Business Intelligence Installer (BIINST)
  • Patch 19822893 - Patch 11.1.1.7.150120 (2 of 8) Oracle Business Intelligence Publisher (BIP)
  • Patch 19825503 - Patch 11.1.1.7.150120 (3 of 8) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
  • Patch 19822857 - Patch 11.1.1.7.150120 (4 of 8) Oracle Business Intelligence Server (BIS)
  • Patch 19822826 - Patch 11.1.1.7.150120 (5 of 8) Oracle Business Intelligence Presentation Services (BIPS)
  • Patch 19822874 - Patch 11.1.1.7.150120 (6 of 8) Oracle Real-Time Decisions (RTD)
  • Patch 16997936 - Patch 11.1.1.7.150120 (7 of 8) Oracle Business Intelligence ADF Components (BIADFCOMPS)
  • Patch 20022695 - Patch 11.1.1.7.150120 (8 of 8) Oracle Business Intelligence Platform Client Installers and MapViewer

Also you must download and install:

Patch 16569379 - Dynamic Monitoring Service patch.

If you use Internet Explorer 11, download and install:

Patch 18277370 - JDeveloper patch

To share your experience about installing this patch ...

In the MOS | Patches & Updates screen for
Oracle Business Intelligence Enterprise Edition Patch 20124371
- click the "Start a Discussion" and submit your review.

Have a question for Oracle Business Intelligence Enterprise Edition specifically ....

The My Oracle Support Community " OBIEE (MOSC) " is the ideal first stop to seek & find product specific answers:

OBIEE (MOSC)



(text: Ian; layout: Torben; authorized: Lia)

Monday Nov 17, 2014

Advisor Webcast: Using OBIEE with Big Data

Advisor Webcast

 Using OBIEE with Big Data

25th November 2014
2:00 PM UTC/GMT

This one-hour advisor webcast is recommended for users and administrators of OBIEE, who wish to know more about using it to query big data.

The Advisor Webcast will provide information on how to connect to your big data appliance.

TOPICS WILL INCLUDE:

  • Learn about how to connect to your big data appliance.
  • Which ODBC drivers are supported?
  • Are there any limitations on OBIEE when querying big data?
  • Can you use BI Mobile against big data?
  • Demo based on the Oracle Big Data VM

Additional Information and Registration Details - visit:

My Oracle Support Community
Using OBIEE with Big Data


Register


To view scheduled & archived recordings of previous Business Analytics Advisor Webcasts visit:

Oracle Business Analytics Advisor Webcast
Doc ID 1456233.1



CUSTOMER NOTIFICATION : Attendees using recent Chrome or Firefox browser versions maybe required to activate the WebEx plug-in before joining a WebEx meeting. For up to-date information review the WebEx Support page:

https://support.webex.com/webex/meetings/en_US/chrome-firefox-join-faq.htm


Thursday Oct 16, 2014

Bundle Patch OBIEE 11g 11.1.1.7.141014 is available

(in via Ian and Martin)

As of the recent KM note 1935290.1, the

Bundle Patch 11.1.1.7.141014
has been released.

As we see from the note:

This patch set is available for all customers who are using
Oracle Business Intelligence Enterprise Edition
11.1.1.7.0,
11.1.1.7.1,
11.1.1.7.131017,
11.1.1.7.140114,
11.1.1.7.140225,
11.1.1.7.140415,
11.1.1.7.140527 and
11.1.1.7.140715.

It is also available for Exalytics customers who have applied the Exalytics PS3 patch.

OBIEE bundle patch 11.1.1.7.141014  can be downloaded as  Patch 19261194 and is comprised of the following patches, which are not available separately:

  • Patch 16913445 - Patch 11.1.1.7.141014 (1 of 8) Oracle Business Intelligence Installer (BIINST)
  • Patch 19190053 - Patch 11.1.1.7.141014 (2 of 8) Oracle Business Intelligence Publisher (BIP)
  • Patch 18657616 - Patch 11.1.1.7.141014 (3 of 8) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
  • Patch 19190025 - Patch 11.1.1.7.141014 (4 of 8) Oracle Business Intelligence Server (BIS)
  • Patch 19190010 - Patch 11.1.1.7.141014 (5 of 8) Oracle Business Intelligence Presentation Services (BIPS)
  • Patch 17300045 - Patch 11.1.1.7.141014 (6 of 8) Oracle Real-Time Decisions (RTD)
  • Patch 16997936 - Patch 11.1.1.7.141014 (7 of 8) Oracle Business Intelligence ADF Components (BIADFCOMPS)
  • Patch 19190111 - Patch 11.1.1.7.141014 (8 of 8) Oracle Business Intelligence Platform Client Installers and MapViewer


Also you must download and install:

Patch 16569379 - Dynamic Monitoring Service patch

If you use Internet Explorer 11, download and install:

Patch 18277370 - JDeveloper patch

(information: Ian, Martin; text: KM; layout: Torben; authorized: Traugott)

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)


Wednesday Oct 01, 2014

Free OBIEE webcasts from Oracle Education

(in via Mike)

Mike Durran from BI Product Management has been busy creating 3 webcasts for Oracle University covering some of the basic concepts of the OBIEE Lifecycle:

Oracle BI Architecture
(10 mins)

Installation
(20 mins)


Managing the Oracle BI System

(20 mins)

All three can be found via the

The webcasts are free of charge and do not require a login or booking.

(info: Mike D. ; layout: Torben; authorized: Lia)

Friday Sep 26, 2014

OBIEE Sample App V406 - FAQ updated

(in via Pete M.)

While using OBIEE Sample Apps V406 ( we blogged about the release here ), you may encounter an issue as follows :

The database user "system" <password> has expired on your SampleAppv406 virtual appliance.

This will NOT affect normal demo operations as the database starts and functions as excepted when using the 0.Startdb script (sampleapp uses SYS to start the db).

But if you - for whatever reason - require direct access to the database via ./sqlplus or sqldeveloper with user "system" to either the pdborcl or orcl databases, then the updated FAQ document lists the steps to gain back access on the demo database.


Find the OBIEE FAQ here:



    If you have further questions about this - why not post them in our Community here ?

    (info: Pete M; text and layout: Torben; authorized: Lia)

    About


    This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.

    Authors:

    italia.nowodworska(€)oracle.com
    torben.hein(€)oracle.com
    paul.anderson(€)oracle.com
    julie.foster(€)oracle.com





    Search

    Archives
    « July 2015
    SunMonTueWedThuFriSat
       
    1
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
     
           
    Today