Tag Archives: Obiee

BITeamwork 1.8 (Nobel Release) – It’s Dynamite

BITeamwork has been out since Oracle Open World 2012 but since its involvement with several customers the product has evolved into a really amazing software offering. Clearly BITeamwork is the collaboration solution for Oracle BI which allows users to create dashboard comments, table and pivot table cell annotations, and then manage it all but it also has some amazing administration features. Actually, the roadmap for BITeamwork is to make up the gaps that customers see in the BI product such as custom metadata dictionaries, better management tools for ibots/agent, and a better caching system. Customers and implementers of Oracle BI should support the product now so that these items actually come to fruition.

The post BITeamwork 1.8 (Nobel Release) – It’s Dynamite appeared first on Art of Business Intelligence.

OBIEE This is the end?

…..not really, but ….

 As most of you might have notice my activity’s in the OBIEE community have been minimal during the last year or so.
How come?
I have accepted a new challenge in becoming the team lead for Microsoft BI at Ciber in the Netherlands .
This means I have little to none time left for OBIEE blogging.  And thinks like visiting the Rittman-Mead conference in Brighton this year are sadly also out of the question.
I will be closing the possibility of adding comments / question on this blog because I don’t have any time left to filter out the spam.
I hope to pick my OBIEE and other blogging activities up in the future but for now:
Good luck and hope to see you again!

Till Next Time

John

OBIEE 11.1.1.6.6 Patch Released

OBIEE 11.1.1.6.6 (aka 11.1.1.6.0 BP6) is out and until MOS hosts a proper tracking note, here is the list of all patches making up this patch set with direct links.

Patch 15844023    Patch 11.1.1.6.6 (1 of 7) Oracle Business Intelligence Installer
Patch 15844066    Patch 11.1.1.6.6 (2 of 7) Oracle Real Time Decisions
Patch 14800665    Patch 11.1.1.6.6 (3 of 7) Oracle Business Intelligence Publisher
Patch 15843961    Patch 11.1.1.6.6 (4 of 7) Oracle Business Intelligence ADF Components
Patch 15844096    Patch 11.1.1.6.6 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
Patch 14791926    Patch 11.1.1.6.6 (6 of 7) Oracle Business Intelligence
Patch 15839347    Patch 11.1.1.6.6 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer

As always: don't forget JDEV patch 13952743

Cheers!

FYI: Error while running Upgrade Assistant OBIEE 11g – UPGAST-00055

When migrating our legacy OBIEE 10g webcat and RPD to Oracle's new 11g platform, we often don't have the privilege of using a GUI based operating system for assembly & system test as most production systems are Solaris or Red Hat.

We can all agree that a unix distribution is more powerful & flexible, yet leaves much to be desired when attempting to resolve configuration issue in a 'friendly UI environment'. This is certainly no exception when attempting to use Oracle's Upgrade Assistant Command Line Interface .

Many users have encountered error " UPGAST-00055: error reading the Universal Installer Inventory. The inventory pointer oraInst.loc is either not readable or doest not exist". A quick search of Oracle's Fusion Middleware Error Message Reference Guide makes me believe that Oracle's writers are playing a cruel joke in their attempt to 'help':








Action: "see the secondary error message?" You've got to be kidding me!!

Oracle's 'help' aside, the upgrade assistant is looking for an oraInst.loc file which contains 2 things:
  1. The location of your installation directory
  2. The install group of your user
But the upgrade assistant cant find your oraInst.loc file, why?
UA, by default, searches for the oraInst.loc file in your /var/opt/oracle folder. But many times, the file won't be located there - for a number of reasons , including:
  • custom installation directories
  • co-installation of multiple oracle products
  • de-installation and subsequent re-installation attempts
But you're not out of luck. Most likely, your oraInst.loc file will be in your $MW_HOME/oracle_common folder:















You can then use the UA CLI paramater -invPtrLoc to specify your custom oraInst.loc path.:




./ua MT -BIEEE -webcatdir /export/obiee/11g/Oracle_BI1/bin/webcatalog -invPtrLoc /export/obiee/11g/oracle_common/oraInst.loc -webCatDeliversDir /delivers -wlsPort 7001 -wlsUser weblogic
will generate the following:








followed by a series of postupgrade tasks that you can view at 'tail -f $ORACLE_HOME/upgrade/logs/postupgrade.txt'
and ultimately a 'completed successfully' message:






































But what if you can't find your oraInst.loc file? Don't worry! Oracle has a template you can use located at:
  • /$ORACLE_HOME//bifoundation/provision/scripts/bidomain/inst
  1. Rename it to oraInst.loc
  2. Copy it to your $ORACLE_HOME folder
  3. Populate the inventory_loc line with the path to your oraInventory folder
  4. Populate the inst_group with the group name of the account you're using to install & upgrade OBIEE
  5. Run the upgrade assistant as specified above

Problem solved!

keywords : obiee 11g upgrade, upgrade assistant,  obiee administration, obiee 11g administration, weblogic obiee

OBIEE 11.1.1.6.5

While I was off, Oracle released OBIEE 11.1.1.6.5 which is another bugfixing patch set which doesn't bring in new functionality but irons out quite a few quirks.

Here you can find the main MOS article detailling the patches making up this patch set as all bugs fixed in it.

By the way...make sure you don't forget JDEV patch 13952743.

Cheers!