Oracle 11g (11.2.0.4) Manual Patch psu (11.2.0.4.8)

First, the preparatory work

1, database environment
Operating system version: Redhat 6.5 x64
Database version: Oracle 11.2.0.4 x64
Oracle database:11.2.0.4

2, Prepare content
Opatch:p6880880_112000_linux-x86-64.zip
DB Psu:p21352635_112040_linux-x86-64.zip is used only for single instance.
Opatch:
Https://updates.oracle.com/download/6880880.html

Description: GI PSU includes DB psu,cpu.

Second, update the Opatch version, must be updated

1. Update the Opatch version, you need to update to 11.2.0.3.11,opatch direct compression replacement.
(1) Upload p6880880_112000_linux-x86-64.zip to/u01/software directory,/u01/software to 777 permissions, you can also use the/tmp directory.
(2) Rename the original Opatch directory under root user.
# MV/U01/APP/ORACLE/PRODUCT/11.2.0/DB_1/OPATCH/U01/APP/ORACLE/PRODUCT/11.2.0/DB_1/OPATCHBK

2. Oracle Directory Opatch Replacement
(1) Root user
Cd/u01/software/
Chown Oracle:oinstall P6880880_112000_linux-x86-64.zip

(2) Oracle User
Su-oracle
Cd/u01/software/
Unzip P6880880_112000_linux-x86-64.zip

(3) Root user
Cd/u01/software/
MV opatch/u01/app/oracle/product/11.2.0/db_1/

(4) Oracle User Testing
Su-oracle
$/u01/app/oracle/product/11.2.0/db_1/opatch/opatch version

Opatch version:11.2.0.3.11
Opatch succeeded.

3. Test compatibility, not previously played, this step can also be ignored.
Su-oracle
$ORACLE _home/opatch/opatch Prereq Checkconflictagainstohwithdetail-phbasedir/u01/software/21352635-oh $ORACLE _ HOME
----------------------------------------------------
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c), Oracle Corporation. All rights reserved.

Prereq session
Oracle Home:/u01/app/oracle/product/11.2.0/db_1
Central Inventory:/u01/app/orainventory
From:/u01/app/oracle/product/11.2.0/db_1/orainst.loc
Opatch version:11.2.0.3.11
OUI version:11.2.0.4.0
Log File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-12-20_15-01-26pm_1.log
Invoking Prereq "Checkconflictagainstohwithdetail"
Prereq "Checkconflictagainstohwithdetail" passed.
Opatch succeeded.
----------------------------------------------------

Five, hit the database PSU patch

1. Preparatory work
(1) Under the root user, re-give the PSU patch package permissions
Cd/u01/software/
Chown Oracle:oinstall P21523375_112040_linux-x86-64.zip

(2) Oracle User
Su-oracle
Cd/u01/software/
Unzip P21352635_112040_linux-x86-64.zip

(3) Check compatibility under Oracle user
$ORACLE _home/opatch/opatch Prereq Checkconflictagainstohwithdetail-phbasedir/u01/software/21352635-oh $ORACLE _ HOME
----------------------------------------------------
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c), Oracle Corporation. All rights reserved.

Prereq session

Oracle Home:/u01/app/11.2.0/grid
Central Inventory:/u01/app/orainventory
From:/u01/app/11.2.0/grid/orainst.loc
Opatch version:11.2.0.3.11
OUI version:11.2.0.4.0
Log File Location:/u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-12-18_16-21-46pm_1.log

Invoking Prereq "Checkconflictagainstohwithdetail"

Prereq "Checkconflictagainstohwithdetail" passed.
Opatch succeeded.
----------------------------------------------------

2. Close the database
Sqlplus/as Sysdba;
Shutdown immediate;

3. Oracle Database Patching
Su-oracle
$/u01/app/oracle/product/11.2.0/db_1/opatch/opatch Napply-oh $ORACLE _home-local/u01/software/21352635

Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c), Oracle Corporation. All rights reserved.

Oracle Home:/u01/app/oracle/product/11.2.0/db_1
Central Inventory:/u01/app/orainventory
From:/u01/app/oracle/product/11.2.0/db_1/orainst.loc
Opatch version:11.2.0.3.11
OUI version:11.2.0.4.0
Log File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-12-20_15-05-41pm_1.log

Verifying environment and performing prerequisite checks ...
Opatch continues with these patches:17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635

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 your My
Oracle support Email Address/user Name.
Visit http://www.oracle.com/support/policies.html for details.
Email Address/user Name:

You don't have a provided an email address for notification of security issues.
Do your 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 = '/u01/app/oracle/product/11.2.0/db_1 ')

is the local system ready for patching? [Y|n]
Y
User responded With:y
Backing up files ...
Applying Sub-patch ' 17478514 ' to OH '/u01/app/oracle/product/11.2.0/db_1 '

