Applying Platform Patches for OBIA 11.1.1.7.1

This is an important step to avoid the BI Apps configuration failure irrespective of what type OBIEE installation (software only / Enterprise) you did Applying Platform Patches You must apply Fusion Middleware platform patches. The patches are available for download as part of the Oracle Business Intelligence Applications 11.1.1.7.1 media pack. You will run a script to apply the patches. The script is a Perl script and is available in /biapps/tools/bin/APPLY_PATCHES.pl. Note: When installing and running the Perl script, note the following: For installations on Windows, the perl script uses the WinZip utility to extract the contents of the individual patches. If WinZip is not installed on the machine, then you must use install 7-zip and update the script to use it as follows: 1.Download and install 7-zip in C:\Program Files. 2.Open the APPLY_PATCHES.pl file using a text editor. 3.Modify the following lines in the download_patch routine. From: $DOWNLOAD_EXE = "\"C:${DIRSEP}Program Files${DIRSEP}WinZip${DIRSEP}wzunzip.exe\" -ybc -d"; $cmd = "$DOWNLOAD_EXE $_[0] $PATCHES_HOME"; To: $DOWNLOAD_EXE = "\"C:${DIRSEP}Program Files${DIRSEP}7-Zip${DIRSEP}7z.exe\""; $cmd = "$DOWNLOAD_EXE x $_[0] -o$PATCHES_HOME"; 4.Save and close the file. The Perl script you will run to apply the patches requires a parameter input file (apply_patches_import.txt). In this procedure, before you run the Perl script, you will update the parameter input file to reflect the appropriate directory paths. To apply platform patches: 1.If Oracle BI EE was installed in Enterprise Install mode, then shut down WebLogic Administration Server, Managed Server, and Node Manager. Shut down BI processes using Oracle Process Manager and Notification Server (OPMN). If you installed Oracle BI EE in Software Only mode, then skip this step. 2.Download "Oracle Fusion Middleware Platform Patches for Oracle Business Analytics Applications Suite" from the Oracle Business Intelligence Applications 11.1.1.7.1 media pack on Oracle Software Delivery Cloud, as follows: Download the following three parts from the Oracle Business Intelligence Applications 11.1.1.7.1 Media Pack and unzip them into the same directory location: ◦Oracle Fusion Middleware Platform Patches for Oracle Business Intelligence Applications (Part 1 of 2) ◦Oracle Fusion Middleware Platform Patches for Oracle Business Intelligence Applications (Part 2 of 2) ◦Oracle Fusion Middleware Platform Patches for Oracle Business Intelligence Applications for 3.Extract the ZIP file or files into a Patch Home directory, as follows: Extract the contents of the three downloaded zip files containing the patches into the same directory, for example, C:\patches or PATCH_HOME/patches. Note: The directory structure of the extracted contents is not patches4fa/dist/ps6rc3. The patches are contained in folders: biappsshiphome, odi, weblogic and oracle_common. You do not have to unzip the individual patches. 4.Update the parameter input file (apply_patches_import.txt) to reflect the paths as specified in the text file: a.Create a writable directory where logs and temporary patch files will be stored. In the apply_patches_import.txt file, you will set the WORKDIR= variable to point to the path for this directory. b.Open apply_patches_import.txt, which is located in the /biapps/tools/bin directory. c.Specify the following directory paths: Directory Path JAVA_HOME Path of the JDK you installed for your platform. INVENTORY_LOC Path of the Oracle\Inventory directory. For example: C:\Program Files\Oracle\Inventory. ORACLE_HOME Path of the Oracle Home for BI directory. MW_HOME Path of the Oracle Middleware Home directory. COMMON_ORACLE_HOME Path of the oracle_common directory, which is under the Middleware Home directory. WL_HOME Path of the Oracle WebLogic Server Home directory. ODI_HOME Path of the ODI Home directory. WORKDIR Path of a writable directory where logs and temporary patch files are stored. PATCH_ROOT_DIR Path of the patch directory. For example: C:\patches or, PATCH_HOME/patches 5.Run the following command to apply the patch: $ perl APPLY_PATCHES.pl For example: perl /biapps/tools/bin/APPLY_PATCHES.pl /biapps/tools/bin/apply_patches_import.txt Note: This script can be run from any location if Perl is set in the path variable. If Perl is not set in the path variable, run the script from the following location: /perl/bin> 6.Confirm that all patches have been applied successfully by reviewing the following log files in the directory specified by WORDIR: ◦final_patching_report.log (summary of patch application) ◦biappshiphome_generic_patches.log ◦biappshiphome__patches.log ◦odi_generic_patches.log ◦oracle_common_generic_patches.log ◦weblogic_patching.log Note: The WebLogic Server patches are for WebLogic Server 10.3.6. Therefore, if you have WebLogic Server 10.3.5 installed, the patches will not be installed in your environment, and you will not see the weblogic_patching.log file. Also, the final patching report will show the WebLogic Server patches have failed. You can ignore the WebLogic Server patch failures. 7.If Oracle BI EE was installed in Enterprise Install Mode, then start WLS Admin Server, Managed Server and Node Manager. Start the BI processes using OPMN. If you installed Oracle BI EE in Software Only mode, then skip this step.