8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 11g » Here

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.

Assumptions

This article makes the following assumptions.

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.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.