8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Oracle Forms and Reports Services 11gR2 : Apply Final Patches
The October 2018 security advisory contains the final patches for the 11.1.2.2 version of Oracle Forms and Reports Services. This article shows how to download and apply all patches necessary for Oracle Forms and Reports Services 11.1.2.2.
Related article.
- Oracle Forms and Reports 11gR2 Installation on Oracle Linux 6
- Oracle Forms and Reports 11gR2 Silent Installation on Oracle Linux 6
- Oracle Forms and Reports Services 11gR2 Configuration Notes
Assumptions
This article makes the following assumptions.
- You have an existing Oracle Forms and Reports Services installation at version 11.1.2.2.
- You have a CSI for My Oracle Support (MOS), so you can download the patches.
- You place the downloaded software in the "/u01/software" directory on the server. If not, adjust as required.
Download Patches
The October 2018 security advisory contains the final patches for the 11.1.2.2 version of Oracle Forms and Reports Services. The available patches can be found here.
You will need to download all the patches. The rest of the article assumes they will be placed in the "/u01/software" directory of the server.
The article also assumes you've downloaded the latest version of OPatch for this release, and that is placed in the "/u01/software" directory. It can be downloaded from here.
The full list of files downloaded were as follows.
p6880880_111000_Linux-x86-64.zip p24486705_111170_Generic.zip p22290164_111070_Linux-x86-64.zip p27197885_111170_Linux-x86-64.zip p25264940_111170_Generic.zip p19562319_111220_Linux-x86-64.zip p20002141_111220_Generic.zip p18423801_111170_Linux-x86-64.zip p17617649_111170_Generic.zip p17337741_111170_Linux-x86-64.zip p22733221_111070_Linux-x86-64.zip
Apply Patches
I typically create "start_all.sh" and "stop_all.sh" scripts to simplify startup/shutdown of Forms and Reports Services. The contents of these scripts are described here.
Stop the Forms and Reports Services on the server.
~/scripts/stop_all.sh
Make sure the environment variables for the current software installation are set correctly and set the SOFTWARE_DIR
variable as required.
export MW_HOME=/u01/app/oracle/middleware export FR_INST=${MW_HOME}/FR_inst export ORACLE_HOME=${FR_INST} export SOFTWARE_DIR=/u01/software
Apply each of the patches in turn. If the patch is already applied, it will fail gracefully with a warning.
# Install the latest version of OPatch and add it to the path. cd ${ORACLE_HOME} unzip -oq ${SOFTWARE_DIR}/p6880880_111000_Linux-x86-64.zip export PATH=${ORACLE_HOME}/OPatch:${PATH} # Install patches. cd ${SOFTWARE_DIR} unzip -oq p24486705_111170_Generic.zip cd 24486705 opatch apply cd ${SOFTWARE_DIR} unzip -oq p22290164_111070_Linux-x86-64.zip cd 22290164 opatch apply cd ${SOFTWARE_DIR} unzip -oq p27197885_111170_Linux-x86-64.zip cd 27197885 opatch apply cd ${SOFTWARE_DIR} unzip -oq p25264940_111170_Generic.zip cd 25264940/oui opatch apply #cd ${SOFTWARE_DIR}/25264940/sa #opatch apply cd ${SOFTWARE_DIR} unzip -oq p19562319_111220_Linux-x86-64.zip cd 19562319 opatch apply cd ${SOFTWARE_DIR} unzip -oq p20002141_111220_Generic.zip cd 20002141 opatch apply cd ${SOFTWARE_DIR} unzip -oq p18423801_111170_Linux-x86-64.zip cd 18423801 opatch apply cd ${SOFTWARE_DIR} unzip -oq p17617649_111170_Generic.zip cd 17617649 opatch apply -oh $MW_HOME/oracle_common cd ${SOFTWARE_DIR} unzip -oq p17337741_111170_Linux-x86-64.zip cd 17337741 opatch apply cd ${SOFTWARE_DIR} unzip -oq p22733221_111070_Linux-x86-64.zip cd 22733221 opatch apply
Start the Forms and Reports Services on the server.
~/scripts/start_all.sh
Post-Patch
You need to do the following once the patching is complete.
- Compile all libraries, forms, menus and reports (if you compile reports). You can find out how to do this here.
- Resign any JAR files. You can find out how to do this here.
- Get the users to clear their browser cache and Java cache. Without this they might get errors about attempting to run an out of date client.
For more information see:
- Critical Patch Update (CPU) Program October 2018 Patch Availability Document (PAD) (Doc ID 2433477.1)
- Oracle Forms and Reports 11gR2 Installation on Oracle Linux 6
- Oracle Forms and Reports 11gR2 Silent Installation on Oracle Linux 6
- Oracle Forms and Reports Services 11gR2 Configuration Notes
Hope this helps. Regards Tim...