OBIEE 11g Patch Installation

Just to give you an idea of how easy the patch intallation is for 11g, I am writing here steps per readme.txt file for patch installation of one of the patches.

Note: Step 9 is the actual step when patch gets applied using utility "opatch". Rest of the steps are for preparation and verification.


14223977 - Patch 11.1.1.6.2 BP1 (1 of 7) Oracle Business Intelligence Installer
===============================================================================

Readme updated: 12 July 2012


Section 5: Patchset Installation Instructions
---------------------------------------------
1. Backup the Oracle BI System, including the following:
* the ORACLE_HOME\bifoundation\server directory
* the ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository
* the \bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml, if you have modified it

2. Download the following Oracle BI 11.1.1.6.2 BP1 patch zip files from My Oracle Support into the Oracle BI Home directory:

* 14223977
* 14226980
* 13960955
* 14226993
* 14228505
* 13867143
* 14142868

Tips:
* Find all the above patches together by entering the following search criteria:
  - Product/Family = Oracle BI Suite EE
  - Release = 11.1.1.6.2 BP1

* The location of the Oracle BI Home directory will depend on where Oracle BI was originally installed, and the platform. For example:
  - on Linux, AIX or Solaris, the Oracle BI Home directory might be prod_mwhome/Oracle_BI1
  - on Windows, the Oracle BI Home directory might be c:\prod_mwhome\Oracle_BI1


3. Download the following JDeveloper patch zip file from My Oracle Support:
* 13952743


4. Stop the BI System (in the order shown):
* BI system components, by typing the following at the command prompt: opmnctl stopall
* WebLogic Managed Server(s)
* WebLogic Admin Server


5. Clear the files associated with the Oracle BI EE Catalog Manager binary cache as follows:
a. Go to the /bifoundation/web/catalogmanager/configuration/ directory (using a file manager application or the command line). For example:
* on Linux, AIX or Solaris:  if the Oracle BI Home directory is prod_mwhome/Oracle_BI1, go to the following directory:
       prod_mwhome/Oracle_BI1/bifoundation/web/catalogmanager/configuration/
* on Windows: if the Oracle Home directory is C:\prod_mwhome\Oracle_BI1, go to the following directory:
       c:\prod_mwhome\Oracle_BI1\bifoundation\web\catalogmanager\configuration\
b. Remove the following Catalog Manager cache directories (if they exist):
* org.eclipse.osgi
* org.eclipse.equinox.app


6. In the Oracle BI Home directory, unzip each of the Oracle BI 11.1.1.6.2 BP1 patch zip files into a subdirectory below the Oracle BI Home directory. For example:
* on Linux, AIX or Solaris: you might extract patch 14223977 into prod_mwhome/Oracle_BI1/14223977
* on Windows: you might extract patch 14223977 into c:\prod_mwhome\Oracle_BI1\14223977


7. At the command prompt, change directory to the Oracle BI Home directory using the command appropriate for the operating system.
For example:
* on Linux, AIX or Solaris: if the Oracle BI Home directory is prod_mwhome/Oracle_BI1, type the following:
       cd prod_mwhome/Oracle_BI1

* on Windows: if the Oracle BI Home directory is C:\prod_mwhome\Oracle_BI1, type the following:
       cd c:\prod_mwhome\Oracle_BI1


8. At the command prompt, set the ORACLE_HOME, PATH, and JAVA_HOME environment variables as appropriate for the operating system.
For example:
* On Linux, AIX or Solaris: if you are using a command shell derived from the C shell, set the environment variables by typing the following:
       setenv ORACLE_HOME $PWD
       setenv PATH $ORACLE_HOME/bin:$PATH
       setenv JAVA_HOME $ORACLE_HOME/jdk
       setenv PATH $JAVA_HOME/bin:$PATH
       setenv PATH $ORACLE_HOME/OPatch:$PATH

* On Windows: if the Oracle BI Home directory is C:\prod_mwhome\Oracle_BI1, set the environment variables by typing the following:
       set ORACLE_HOME=C:\prod_mwhome\Oracle_BI1
       set PATH=%ORACLE_HOME%\bin;%PATH%
       set JAVA_HOME=%ORACLE_HOME%\jdk
       set PATH=%JAVA_HOME%\bin;%PATH%
       set PATH=%ORACLE_HOME%\OPatch;%PATH%


9. At the command prompt, for each of the extracted Oracle BI 11.1.1.6.2 BP1 patch directories (starting with 1 of 7, then 2 of 7, and so on):
a. Change directory to the extracted patch directory.
For example:
* on Linux, AIX or Solaris: if you extracted patch 14223977 into prod_mwhome/Oracle_BI1/14223977, type the following:
       cd prod_mwhome/Oracle_BI1/14223977

* on Windows: if you extracted patch 14223977 into C:\prod_mwhome\Oracle_BI1\14223977, type the following:
       cd c:\prod_mwhome\Oracle_BI1\14223977

b. Apply the patch using the command: opatch apply
c. When the message 'Opatch Succeeded' is displayed, repeat the above steps for the next patch directory until all the patches have been applied.


10. Verify the Oracle BI 11.1.1.6.2 BP1 patches have been applied successfully as follows:
a. At the command prompt, change directory to the Oracle BI Home.
b. Run the following command to list the patches that have been applied to the Oracle home specified by the ORACLE_HOME environment variable (currently the Oracle BI Home):
        opatch lsinventory
c. Confirm that all the Oracle BI 11.1.1.6.2 BP1 patches shown in Section 1 appear in the list of applied patches (along with any other patches that have previously been applied to the BI System).


11.  Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files from the Oracle BI Home/clients/bipublisher/repository/Tools directory to the Middleware Home/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools directory.


12. If you backed up mapViewerConfig.xml because it had been modified, copy the backed up file to its original location at \bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\


13. You can now apply the JDeveloper patch 13952743 (that you previously downloaded), by following the instructions in the JDeveloper patch Readme file. Note the following:
* As described in the JDeveloper patch Readme file, you apply the JDeveloper patch to the Oracle Common Home directory. Therefore, be sure to follow the instructions in the Readme to change the ORACLE_HOME environment variable to the / directory before applying the JDeveloper patch.
* You must complete the final step to start the Weblogic Admin Server, and then to start Managed Server(s)).


14. When you have applied all the BI EE 11.1.1.6.2 BP1 patches and the JDeveloper patch, start the BI system components by typing the following at the command prompt: opmnctl startall


15. Having installed the Oracle BI 11.1.1.6.2 BP1 patches, you must also update the Oracle Business Intelligence Client Tools (Oracle Business Intelligence Administration Tool, Oracle Business Intelligence Job Manager, and Oracle Business Intelligence Catalog Manager) as follows:
a. Deinstall the Oracle Business Intelligence Client Tools from the Windows machine on which they have been installed, by following the instructions in chapter 5 of the "Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence".
b. Reinstall the Oracle Business Intelligence Client Tools by following the instructions in chapter 5 of the "Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence".


16. (Recommended) Minimize disk usage by:
* deleting the downloaded BI EE 11.1.1.6.2 BP1 patch zip files and the JDeveloper patch zip file
* deleting the extracted patch directories (for example, C:\prod_mwhome\Oracle_BI1\14223977)



Section 6: Post-Installation Instructions
-----------------------------------------

Section 7: Deinstallation Instructions
--------------------------------------

Section 8: Bugs Fixed By This Patch
-----------------------------------

Section 9: Known Bugs With This Patch
-------------------------------------