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.