Overview
During the move of the OMR from GRIDCTRL to GORDON , bug 17583185 was encountered. (See MOS Doc 1951858.1 ).
References
- EXPDP - ORA-39097 ORA-39065 ORA-00911 (invalid Character) With FULL=Y TRANSPORTABLE=Y (Doc ID 1951858.1)
- ORACLE DATABASE Patch for Bug# 17583185 for Generic Platforms
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.