Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Patching component oracle.sysman.oms.core, 10.2.0.4.4...
Verifying the update...
Applying sub-patch '13923374' to OH '/opt/oracle/product/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.network.listener, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '14275605' to OH '/opt/oracle/product/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.client, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.precomp.common, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms.util, 11.2.0.3.0...
Verifying the update...
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/opt/oracle/product/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/opt/oracle/product/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/opt/oracle/product/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
Composite patch 14275605 successfully applied.
OPatch Session completed with warnings.
Log file location: /opt/oracle/product/db_1/cfgtoollogs/opatch/opatch2012-12-18_20-09-24PM_1.log
OPatch completed with warnings.
8.进入admin目录，执行catbundle.sql脚本应用改变
[oracle@ora_11g 14275605]$ cd $ORACLE_HOME/rdbms/admin
[oracle@ora_11g admin]$ sqlplus / as sysdba
SQL> startup
SQL> @catbundle.sql psu apply
查询registry$history 来查看PSU级别
SQL>select substr(action_time,1,30) action_time,
substr(id,1,8) id,
substr(action,1,10) action,
substr(version,1,8) version,
substr(comments,1,20) comments
from registry$history;
ACTION_TIME ID ACTION VERSION COMMENTS
------------------------------ ----- ---------- ---------- -----------------------
17-DEC-12 03.14.08.703547 PM 0 APPLY 11.2.0.3 Patchset 11.2.0.2.0
18-DEC-12 08.13.16.342146 PM 4 APPLY 11.2.0.3 PSU 11.2.0.3.4
9.在以下目录检查是否错误
$ORACLE_HOME/cfgtoollogs/catbundle
$ORACLE_BASE/cfgtoollogs/catbundle
日志格式如下:
catbundle_PSU_
catbundle_PSU_
到此 PSU数据库升级完成
10.执行完catbundle.sql后，会在$ORACLE_HOME/rdbms/admin目录下生成
catbundle_PSU_
[oracle@ora_11g admi