Monday, May 18, 2015

OBIEE - Upgrading my Windows to

OBIEE is available. So I will upgrade my existing installation of to 

Follow Upgrade Guide, chapter 1.7 1.7 Moving from,,, or to   

Note: Out of Place BI Upgrade is NOT supported and the procedure is not documented in the guide. the following is In Place Upgrade.

For Linux OBIEE upgrade description, see link to post by Andrew at the bottom of this post.
0. My weblogic is 10.3.6, so no need for upgrade.
1. Stop All and stop the service of Node Manager (Oracle WebLogic NodeManager (D_MWHOME_wlserver_10.3) in my case) under services.
2. Backup, Backup, Backup.
3. Run the installer. Select the Software only option and the existing OBIEE folder (my was D:\MWHOME), that was the default. Next accept the weblogic there.

4. Run patch Set Assistant (D:\MWHOME\Oracle_BI1\bin\psa.bat) and upgrade the RCU (after backup and version certification - - the 3 RCU entries in the Database sheet).  

5. Start the Node Manager service and Admin Server (D:\MWHOME\user_projects\domains\bifoundation_domain\bin\startWebLogic.cmd on my computer).
6. Run ORACLE_HOME\bin\config.bat (on my computer it's D:\MWHOME\Oracle_BI1\bin\config.bat). Select the Update BI Domain option, fill parameters and run Configure.

7. I had a problem in the "starting the Managed server" phase. So I've run "startManagedWebLogic.cmd bi_server1" manually from D:\MWHOME\user_projects\domains\bifoundation_domain\bin\. I had to run the configuration utility twice, until it worked.

Now it's working :)

One more recommended step (in any OBIEE upgrade) is to go to Administration page and run "Scan and Update Catalog Objects That Require Updates". 

(not really critical in my case)

In the document you can also find the option of running the above in silent mode and a note about the change in users folders behavior; Unlike previous releases users folders are created only when needed and not in advance, they also have a different structure. The guide suggests optional step to alter them.  

The following list shows the structure of the Oracle BI Presentation Catalog for a user before Release
The following list shows the structure of the Oracle BI Presentation Catalog for a user in Release and later. Objects previously stored in the "_prefs" and "_subscriptions" folders are moved to the "_internals" folder. The "_deliveries" folder is merged with its parent folder "_delivers".

There is a Linux upgrade post by Andrew from In his case weblogic server upgrade was required as well.


  1. Hello Boris,
    Please let me know if you are aware if the below tables are available as part of Usage Tracking



    1. Sri, this post doesn't cover Usage Tracking. They are new tables in in Usage Tracking, see

  2. This comment has been removed by the author.

  3. Hi, I'm doing the upgrade from to an in the config.cmd starting managed server, the process don't continues.

    what I should do?
    in your post say something about problems in this step, what was the problem and how did you fix the issue?

    Thanks a lot.

    Diego Bocaz

    1. Diego, just as I wrote: open a cmd window while the config is waiting, run "startManagedWebLogic.cmd bi_server1" manually from D:\MWHOME\user_projects\domains\bifoundation_domain\bin\.
      Now resume with the config.

    2. This comment has been removed by the author.

    3. We tried this solution (also twice ;P) and the config window showed the following message: "Configuration action starting managed server: bi_server1 has failed". Anyway, we have finished the upgrade proces manually ( just execution opmnctl and upgrading the catalaog using analytics).


  4. DreamHost is ultimately the best web-hosting company with plans for all of your hosting needs.