Monday, May 18, 2015

OBIEE - Upgrading my Windows 11.1.1.7 to 11.1.1.9

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

Follow Upgrade Guide, chapter 1.7 1.7 Moving from 11.1.1.3, 11.1.1.5, 11.1.1.6, or 11.1.1.7 to 11.1.1.9.   

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.
R

4. Run patch Set Assistant (D:\MWHOME\Oracle_BI1\bin\psa.bat) and upgrade the RCU (after backup and version certification - http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-11-1-1-9-0-2541437.xls - 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 11.1.1.9 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 11.1.1.9.0:
/users/<user>
/users/<user>/_delivers
   /users/<user>/_delivers/_deliveries
/users/<user>/_filters
/users/<user>/_portal
/users/<user>/_selections
/users/<user>/_savedcolumns
/users/<user>/_subscriptions
/users/<user>/_thumbnails
/users/<user>/_prefs
   /users/<user>/_prefs/deliveryprofiles
/users/<user>/_prefs/devices
The following list shows the structure of the Oracle BI Presentation Catalog for a user in Release 11.1.1.9.0 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".
/users/<user>/_delivers
/users/<user>/_portal
/users/<user>/_filters
/users/<user>/_selections
/users/<user>/_savedcolumns
/users/<user>/_thumbnails
/users/<user>/_internals
   /users/<user>/_internals/subscriptions
      /users/<user>/_internals/subscriptions.atr
   /users/<user>/_internals/_deliveryprofile_profile1
      /users/<user>/_internals/_deliveryprofile_profile1.atr
   /users/<user>/_internals/_device_device1
      /users/<user>/_internals/_device_device1.atr
   /users/<user>/_internals/_favorites
      /users/<user>/_internals/_favorites.atr
   /users/<user>/_internals/cacheduserinfo
      /users/<user>/_internals/cacheduserinfo.atr
   /users/<user>/_internals/volatileuserdata
      /users/<user>/_internals/volatileuserdata.atr
   /users/<user>/_internals/defaultdevices
      /users/<user>/_internals/defaultdevices.atr
   /users/<user>/_internals/defaultdeliveryprofile
      /users/<user>/_internals/defaultdeliveryprofile.atr
   /users/<user>/_internals/userprefsxmlstore
      /users/<user>/_internals/userprefsxmlstore.atr
  


There is a Linux upgrade post by Andrew from http://bisoftdiary.com:http://bisoftdiary.com/obiee_11117_to_11119_upgrade. In his case weblogic server upgrade was required as well.

8 comments:

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

    WS_ANALYSIS
    WS_DASHBOARD
    WS_DBPROMPT
    WS_FILTER

    Regards,
    Sri

    ReplyDelete
    Replies
    1. Sri, this post doesn't cover Usage Tracking. They are new tables in 11.1.1.9 in Usage Tracking, see http://www.rittmanmead.com/2015/05/whats-new-in-obiee-11-1-1-9-for-systems-administrators-and-developers/

      Delete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Hi, I'm doing the upgrade from 11.1.1.6 to 11.1.1.9 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

    ReplyDelete
    Replies
    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.

      Delete
    2. This comment has been removed by the author.

      Delete
    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).

      THANKS!!

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

    ReplyDelete