8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Oracle Forms and Reports Services 11gR2 : Apply the 11.1.2.2 Patchset
This article describes how to apply the 11.1.2.2 patchset to an Oracle Forms and Reports Services 11.1.2.1 installation.
Related articles.
- 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
- Oracle Forms and Reports Services 11gR2 : Apply Final Patches
Assumptions
This article makes the following assumptions.
- You have an existing Oracle Forms and Reports Services installation at version 11.1.2.1.
- 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
Download the "Patch 17882900: ORACLE FORMS AND REPORTS 11G R2 PS2 11.1.2.2" patch set. This consists of the following two files.
p17882900_111220_Linux-x86-64_1of2.zip p17882900_111220_Linux-x86-64_2of2.zip
The 21481019 patch is a mandatory patch that needs to be applied after the patchset is applied. Applying this patch will require the latest OPatch for this release, which is the 6880880 patch. The following patch files were downloaded.
p21481019_111220_Linux-x86-64.zip p6880880_111000_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
Create an "oraInst.loc" file.
cat > ${SOFTWARE_DIR}/oraInst.loc <<EOF inventory_loc=/u01/app/oraInventory inst_group=oinstall EOF
Create a response file called "update.rsp" with the following contents. Amend the
[ENGINE] #DO NOT CHANGE THIS. Response File Version=1.0.0.0.0 [GENERIC] #Set this to true if you wish to specify a directory where latest updates are downloaded. This option would use the software updates from the specified directory SPECIFY_DOWNLOAD_LOCATION=false # SKIP_SOFTWARE_UPDATES=true #If the Software updates are already downloaded and available on your local system, then specify the path to the directory where these patches are available and set SPECIFY_DOWNLOAD_LOCATION to true SOFTWARE_UPDATES_DOWNLOAD_LOCATION= #Set this to true if installation and configuration need to be done, all other required variables need to be provided. Variable "INSTALL AND CONFIGURE LATER TYPE" must be set to false if this is set to true as the variables are mutually exclusive INSTALL AND CONFIGURE TYPE=false #Set this to true if only Software only installation need to be done. If this is set to true then variable "INSTALL AND CONFIGURE TYPE" must be set to false, since the variables are mutually exclusive. INSTALL AND CONFIGURE LATER TYPE=true #Give the complete path for an Oracle Home to be created. The Oracle Home directory name may only contain alphanumeric , hyphen (-) , dot (.) and underscore (_) characters, and it must begin with an alphanumeric character. ORACLE_HOME=<strong>###ORACLE_HOME###</strong> #Write the complete path to a valid Middleware Home. MW_HOME=<strong>###MW_HOME###</strong> #Provide the My Oracle Support Username. If you wish to ignore Oracle Configuration Manager configuration provide empty string for user name. MYORACLESUPPORT_USERNAME= #Provide the My Oracle Support Password MYORACLESUPPORT_PASSWORD=<SECURE VALUE> #Set this to true if you wish to decline the security updates. Setting this to true and providing empty string for My Oracle Support username will ignore the Oracle Configuration Manager configuration DECLINE_SECURITY_UPDATES=true #Set this to true if My Oracle Support Password is specified SECURITY_UPDATES_VIA_MYORACLESUPPORT=false #Provide the Proxy Host PROXY_HOST= #Provide the Proxy Port PROXY_PORT= #Provide the Proxy Username PROXY_USER= #Provide the Proxy Password PROXY_PWD=<SECURE VALUE> #Type String (URL format) Indicates the OCM Repeater URL which should be of the format [scheme[Http/Https]]://[repeater host]:[repeater port] COLLECTOR_SUPPORTHUB_URL= [SYSTEM] [APPLICATIONS] [RELATIONSHIPS]
Amend the "update.rsp" file with the correct values based on the environment variables.
sed -i -e "s|###ORACLE_HOME###|${ORACLE_HOME}|g" ${SOFTWARE_DIR}/update.rsp sed -i -e "s|###MW_HOME###|${MW_HOME}|g" ${SOFTWARE_DIR}/update.rsp
Unzip the patchset software and apply the update in silent mode.
cd ${SOFTWARE_DIR} unzip "p17882900_111220_Linux-x86-64_*of2.zip" cd Disk1 ./runInstaller -silent -ignoreSysPrereqs -response ${SOFTWARE_DIR}/update.rsp -invPtrLoc ${SOFTWARE_DIR}/oraInst.loc
If you don't want to apply it in silent mode, just run the installer without the additional parameters. You can see screen shots of the installation here.
./runInstaller
Once the patchset has been applied, unzip OPatch and install the mandatory patch.
# 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 patch. cd ${SOFTWARE_DIR} unzip p21481019_111220_Linux-x86-64.zip cd 21481019 opatch apply
At this point the patchset has been applied, but you should apply the remaining available patches before continuing. You can see how this is done here.
Once all the relevant patches are applied, you can 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:
- Applying the Latest Oracle Fusion Middleware Patch Set
- 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
- Oracle Forms and Reports Services 11gR2 : Apply Final Patches
Hope this helps. Regards Tim...