Oracle 10g升级之--PSU 升级(续）

crespo09

　　Oracle 10g升级之--PSU升级(续）
　　5、再从10.2.0.4.4 升级到10.2.0.4.11
　　-----------升级到10.2.0.4.11
　　[oracle@RH4 12879929]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch apply
　　Invoking OPatch 10.2.0.5.1
　　Oracle Interim Patch Installer version 10.2.0.5.1
　　Copyright (c) 2010, Oracle Corporation.All rights reserved.
　　Oracle Home: /u01/app/oracle/product/10.2.0/db_1
　　Central Inventory : /u01/app/oracle/oraInventory
　　from: /etc/oraInst.loc
　　OPatch version: 10.2.0.5.1
　　OUI version: 10.2.0.4.0
　　OUI location: /u01/app/oracle/product/10.2.0/db_1/oui
　　Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-04-28_02-39-21AM.log
　　Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
　　ApplySession applying interim patch '12879929' to OH '/u01/app/oracle/product/10.2.0/db_1'
　　[oracle@RH4 12879929]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch apply
　　Invoking OPatch 10.2.0.5.1
　　Oracle Interim Patch Installer version 10.2.0.5.1
　　Copyright (c) 2010, Oracle Corporation.All rights reserved.
　　Oracle Home: /u01/app/oracle/product/10.2.0/db_1
　　Central Inventory : /u01/app/oracle/oraInventory
　　from: /etc/oraInst.loc
　　OPatch version: 10.2.0.5.1
　　OUI version: 10.2.0.4.0
　　OUI location: /u01/app/oracle/product/10.2.0/db_1/oui
　　Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-04-28_02-39-21AM.log
　　Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
　　ApplySession applying interim patch '12879929' to OH '/u01/app/oracle/product/10.2.0/db_1'
　　For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows:
　　cd $ORACLE_HOME/rdbms/admin
　　sqlplus /nolog
　　SQL> CONNECT / AS SYSDBA
　　SQL> STARTUP
　　SQL> @catbundle.sql opsu apply
　　SQL> -- Execute the next statement only if this is the first PSU applied for 10.2.0.4 or this is the first PSU applied since 10.2.0.4.8.
　　SQL> @utlrp.sql
　　SQL> QUIT
　　The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series OPSU.
　　For information about the catbundle.sql script, see My Oracle Support Note 605795.1 Introduction to Oracle Database catbundle.sql.
　　------------验证
　　SQL> col COMMENTS for a50
　　SQL> set linesize 120
　　SQL> r
　　1* select action,comments from registry$history
　　ACTIONCOMMENTS
　　------------------------------ --------------------------------------------------
　　UPGRADEUpgraded from 10.2.0.1.0
　　CPUview recompilation
　　APPLYPSU 10.2.0.4.4
　　APPLYPSU 10.2.0.4.11
　　SQL>
　　SQL> shutdown immediate
　　Database closed.
　　Database dismounted.
　　ORACLE instance shut down.
　　SQL> startup
　　ORACLE instance started.
　　Total System Global Area515899392 bytes

　　Fixed>
　　Variable>　　Database Buffers268435456 bytes
　　Redo Buffers2924544 bytes
　　Database mounted.
　　Database opened.
　　SQL> select action,comments from registry$history;
　　ACTIONCOMMENTS
　　------------------------------ --------------------------------------------------
　　UPGRADEUpgraded from 10.2.0.1.0
　　CPUview recompilation
　　APPLYPSU 10.2.0.4.4
　　APPLYPSU 10.2.0.4.11
　　SQL>
　　[oracle@RH4 ~]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatchlsinventory -bugs_fixed | grep -i 'DATABASE PSU'
　　965499112879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.5 (REQUIRES PRE-REQUISITE
　　995223412879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.6 (REQUIRES PRE-REQUISITE
　　1024863612879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.7 (REQUIRES PRE-REQUISITE
　　1172497712879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.8 (REQUIRES PRE-REQUISITE
　　1241939712879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.9 (REQUIRES PRE-REQUISITE
　　1282777812879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.10 (REQUIRES PRE-REQUISITE
　　85761569352164Sat Apr 28 00:50:14 CST 2012DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)
　　88332809352164Sat Apr 28 00:50:14 CST 2012DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)
　　91192849352164Sat Apr 28 00:50:14 CST 2012DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)
　　93521649352164Sat Apr 28 00:50:14 CST 2012DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)