Patching component Oracle.rdbms, 11.2.0.4.0 ...
Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0 ...
Patching component oracle.sdo, 11.2.0.4.0 ...
Patching component Oracle.sysman.agent, 10.2.0.4.5 ...
Patching component Oracle.xdk, 11.2.0.4.0 ...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0 ...
Patching component Oracle.sdo.locator, 11.2.0.4.0 ...
Patching component ORACLE.NLSRTL.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 ...
Verifying the update ...
Applying Sub-patch ' 18031668 ' to OH '/u01/app/oracle/product/11.2.0/db_1 '
Patching component Oracle.rdbms, 11.2.0.4.0 ...
Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0 ...
Patching component ORACLE.LDAP.RSF, 11.2.0.4.0 ...
Patching component Oracle.rdbms.crs, 11.2.0.4.0 ...
Patching component Oracle.precomp.common, 11.2.0.4.0 ...
Patching component Oracle.ldap.rsf.ic, 11.2.0.4.0 ...
Patching component Oracle.rdbms.deconfig, 11.2.0.4.0 ...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0 ...
Patching component Oracle.rdbms.rman, 11.2.0.4.0 ...
Verifying the update ...
Applying Sub-patch ' 18522509 ' to OH '/u01/app/oracle/product/11.2.0/db_1 '
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 ...
Applying Sub-patch ' 19121551 ' to OH '/u01/app/oracle/product/11.2.0/db_1 '
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 '/u01/app/oracle/product/11.2.0/db_1 '
Applysession:optional component (s) [Oracle.sysman.agent, 11.2.0.4.0] not present in the Oracle Home or a higher versio N 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 ...
Applying Sub-patch ' 20299013 ' to OH '/u01/app/oracle/product/11.2.0/db_1 '
Patching component Oracle.rdbms.dv, 11.2.0.4.0 ...
Patching component Oracle.rdbms.oci, 11.2.0.4.0 ...
Patching component Oracle.precomp.common, 11.2.0.4.0 ...
Patching component Oracle.sysman.agent, 10.2.0.4.5 ...
Patching component Oracle.xdk, 11.2.0.4.0 ...
Patching component Oracle.sysman.common, 10.2.0.4.5 ...
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.sysman.console.db, 11.2.0.4.0 ...
Patching component ORACLE.XDK.RSF, 11.2.0.4.0 ...
Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0 ...
Patching component Oracle.sysman.common.core, 10.2.0.4.5 ...
Patching component Oracle.rdbms.rman, 11.2.0.4.0 ...
Patching component Oracle.rdbms.deconfig, 11.2.0.4.0 ...

Verifying the update ...
Applying Sub-patch ' 20760982 ' to OH '/u01/app/oracle/product/11.2.0/db_1 '
Patching component oracle.sysman.console.db, 11.2.0.4.0 ...
Patching component Oracle.rdbms, 11.2.0.4.0 ...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0 ...

Verifying the update ...
Applying Sub-patch ' 21352635 ' to OH '/u01/app/oracle/product/11.2.0/db_1 '
Patching component Oracle.sysman.agent, 10.2.0.4.5 ...
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 ...

Verifying the update ...
Composite Patch 21352635 successfully applied.
Log File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-12-20_15-05-41pm_1.log
Opatch succeeded.

To view patch conditions:
/u01/app/oracle/product/11.2.0/db_1/opatch/opatch LSINV

Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c), Oracle Corporation. All rights reserved.

Oracle Home:/u01/app/oracle/product/11.2.0/db_1
Central Inventory:/u01/app/orainventory
From:/u01/app/oracle/product/11.2.0/db_1/orainst.loc
Opatch version:11.2.0.3.11
OUI version:11.2.0.4.0
Log File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-12-20_15-14-09pm_1.log
Lsinventory Output file Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/ Lsinventory2015-12-20_15-14-09pm.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname:testdb
ARU Platform id:226
ARU platform Description:: Linux x86-64
Installed top-level products (1):
Oracle Database 11g 11.2.0.4.0
Here is 1 products installed in this Oracle Home.
Interim patches (1):
Patch 21352635:applied on Sun Dec 15:11:43 CST 2015
Unique Patch id:19227862
Patch Description: "Database Patch Set update:11.2.0.4.8 (21352635)"
Created on 1 Sep, 07:49:44 hrs
Sub-patch 20760982; "Database Patch Set update:11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set update:11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set update:11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set update:11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set update:11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set update:11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set update:11.2.0.4.1 (17478514)"
Bugs fixed:
... Slightly

/u01/app/oracle/product/11.2.0/db_1/opatch/opatch lspatches

[Email protected] opatch]$/u01/app/oracle/product/11.2.0/db_1/opatch/opatch lspatches
21352635;database Patch Set update:11.2.0.4.8 (21352635)
Opatch succeeded.

Vi. Upgrading the database data dictionary
The database starts and loads the modified SQL files to the database

$ sqlplus/as SYSDBA
Sql*plus:release 11.2.0.4.0 Production on Sun Dec 20 15:29:02 2015

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

Sql> Startup

Sql> @?/rdbms/admin/catbundle.sql PSU Apply
Intermediate wait process.

After execution we can find the PSU update information:
Sql>

Set Line 150
Col Action_time for A30
Col ACTION for A8
Col NAMESPACE for A8
Col VERSION for A10
Col Bundle_series for A5
Col COMMENTS for A20
SELECT * from Dba_registry_history;

Action_time ACTION namespac VERSION ID Bundl COMMENTS
------------------------------ -------- -------- ---------- ---------- ----- --------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU patchset 11.2.0.2.0
27-oct-15 11.43.27.172237 AM APPLY SERVER 11.2.0.4 0 PSU patchset 11.2.0.2.0
20-dec-15 03.19.26.562797 PM APPLY SERVER 11.2.0.4 8 PSU PSU 11.2.0.4.8
3 Rows selected.
Sql>
Sql>

This article is from the "Koumm Linux Technology blog" blog, be sure to keep this source http://koumm.blog.51cto.com/703525/1727730

Oracle 11g (11.2.0.4) Manual Patch psu (11.2.0.4.8)