.sdo.locator, 11.2.0.3.0... Patching component oracle.rdbms.rman, 11.2.0.3.0... Patching component oracle.ordim.jai, 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' /u01/app/oracle/product/11.2.0.3.0/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg' /u01/app/oracle/product/11.2.0.3.0/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg' /u01/app/oracle/product/11.2.0.3.0/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg' 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_emagent.mk:113: warning: overriding commands for target `nmosudo' ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' /u01/app/oracle/product/11.2.0.3.0/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo' /u01/app/oracle/product/11.2.0.3.0/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' Composite patch 17540582 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0.3.0/cfgtoollogs/opatch/opatch2014-04-14_11-33-31AM_1.log OPatch completed with warnings.
#查看成果，的确是PSU到这个地步了。 pri:orcl2 > $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc $ORACLE_BASE/oraInst.loc -bugs_fixed | egrep 'PSU|PATCH SET UPDATE' 17540582 17540582 Mon Apr 14 11:37:32 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.9 (INCLUDES CPU 16902043 16902043 Mon Apr 14 11:37:18 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.8 (INCLUDES CPU 17230530 16902043 Mon Apr 14 11:37:18 CST 2014 ORA-600 [KKZQID2FRO] AFTER APPLY 11.2.0.3.7 PSU PA 16619892 16619892 Mon Apr 14 11:36:52 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.7 (INCLUDES CPU 16056266 16056266 Mon Apr 14 11:36:25 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.6 (INCLUDES CPU 16368108 16056266 Mon Apr 14 11:36:25 CST 2014 RUNNING OWMV1120.PLB IN PSU 112036 GIVING ORA-0095 14727310 14727310 Mon Apr 14 11:36:14 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.5 (INCLUDES CPU 14275605 14275605 Mon Apr 14 11:35:35 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES CPU 13923374 13923374 Mon Apr 14 11:35:29 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.3 (INCLUDES 13696216 13696216 Mon Apr 14 11:35:07 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES 13343438 13343438 Mon Apr 14 11:34:19 CST 2014 DATABASE PATCH SET UPDATE 11.2.0.3.1
再研究一下，用11.2.0.3.0的软件，是可以打开11.2.0.3.9的数据dbf文件的。
2.Loading Modified SQL Files into the Database
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
回退：
1.我们先找出@catbundle_PSU__ROLLBACK.sql pri:orcl5 > ls | grep catbundle catbundle_PSU_ORCL5_APPLY.sql catbundle_PSU_ORCL5_ROLLBACK.sql catbundle.sql pri:orcl5 > pwd /u01/app/oracle/product/11.2.0.3.0/rdbms/admin shut immediate--关库任意目录下， opatch rollback -id 17540582 sqlplus '/as sysdba' startup
@ /rdbms/admin/catbundle_PSU_ORCL5_ROLLBACK.sql
SQL> set linesize 140
SQL> set pages 9999
SQL> col NAME for a12;
SQL> col PLATFORM_NAME for a24;
SQL> col action_time for a20