This is the second part of my recent adventure with upgrading an Oracle BI Enterprise Edition (OBIEE) installation. This is about upgrading the OBIEE software.
Upgrading OBIEE
This post is about upgrading from 11.1.1.5.0 to 11.1.1.6.0.
Downloading the software
You can obtain the latest release from OTN. At the time of writing this we are on version 11.1.1.6.0 (as a release version)
Upgrading the software
Upgrading the software is actually quite easy, but there is a few steps you need to take care of.
Stopping the environment
Before upgrading the software make sure everything is stopped. This includes WebLogic instances, Process Manager, NodeManager etc.
Patch WebLogic Server
As described in my previous post. Make sure that the WebLogic server has been upgraded first.
Upgrade OBIEE software
When the above has been done, you are ready to run the OBIEE software installer. Just run the installer but make sure to select the "Install software only" option when prompted and point the installer to your current installation folder.
Update the database schemas
After upgrading the software you need to patch the database schemas to the latest version. This is done by running the Patch Set Assistant from the MIDDLEWARE_HOME/oracle_common/bin folder by typing
./psa (or psa.bat if you're on windows)
The following schemas needs to be updated
- MDS
- BIPLATFORM
Hint. If you select the BI option, it automatically selects the MDS as well
Troubleshooting
If you get an Error message that says "Invalid JSON String: 0 {t:4}". After the upgrade. Please try the following
- Clear Browser Cache (This can be rather tricky if you are using IE)
- Redeploy analytics.ear
Normally clearing the browser cache is enough.
If you get a problem where the system is unresponsive when clicking on surden things in the UI, it is caused by a deployment error. You need to completely remove the analytics.ear deployment using the WLS console.
After upgrading the software to the latest release version you will want to patch it to the latest patch set.
If you get a problem where the system is unresponsive when clicking on surden things in the UI, it is caused by a deployment error. You need to completely remove the analytics.ear deployment using the WLS console.
- Undeploy analytics
- Restart the servers
- Deploy analytics.ear again
I don't know why this is necessary, but that eventually fixed the issue for me.
After upgrading the software to the latest release version you will want to patch it to the latest patch set.