15 Apply PSU 11.2.0.4.3 to REPOS


Overview

I patched REPOS to 11.2.0.4.3.

References

Procedure

Download PSU

Downloaded patch 18522509 for Linux-x86 to /opt/oracle/software .

cd /opt/oracle/software
unzip -qo p18522509_112040_LINUX.zip

Verify OPatch Version

Use the following command to check the version of opatch :

opatch version

The output is:

OPatch Version: 11.2.0.3.6

OPatch succeeded.

This is the minimum version required, so there is no need to upgrade opatch .

Environment Checks

which make ar id nm

All of the required programs were found:

/usr/bin/make
/usr/bin/ar
/usr/bin/id
/usr/bin/nm

Check for Patch Conflicts

In order to check for possible conflicts with existing patches, I ran the following commands:

cd /opt/oracle/software/18522509
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

The output is:

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/opatch2014-07-26_19-02-33PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

The good news is that there is no conflicts.

Stop Listener

The Database Listener is stopped as follows:

lsnrctl stop

The output is as follows:

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 26-JUL-2014 19:04:40

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

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

Stop Database Instance

Used SQL*Plus to stop the database instance as follows:

sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 26 19:04:57 2014

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

Apply the PSU

Used the following commands to apply the PSU:

cd /opt/oracle/software/18522509
opatch apply

The output is as follows:

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/opatch2014-07-26_19-06-22PM_1.log

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

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 '18522509' to OH '/opt/oracle/app/OracleHomes/db11g'

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

Patching component oracle.rdbms, 11.2.0.4.0...

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

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

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

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

Verifying the update...
Composite patch 18522509 successfully applied.
Log file location: /opt/oracle/app/OracleHomes/db11g/cfgtoollogs/opatch/opatch2014-07-26_19-06-22PM_1.log

OPatch succeeded.

Startup Database Instance and Perform the Post-Patch Activity

The database instance is started up as follows, and applied the post-patch script:

[oracle@gridctrl 18522509]$ cd ${ORACLE_HOME}/rdbms/admin
[oracle@gridctrl admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 26 19:10:17 2014

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

SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> STARTUP
ORACLE instance started.

Total System Global Area 2142679040 bytes
Fixed Size                  1365828 bytes
Variable Size             805308604 bytes
Database Buffers         1325400064 bytes
Redo Buffers               10604544 bytes
Database mounted.
Database opened.
SQL> @catbundle.sql psu apply

The output is stored in the following files:

  • /opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_GENERATE_2014Jul26_19_11_57.log
  • /opt/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_REPOS_APPLY_2014Jul26_19_12_02.log