8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | 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.

Assumptions
Download Patches
Apply Patches
Post-Patch

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.

Oracle Forms and Reports Services 11gR2 : Apply Final Patches

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:

Hope this helps. Regards Tim...

Back to the Top.