I received a comment on one of the last post regarding upgrading a Oracle BI 11.1.1.6 from 11.1.1.5 and why I recommended doing a out-of-place upgrade, i.e. deinstall and re-install of the updated version, versus using a patch of 11.1.1.6 over 11.1.1.5.  So on a plane ride a few weeks ago I made a short list of reasons to clarify.

Oracle (Photo credit: joepub)

I made the comment that I “recommend conducting a re-install of Oracle BI 11g (for 11.1.1.6) instead of conducting an in-place upgrade” and “…an in place upgrade is a bad idea in my opinion”. Let’s be clear, that this statement was made regarding a minor patch release and not a release patch of Oracle BI 11g.  The former requires the download of all compressed installation files while the latter requires the download of a single one-off patch file/script that is then executed using OPatch.

If that’s clear then here are the top X reasons I would recommend conducting a full de-install and re-install of the Oracle BI 11g platform when upgrading minor releases:

1.  The Oracle documentation does not describe one approach as a best practice versus the other.

2. All major artifacts such as WebLogic Security, Applications Roles/Privilege files, Custom Folders, RPD, web catalog can be easily archived and restored just as easily.  This in my opinion should already be conducted via a weekly backup process so that the key artifacts can be easily retrieved, especially if operating in a highly used OBIEE environment.

3. The RCU database tables, etc. can be data dumped and restored carefully enough into the new RCU MDS/BIPLATFORM schemas.  Selecting just the core pieces from these schemas such as auditing, usage tracking ,etc. can be done quite efficiently using INSERT backups or similar routine with your favorite SQL IDE.

4. Most companies haven’t leveraged Oracle BI 11g to its fullest anyway so conducting this full effort for the larger percentage of users this is no more disruption to the environment that the in-place upgrade and possibly less since the team will have been familiar with the Oracle BI 11g de-install and install process.  The advantage here is experienced gained – see next reason.

5. The OBI team becomes much more versed to the workings of the Oracle BI architecture by doing an uninstall and re-install

6. A de-install prevents the chance of screwing something up in the under pinnings of the FMW environment by modifying critical pieces of the environment using a non-automated upgrade process such as the inlace upgrade.

High-Availability configurations of Oracle BI 11g would be my only hesitation with this logic, but again, the fact that the original installation should have been very well documented should allow a de-install to be more efficient than an in-place upgrade.  Taking also into consideration that if a team wants to move from 11.1.1.5 to 11.1.1.6 then this is already an effort where they will have to schedule time for the process, such as downtime of the system, etc. They might as well do it right the first time with no chance of having backlash later on with an issue that they can’t track down.  We’ve seen how deep that FMW file structure is, right?  So, get the experience, and reduce the chance for any hidden problems from arising.

I’m curious to any feedback you may offer.

Thanks to Robin for asking the burning question which prompted this reply post.

Related articles

• Oracle BI 11.1.1.6 SampleApp VM Image – Do it Yourself (artofbi.com)
• Upgrading Oracle BI 11g Apps (artofbi.com)

Clearly the ArtOfBI.com podcast is a fan of individuals that excel in their field, continue to share information, and are truly passionate about what they do. We continue with that trend as we welcomed Cindi Howson of BI Scorecard to the podcast and are quite glad that we did.  This is one of the most succinct dialogs on the topic of Business Intelligence which  you’ll ever hear in such a short-sitting.  Cindi is on her A-game dropping jewels of wisdom at each turn during this podcast interview. You’ll want to listen and take notes from one of the industry’s top researchers and champion of all things data and analytics.  One of the best parts of this interview is when you hear her perspective of Garnter’s Magic Quadrant for Business Intelligence – super insightful!

Cindi Howson is the founder of BI Scorecard, a resource for in-depth BI tool evaluations based on exclusive hands-on testing. She is the author of several BI books including Successful Business Intelligence: Secrets to Making BI a Killer App, BusinessObjects XI: The Complete Reference, a TDWI faculty member, and a frequent contributor to Information Week. She is a frequent speaker at BI industry events around the world and has been quoted in The Wall Street Journal and The Irish Times. As a consultant, she advises clients on BI strategies and tool selections. Prior to founding BI Scorecard, Howson was a manager at Deloitte & Touche and a BI standards leader for a Fortune 500 company. She has an MBA from Rice University.

Honestly, who gets to go to just about every major Data Warehousing and Business Intelligence related conference each year?  Cindi, that’s who.  And, as I mentioned on the podcast, I wish I had known about her group, BI Scorecard, years ago, it would have saved my then “Decision Support” team lots of time and money.

Thanks again Cindi.

The podcast can be played from the media enclosure above (Just press play).  All feedback is of course very welcome.

This Podcast’s Links

• BI Scorecard
• http://tdwi.org/
• Oracle

Isn’t Oracle EPM grand?

You have to love the load of options, sub-application, and assemblies folder. : )

On a windows 64-bit install remember the first step to the installation is the drop the User Account Control (UAC).

1. Go to Start | Control Panel
2. Under System and Security click the Review your computer’s status link to open the Action Center area
3. Use the drop-down arrow on Security to show the options for user Account Control.
4. Click on the Change settings option
5. Slide the  slider all the way down to Never notify
6. Click the OK button
7. Restart the machine right away.
8. On restart double-check that this option is Off.
9. You may now commence with your EPM 11.1.2.* installation. (assemblies | installTool).