进行OPatch Apply操作。

[oracle@XXX-PROD-DB 20299013]$ opatch apply

Oracle Interim Patch Installer version 11.2.0.3.10

Copyright (c) 2015, Oracle Corporation.? All rights reserved.

Oracle Home? ? ? : /u01/app/oracle/product/11.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

? from? ? ? ? ? : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

OPatch version? ? : 11.2.0.3.10

OUI version? ? ? : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-38-47AM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:? 17478514? 18031668? 18522509? 19121551? 19769489? 20299013?

（篇幅原因，有省略……）

Composite patch 20299013 successfully applied.

Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-38-47AM_1.log

OPatch succeeded.

补丁成功。

注意：此时完成的是数据库软件、数据库实例的升级。但是数据库对象却没有升级。之后重启数据库，要进行脚本升级执行。

[oracle@XXX-PROD-DB 20299013]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 4 10:41:37 2015

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

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 5227814912 bytes

Fixed Size? ? ? ? ? ? ? ? ? 2262368 bytes

Variable Size? ? ? ? ? ? 1140853408 bytes

Database Buffers? ? ? ? 4076863488 bytes

Redo Buffers? ? ? ? ? ? ? ? 7835648 bytes

Database mounted.

Database opened.

执行脚本。

SQL> @?/rdbms/admin/catbundle.sql psu apply

SQL> COMMIT;

Commit complete.

SQL> SPOOL off

SQL> SET echo off

Check the following log file for errors:

/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_INTCDB_APPLY_2015Aug04_10_42_39.log

查看补丁内容信息：

[oracle@XXX-PROD-DB 20299013]$ opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.10

Copyright (c) 2015, Oracle Corporation.? All rights reserved.

Oracle Home? ? ? : /u01/app/oracle/product/11.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

? from? ? ? ? ? : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

OPatch version? ? : 11.2.0.3.10

OUI version? ? ? : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-45-21AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-08-04_10-45-21AM.txt

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: localhost

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):?

Oracle Database 11g? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 11.2.0.4.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch? 20299013? ? : applied on Tue Aug 04 10:40:12 CST 2015

Unique Patch ID:? 18573940

Patch description:? "Database Patch Set Update : 11.2.0.4.6 (20299013)"

? Created on 4 Mar 2015, 02:27:44 hrs PST8PDT

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)"

（篇幅原因，有省略……）

? ? 18674047, 17672719, 18856999, 12364061, 18783224, 17851160, 17546761

Patch? 19852360? ? : applied on Tue Aug 04 10:21:38 CST 2015

Unique Patch ID:? 18170553

? Created on 20 Oct 2014, 08:17:43 hrs PST8PDT

? Bugs fixed:

? ? 19852360