18 Apply Patch 17583185

Overview

During the move of the OMR from GRIDCTRL to GORDON, bug 17583185 was encountered. (See MOS Doc 1951858.1).

References

Prequisite Checking

Validate Program Availability

The README says to check that the required programs are in the execution path. This is done as follows:

which opatch make ar ld nm

The output was:

/opt/oracle/app/OracleHomes/db11g/OPatch/opatch /usr/bin/make /usr/bin/ar /usr/bin/ld /usr/bin/nm

Thus, all of the required programs are accessible.

Validate Version of OPatch

The README says that OPatch should be at least 11.2.0.3.0. This is checked as follows:

opatch version

The output was:

OPatch Version: 11.2.0.3.6 OPatch succeeded.

So, we are okay with OPatch.

Validate Oracle Inventory

The README says that Oracle inventory should be intact. This is checked as follows:

opatch lsinventory

The output is attached as 18 lsinventory_pre.log. Critical parts of the output are:

Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 product(s) installed in this Oracle Home. Interim patches (1) : Patch 20760982 : applied on Wed Jul 15 18:15:59 EST 2015 Unique Patch ID: 18941541 Patch description: "Database Patch Set Update : 11.2.0.4.7 (20760982)" Created on 5 Jun 2015, 04:55:07 hrs PST8PDT

It would appear that I had applied PSU 11.2.0.4.7 with registering it in the build diary.

Extract Patch

The README says to extract the patch to some location. This is done as follows:

mkdir -p /opt/oracle/software/P17583185 unzip -q /tmp/p17583185_112040_Generic.zip -d /opt/oracle/software/P17583185

There was no output.

Check for Patch Conflicts

The README says to check for patch conflicts. This is done as follows:

cd /opt/oracle/software/P17583185/17583185/ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

The output was:

Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /opt/oracle/app/OracleHomes/db11g Central Inventory : /opt/oracle/oraInventory from : /opt/oracle/app/OracleHomes/db11g/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/opatch2016-09-18_08-52-30AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.

There are no conflicts and we are cleared to proceed.

Installation

The patch was applied as follows:

cd /opt/oracle/software/P17583185/17583185/ opatch apply

The output was:

Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. Oracle Home : /opt/oracle/app/OracleHomes/db11g Central Inventory : /opt/oracle/oraInventory from : /opt/oracle/app/OracleHomes/db11g/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/17583185_Sep_18_2016_08_54_55/apply2016-09-18_08-54-55AM_1.log Applying interim patch '17583185' to OH '/opt/oracle/app/OracleHomes/db11g' Verifying environment and performing prerequisite checks... All checks passed. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y Backing up files... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Verifying the update... Patch 17583185 successfully applied Log file location: /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/17583185_Sep_18_2016_08_54_55/apply2016-09-18_08-54-55AM_1.log OPatch succeeded.

Post-Installation

The README says to run a SQL file to complete the patch. This was done as follows:

sqlplus / as sysdba @?/sqlpatch/17583185/postinstall.sql

The output was:

Calling rdbms/admin/prvtbpm.plb on 18-SEP-16 08.59.54.654771 AM +10:00 Package body created.

There were no obvious errors.