16 Apply PSU 11.2.0.4.5 to REPOS


Overview

Apply PSU 11.2.0.4.5 to REPOS . Missed out on PSU 11.2.0.4.4.

Procedure

Download Patch

Download PSU 11.2.0.4.5 for Linux-x86.

Zip file is uploaded to /opt/oracle/software and unzipped there. The installation directory becomes /opt/oracle/software/19769489 .

Check Version of OPatch

The README says that OPatch 11.2.0.3.6 or later is required:

[oracle@gridctrl 19769489]$ ${ORACLE_HOME}/OPatch/opatch version
OPatch Version: 11.2.0.3.6

OPatch succeeded.

Environment Checks

[oracle@gridctrl 19769489]$ which make ar ld nm
/usr/bin/make
/usr/bin/ar
/usr/bin/ld
/usr/bin/nm

Check for Patch Conflict

[oracle@gridctrl 19769489]$ ${ORACLE_HOME}/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
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/opatch2015-02-21_22-40-02PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Shutdown Database Instance and Listener

[oracle@gridctrl 19769489]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Feb 21 22:44:09 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning option

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning option
[oracle@gridctrl 19769489]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-FEB-2015 22:44:42

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully

Apply PSU

[oracle@gridctrl 19769489]$ ${ORACLE_HOME}/OPatch/opatch apply
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/opatch2015-02-21_22-44-57PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   19121551  19769489

Do you want to proceed? [y|n]
y
User Responded with: Y
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



Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/oracle/app/OracleHomes/db11g')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19121551' to OH '/opt/oracle/app/OracleHomes/db11g'

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.ordim.client, 11.2.0.4.0...

Patching component oracle.ordim.jai, 11.2.0.4.0...

Verifying the update...
Applying sub-patch '19769489' to OH '/opt/oracle/app/OracleHomes/db11g'
ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.ovm, 11.2.0.4.0...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms.util, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.xdk.parser.java, 11.2.0.4.0...

Patching component oracle.oraolap, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...

Verifying the update...
Composite patch 19769489 successfully applied.
Log file location: /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/opatch2015-02-21_22-44-57PM_1.log

OPatch succeeded.

Load Modified SQL Files into Database

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
CONNECT / AS SYSDBA
STARTUP
@catbundle.sql psu apply
QUIT

No errors were encountered.