- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
1#
发表于 2012-4-18 18:39:11
|
查看: 15681 |
回复: 4
以下 简要 说明如何将 单实例 single instance db 从 10.2.0.5 升级到 10.2.0.5.6
首先 需要从 MOS上下载 包括 PSU 10.2.0.5.6 的相关patch p13343471 ( Linux x64下是 p13343471_10205_Linux-x86-64.zip)和 最新的OPatch工具 p6880880 (Linux x64下是 p6880880_102000_Linux-x86-64.zip) ， 如果Opatch工具不是最新的 那么可能发生 如 "ApplySession applying interim patch 'null'" 或 opatch version old 之类的错误。
其次注意 PSU 10.2.0.5.6 是 cumulative的， PSU 10.2.0.5.6包含了所有PSU 10.2.0.5.5 中的fix 修复，安装10.2.0.5.6的前提是 已经安装了 patch set 10.2.0.5，而不要求安装了10.2.0.5上的其他早期PSU 。 (PSU 10.2.0.5.6 includes all fixes previously included in PSU 10.2.0.5.5 and those listed in Section 7, "Bugs Fixed by This Patch".To install the PSU 10.2.0.5.6 patch, the Oracle home must have the 10.2.0.5.0 Database installed. Subsequent PSU patches can be installed on Oracle Database 10.2.0.5.0 or any PSU with a lower 5th numeral version than the one being installed.)
1. 关闭 所有 将要Opatch的ORACLE_HOME上相关的实例 和 监听器
lsnrctl stop LISTENER
sqlplus / as sysdba
shutdown immediate ;
确认相关进程都已经 close
[oracle@vrh8 13343471]$ ps -ef|grep ora_
oracle 10864 10490 0 06:11 pts/0 00:00:00 grep ora_
[oracle@vrh8 13343471]$ ps -ef|grep tns
root 13 2 0 Apr10 ? 00:00:00 [netns]
oracle 10866 10490 0 06:11 pts/0 00:00:00 grep tns
2. 将最新的 OPatch工具 解压到 $ORACLE_HOME/OPatch目录下
[oracle@vrh8 ~]$ unzip p6880880_102000_Linux-x86-64.zip
Archive: p6880880_102000_Linux-x86-64.zip
creating: OPatch/
creating: OPatch/ocm/
extracting: OPatch/ocm/ocm.zip
creating: OPatch/ocm/lib/
inflating: OPatch/ocm/lib/osdt_jce.jar
inflating: OPatch/ocm/lib/osdt_core3.jar
inflating: OPatch/ocm/lib/emocmclnt-14.jar
inflating: OPatch/ocm/lib/emocmutl.jar
creating: OPatch/ocm/bin/
inflating: OPatch/ocm/bin/emocmrsp
inflating: OPatch/ocm/ocm_platforms.txt
creating: OPatch/crs/
creating: OPatch/crs/log/
inflating: OPatch/crs/patch112.pl
inflating: OPatch/crs/crsdelete.pm
inflating: OPatch/crs/crspatch.pm
inflating: OPatch/crs/s_crsconfig_defs
inflating: OPatch/crs/crsconfig_lib.pm
inflating: OPatch/crs/oracss.pm
inflating: OPatch/crs/auto_patch.pl
inflating: OPatch/crs/s_crsconfig_lib.pm
inflating: OPatch/opatch
creating: OPatch/opatchprereqs/
creating: OPatch/opatchprereqs/opatch/
inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
inflating: OPatch/opatchprereqs/opatch/rulemap.xml
inflating: OPatch/opatchprereqs/prerequisite.properties
creating: OPatch/opatchprereqs/oui/
inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
inflating: OPatch/opatch.ini
inflating: OPatch/emdpatch.pl
inflating: OPatch/opatch.pl
creating: OPatch/jlib/
inflating: OPatch/jlib/opatchprereq.jar
inflating: OPatch/jlib/opatchactions.jar
inflating: OPatch/jlib/opatchutil.jar
inflating: OPatch/jlib/opatchfmw.jar
inflating: OPatch/jlib/opatchext.jar
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/opatch.bat
creating: OPatch/docs/
inflating: OPatch/docs/Prereq_Users_Guide.txt
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/README.txt
[oracle@vrh8 ~]$ echo $ORACLE_HOME
/s01/oracle/product/10.2.0.5/db_1
确认$ORACLE_HOME 变量正确
[oracle@vrh8 ~]$ cp -r OPatch /s01/oracle/product/10.2.0.5/db_1/OPatch
以上用新的OPatch介质 覆盖了 原$ORACLE_HOME/OPatch 目录
输出opatch命令(要求已将$ORACLE_HOME/OPatch加入到 PATH中)
[oracle@vrh8 ~]$ $ORACLE_HOME/OPatch/opatch
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.
确认你的 OPatch 版本为 10.2.0.5.1
3. 解压 PSU 10.2.0.5.6 ，并检验该13343471 补丁与 当前 ORACLE_HOME下的其他补丁不冲突
[oracle@vrh8 ~]$ unzip p13343471_10205_Linux-x86-64.zip
[oracle@vrh8 ~]$ cd 13343471/
[oracle@vrh8 13343471]$ ls
custom etc files patchmd.xml README.html README.txt
[oracle@vrh8 13343471]$ cd etc/
config/ xml/
[oracle@vrh8 13343471]$ cd etc/config/
[oracle@vrh8 config]$ ls
actions inventory
[oracle@vrh8 config]$ cat inventory
<oneoff_inventory>
<opack_version version="10.2.0.6.0"/>
<patch_id number="13343471"/>
<unique_patch_id>14282265</unique_patch_id>
<minimum_opatch_version>10.2.0.5.0</minimum_opatch_version>
<date_of_patch year="2011" month="Dec" day="20" time="21:48:08 hrs" zone="PST8PDT"/>
<base_bugs>
<bug number="6402302" description="DROP SYNONYM DDL IS NOT CAPTURED/PROPAGATED OR APPLIED"/>
<bug number="10269717" description="DBMS_SQL.PARSE CAUSES MEMORY LEAK AFTER APPLYING PSR 10.2.0.5"/>
<bug number="10327190" description="DB-10.2.0.5-MOLECULE-003-CPUAPR2011"/>
<bug number="11693109" description="ORA-481 DUE TO COMMUNICATION ISSUE BETWEEN NODE1 AND NODE6"/>
<bug number="8865718" description="RECURSIVE CURSORS CONTAINING 'AS OF SNAPSHOT' CLAUSE ARE NOT SHARED"/>
<bug number="10017048" description="DML DOES NOT RUN PARALLEL IN DEEPER NESTING IN DBMS_JOB AND PL/SQL ON 10.2.0.5"/>
<bug number="9024850" description="WRONG RESULTS USING ORA_ROWSCN"/>
<bug number="8394351" description="ORA-12801; ERROR SIGNALED IN PARALLEL QUERY SERVER P005 RUNNING DM QUERY"/>
<bug number="8546356" description="ORA-600 [KDSGRP1] AFTER REBUILD INDEX ONLINE WHEN CONCURRENT W/ UPDATES"/>
<bug number="8224558" description="DBBETA EXCESSIVE ARCHIVE LOGGING GENERATED WHEN REQUIRED LOGFILE DELETED"/>
<bug number="13489660" description="DB-10.2.0.5-MOLECULE-020-CPUJAN2012"/>
<bug number="9360157" description="WRONG RESULTS WHEN USING ORA_ROWSCN PSEUDOCOLUMN USING ANSI JOIN"/>
<bug number="9770451" description="APPLICATION CRASHES WITH ORA-00600 [20022]"/>
<bug number="9020537" description="DBMS_LOB.SUBSTR TRUNCATES LOBS IN AL32UTF8"/>
<bug number="9772888" description="WARNING;COULD NOT LOWER THE ASYNCH I/O LIMIT TO 160 FOR SQL DIRECT I/O. IT IS SE"/>
<bug number="8650138" description="PMON SIGNALLED ORA-7445[KOKLCOM()+504] AND TERMINATED THE INSTANCES"/>
<bug number="8664189" description="ORA-00600 [KDISS_UNCOMPRESS: BUFFER LENGTH]"/>
<bug number="8488233" description="WHEN DDL CHANGES CT FILE SIZE, IT'S POSSIBLE THAT CTWR FOB IS STALE"/>
<bug number="10091698" description="ORA-00600 [17069] WHEN RUNNING CATUPGRD.SQL"/>
<bug number="10092858" description="WRONG RESULT WHEN MATERIALIZED VIEW WITH OUTER JOIN IS FAST REFRESHED"/>
<bug number="12551710" description="DB-10.2.0.5-MOLECULE-015-CPUJUL2011"/>
<bug number="7519406" description="'J000' TRACE FILE REGARDING GATHER_STATS_JOB INTERMITTENTLY SINCE 10.2.0.4"/>
<bug number="13349665" description="ORA-600 [KKSLMTL-VALNOTFOUND] WITH PSU 10.2.0.5.5"/>
<bug number="10132870" description="INDEX BLOCK CORRUPTION ORA-600 [KCBZPBUF_2], [6401] ON RECOVER"/>
<bug number="8771916" description="ORA-00600 [KDSGRP1] WHEN DOING AN UPDATE"/>
<bug number="9109487" description="DBMS_SPACE.ISDATAFILEDROPPABLE_NAME THROWS NUMERIC OVERFLOW"/>
<bug number="7509714" description="CPM 9667 UNIQUE CONSTRAINT (SYS.I_INDSUBPART_POBJSUBPART$) ERROR REBUILD INDEXES"/>
<bug number="9171933" description="FALSE CONTENTION INTRODUCED BY BUG FIX - 5632050"/>
<bug number="10173237" description="CROSS INSTANCE ARCHIVAL FAILING AFTER UPGRADE TO 10.2.0.5"/>
<bug number="9532911" description="LOB SHOWING INCORRECT DATA ON DATA GUARD STANDBY SITE"/>
<bug number="10139235" description="ORA-600 [KOKCUP 01] AND ORA-600 [KOKCUP 05] AFTER BUG 8554980"/>
<bug number="10159846" description="ORA-1 ON SYS.WRH$_TEMPSTATXS_PK WHEN COLLECTING AWR SNAPSHOT"/>
<bug number="10068982" description="PL/SQL PROGRAM REPEATS CONCAT SHOWS SLOW PERFORMANCE AFTER APPLYING 10.2.0.5"/>
<bug number="8350262" description="CREATE DBCONSOLE CERT WITH 10YEAR VALIDITY"/>
<bug number="11792865" description="DB-10.2.0.5-MOLECULE-004-CPUAPR2011"/>
<bug number="7119382" description="V$DATAGUARD STATS RETURNS MISLEADING AND INCONSISTENT RESULTS"/>
<bug number="7361418" description="XF11.2LOGMINER - TRC - KRVTGAUL_GROUPARRAYUPDATELCRS"/>
<bug number="10306945" description="SINCE UPGRADE TO 10.2.0.5 INSTANCE HANGS SEEN WAITING FOR LIBRARY CACHE LATCH"/>
<bug number="8666117" description="LCK0 PROCESS STUCK AT WAITING FOR LATCH ROW CACHE OBJECTS"/>
<bug number="11724962" description="DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)"/>
<bug number="11725006" description="CPUAPR2011 DATABASE 10.2.0.5"/>
<bug number="6157713" description="KTBGDS0() DOES NOT RETURN DEPENDENT SCN FOR INDEX BLOCK THAT HAS BEEN SPLIT"/>
<bug number="10214450" description="FIX FOR BUG 5476091 MAY CAUSE BUG 9929820"/>
<bug number="9184754" description="ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KTCCCENXT], [1], [0], [], [], [], []"/>
<bug number="8966823" description="LMON DIES DUE TO ORA-7445 [KJRCHC()+2318] [SIGSEGV]"/>
<bug number="8544696" description="TABLE GROWTH - BLOCKS ARE NOT REUSED"/>
<bug number="9320130" description="ORA-04031 FOR 'TEMPORARY TABL' ON QUERY WITH STAR TRANSFORMATION - 2"/>
<bug number="9767674" description="ORA-7445 [ACCESS_VIOLATION] [KKSLMTL+448] AFTER APPLYING PATCH 34"/>
<bug number="9323583" description="EUS CONNECTIONS ORA-00600 [KZLDSEARCH2] [RDBMS TO LDAP CHARACTERSET CONVERSION F"/>
<bug number="7026523" description="ORA-07445 [KDBLAILB] ERRORS WHILE USING IMPDP"/>
<bug number="9399589" description="WITH SUBQUERIES CANNOT BE MATERIALIZED INSIDE A GLOBAL TRANSACTION"/>
<bug number="8277300" description="ORA-7445[XTYQBCB] OCCURS DURING EXECUTING SQL THAT USES 60000 BIND VARIABLES."/>
<bug number="9672816" description="DBRM SIGNALED ORA-7445[KSLDCLT_CLN()+297]"/>
<bug number="13343467" description="CPUJAN2012 DATABASE 10.2.0.5"/>
<bug number="9726739" description="FST RSF; ORA-00997 ON EXECTUING SQL CONTAINING CONNECT BY AND UNION CLAUSE"/>
<bug number="9499302" description="IMPROVEMENTS TO KGX MUTEXES (USING VOLATILES END WAIT BEFORE MUTEX GET)"/>
<bug number="8412426" description="WARNING;COULD NOT LOWER THE ASYNCH I/O LIMIT TO 912 FOR SQL DIRECT I/O."/>
<bug number="10165083" description="PROCEDURE TRIES TO WRITE TO A WRONG SCHEMA (CHILD CURSORS MISMATCH) IN 10.2.0.5"/>
<bug number="10208905" description="WARNING COULD NOT INCREASE THE ASYNCH I/O LIMIT"/>
<bug number="12419392" description="DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)"/>
<bug number="6651220" description="ORA-7445 [TTCFOPR] IS RAISED WHEN PL/SQL USING DBLINK"/>
<bug number="9150282" description="ORA-600[KKSFBC-REPARSE-INFINITE-LOOP] OCCUR ON VIEW AFTER DDL ON PARTITION TABLE"/>
<bug number="9145204" description="HWM L2 BMB IS EXCLUDED FROM SEARCH REJECTION"/>
<bug number="9659614" description="HUGE ORA-8103 TRACE FILES GENERATED AFTER PATCH 7519406 APPLIED"/>
<bug number="9949948" description="PROCESS SPIN UNDER KSFDRWAT0 IF AIO-MAX-NR TOO LOW"/>
<bug number="11076894" description="ALTER INDEX [NO]PARALLEL REQUIRES UNNECCESSARY X-LOCK"/>
<bug number="10327179" description="DB-10.2.0.5-MOLECULE-002-CPUJAN2011"/>
<bug number="8882576" description="GES RESOURCE INCREASES CONTINUOUSLY."/>
<bug number="7612454" description="DSS PERF REGRESSIONS IN SERIAL DIRECT READS"/>
<bug number="7111619" description="PQ SLAVE GOT IPC SEND TIMEOUT DETECTED"/>
<bug number="7450366" description="DOAUTOBACKUP PROCEDURE IN RECOVER.BSQ IS NOT ENCAPSULATED BY EXCEPTION HANDLING"/>
<bug number="9711859" description="ORA-600 [KTSPTRN_FIX-EXTMAP] DURING EXTENT ALLOCATION"/>
<bug number="11893577" description="LMD CRASHED WITH ORA-00600 [KJCCGMB 1]"/>
<bug number="9714832" description="ENHANCE CAUSE/ACTION FIELDS OF THE INTERNAL ERROR ORA-07445"/>
<bug number="9735237" description="ORA-7445 [_INTEL_FAST_MEMCMP()+30] DURING STRESS TESTING"/>
<bug number="8970313" description="STALE FILE CACHE IN RAC ENV AFTER TABLESPACE DROP AND RECREATE"/>
<bug number="6011045" description="NEWLY CREATED RAC DATABASE LOCKS UP WITH ORA-20 AND ORA-18"/>
<bug number="11814891" description="ORA-600 [7999] [9] [1] [<LOB BLOCK RDBA>] DOUBLE ALLOCATED LOB BLOCK"/>
<bug number="10162036" description="ORA-600 [KCRRULI.3] AND ORA-600 [KCRRPSRL.7]"/>
<bug number="10248542" description="DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)"/>
<bug number="9952230" description="DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)"/>
<bug number="9469117" description="INDEX WITH DELETED KEYS WRONG RESULTS. OERI [KDSGRP1] / ORA-1499 BY ANALYZE"/>
<bug number="13359623" description="DB-10.2.0.5-MOLECULE-019-CPUJAN2012"/>
<bug number="9952270" description="CPUOCT2010 DATABASE 10.2.0.5"/>
<bug number="9842573" description="MVIEW REFRESH GET ORA-3113 WITH AUDIT"/>
<bug number="13343471" description="DATABASE PSU 10.2.0.5.6 (INCLUDES CPUJAN2012)"/>
<bug number="8660422" description="SINCE APPLYING PATCH FOR 8624887 UNSPECIFIED WAIT EVENT IS SEEN IN AWR"/>
<bug number="10324526" description="ORA-600 [KDDUMMY_BLKCHK] [6106] WHEN UPDATE SUBPARTITION OF TABLE IN TTS"/>
<bug number="11066597" description="DISKGROUP WAS DISMOUNTED WHILE STORAGE CABLE WAS PULLED OUT ON THE OTHER NODE."/>
<bug number="12419258" description="CPUJUL2011 DATABASE 10.2.0.5"/>
<bug number="9322219" description="ORA-07445 [_MEMMOVE()+128] OCCURRED"/>
<bug number="8636407" description="INSTANCE CRASH DUE TO INTERNAL ERROR ENCOUNTERED BY PMON"/>
<bug number="9713537" description="ENHANCE CAUSE/ACTION FIELDS OF THE INTERNAL ERROR ORA-00600"/>
<bug number="12828105" description="CPUOCT2011 DATABASE 10.2.0.5"/>
<bug number="10010310" description="ORA-27300; INVALID_PROCESS_ID FAILED WITH STATUS; 0; ORA-27302; SKGPALIVE1"/>
<bug number="9390484" description="ORA-600 [KDIMSTART;KDIGNBK-LOOP] DURING ALTER INDEX COALESCE"/>
<bug number="9824435" description="ORA-600 INTERNAL ERROR CODE, ARGUMENTS [KOKEGPINLOB1]"/>
<bug number="12925532" description="DB-10.2.0.5-MOLECULE-018-CPUOCT2011"/>
<bug number="9963497" description="DB:10.2.0.5-MOLECULE-001-CPUOCT2010"/>
<bug number="9032322" description="FAST SPLIT OF LIST SUBPARTITION WITH COMPRESS KEY INDEX PRODUCES CORRUPT INDEX"/>
<bug number="12862186" description="DB-10.2.0.5-MOLECULE-016-CPUOCT2011"/>
<bug number="12551700" description="DB-10.2.0.5-MOLECULE-006-CPUJUL2011"/>
<bug number="12862187" description="DB-10.2.0.5-MOLECULE-017-CPUOCT2011"/>
<bug number="12551701" description="DB-10.2.0.5-MOLECULE-007-CPUJUL2011"/>
<bug number="10249537" description="CPUJAN2011 DATABASE 10.2.0.5"/>
<bug number="12551702" description="DB-10.2.0.5-MOLECULE-008-CPUJUL2011"/>
<bug number="12551703" description="DB-10.2.0.5-MOLECULE-009-CPUJUL2011"/>
<bug number="9586877" description="THE FIX FOR BUG 7526851 ( BUG 8494071) NEEDS REWORKING TO AVOID ORA-904 ERRORS"/>
<bug number="8211733" description="SHARED POOL LATCH CONTENTION ON SHRINK"/>
<bug number="12551704" description="DB-10.2.0.5-MOLECULE-010-CPUJUL2011"/>
<bug number="10076669" description="ONE OF THE RAC INSTANCE CRASHED WITH ORA-600 [KJMCHKISEQ !SEQ] AFTER ORA-4031"/>
<bug number="6694396" description="V$ARCHIVE_DEST_STATUS STANDBY_LOGFILE_COUNT INCORRECT"/>
<bug number="9548269" description="TRUNCATE INTERIM TABLE IN ABORT_REDEF_TABLE"/>
<bug number="12551705" description="DB-10.2.0.5-MOLECULE-011-CPUJUL2011"/>
<bug number="12551706" description="DB-10.2.0.5-MOLECULE-012-CPUJUL2011"/>
<bug number="9337325" description="ORA-600 [KQLIDPFGR; DEPOBPO] ON DROP PARTITION"/>
<bug number="12551707" description="DB-10.2.0.5-MOLECULE-013-CPUJUL2011"/>
<bug number="8354642" description="INTERMITTENT ORA-01115/ORA-27091/ORA-27069 WHILE RUNNING RMAN BACKUPS"/>
<bug number="7602341" description="10GR2 INSTANCE CRASHED ORA-00600 [KFFMUNLOCK_3] WITH 11.1.0.6 ASM"/>
<bug number="12551708" description="DB-10.2.0.5-MOLECULE-014-CPUJUL2011"/>
<bug number="9308296" description="ASSM_TABLESPACE_VERIFY REPORT MANY INCONISTENCY MESSAGES."/>
<bug number="12827745" description="DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011)"/>
<bug number="9072105" description="PROBLEM WITH BIND COMPARISON CODE"/>
<bug number="8528171" description="HIGH SHARED POOL USAGE DUE TO FREQUENT ADD/EXCHANGE PARTITION OPERATIONS"/>
<bug number="10157402" description="LOB SEGMENT HAS NULL DATA AFTER LONG TO LOB CONVERSION IN PARALLEL MODE"/>
<bug number="12565867" description="XML PARSER FAILING WITH LPX-00287"/>
<bug number="11737047" description="FIX FOR 7022700 INCLUDED IN RELEASE 10.2.0.5.0 CAN CAUSE NEW PROBLEM 11071514"/>
</base_bugs>
<required_components>
<component internal_name="oracle.rdbms" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.rdbms.rsf" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.rdbms.dbscripts" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.rdbms.dv" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.network.rsf" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.rdbms.dv.oc4j" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.sysman.bsln" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.sysman.repository.core" version="10.2.0.5.0a" opt_req="O"/>
<component internal_name="oracle.sysman.console.db" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.xdk.rsf" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.precomp.common" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.rdbms.rman" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.sdo.locator" version="10.2.0.5.0" opt_req="O"/>
<component internal_name="oracle.network.cman" version="10.2.0.5.0" opt_req="O"/>
</required_components>
<os_platforms>
<platform name="Linux x86-64" id="226"/>
</os_platforms>
<executables>
<executable path="%ORACLE_HOME%/bin/oracle"/>
<executable path="%ORACLE_HOME%/bin/wrap"/>
<executable path="%ORACLE_HOME%/bin/proc"/>
<executable path="%ORACLE_HOME%/bin/rman"/>
<executable path="%ORACLE_HOME%/bin/cmadmin"/>
<executable path="%ORACLE_HOME%/bin/kfod"/>
</executables>
<instance_shutdown>true</instance_shutdown>
<online_rac_installable>true</online_rac_installable>
<run_as_root>false</run_as_root>
<wls_prereq_oneoffs></wls_prereq_oneoffs>
<prereq_oneoffs></prereq_oneoffs>
<overlay_oneoffs></overlay_oneoffs>
<patch_type value="singleton"/>
<product_family value="db"/>
<auto>false</auto>
<update_components></update_components>
</oneoff_inventory>
[oracle@vrh8 13343471]$ cd /home/oracle/
[oracle@vrh8 ~]$ ls -ld 13343471/
drwxr-xr-x 5 oracle oinstall 4096 Dec 21 00:48 13343471/
使用 opatch prereq CheckConflictAgainstOHWithDetail 检验补丁是否与当前$ORACLE_HOME下的patch冲突
[oracle@vrh8 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13343471
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.
PREREQ session
Oracle Home : /s01/oracle/product/10.2.0.5/db_1
Central Inventory : /s01/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /s01/oracle/product/10.2.0.5/db_1/oui
Log file location : /s01/oracle/product/10.2.0.5/db_1/cfgtoollogs/opatch/opatch2012-04-18_06-14-37AM.log
Patch history file: /s01/oracle/product/10.2.0.5/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
4. 正式 实施PSU 10.2.0.5.6 DB/RDBMS 补丁， apply该patch会导致oracle binary 2进制文件被重新make
[oracle@vrh8 ~]$ opatch apply ./13343471
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 : /s01/oracle/product/10.2.0.5/db_1
Central Inventory : /s01/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /s01/oracle/product/10.2.0.5/db_1/oui
Log file location : /s01/oracle/product/10.2.0.5/db_1/cfgtoollogs/opatch/opatch2012-04-18_06-14-56AM.log
Patch history file: /s01/oracle/product/10.2.0.5/db_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '13343471' to OH '/s01/oracle/product/10.2.0.5/db_1'
Running prerequisite checks...
Patch 13343471: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle.network.cman, 10.2.0.5.0 ]
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
..........................
Running make for target client_sharedlib
Running make for target ioracle
Running make for target iwrap
Running make for target client_sharedlib
Running make for target proc
Running make for target irman
ApplySession adding interim patch '13343471' to inventory
Verifying the update...
Inventory check OK: Patch ID 13343471 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 13343471 are present in Oracle Home.
The local system has been patched and can be restarted.
用 opatch lsinventory -bugs_fixed 命令确认已安装的patch fix 修复
[oracle@vrh8 ~]$ opatch lsinventory -bugs_fixed
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 : /s01/oracle/product/10.2.0.5/db_1
Central Inventory : /s01/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /s01/oracle/product/10.2.0.5/db_1/oui
Log file location : /s01/oracle/product/10.2.0.5/db_1/cfgtoollogs/opatch/opatch2012-04-18_06-17-20AM.log
Patch history file: /s01/oracle/product/10.2.0.5/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /s01/oracle/product/10.2.0.5/db_1/cfgtoollogs/opatch/lsinv/lsinventory2012-04-18_06-17-20AM.txt
------------------------------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0
There are 2 products installed in this Oracle Home.
List of Bugs fixed by Installed Patches:
Bug Fixed by Installed at Description
Patch
--- -------- ------------ -----------
6011045 13343471 Wed Apr 18 06:16:09 EDT 2012 NEWLY CREATED RAC DATABASE LOCKS UP WITH ORA-20
AND ORA-18
6157713 13343471 Wed Apr 18 06:16:09 EDT 2012 KTBGDS0() DOES NOT RETURN DEPENDENT SCN FOR INDEX
BLOCK THAT HAS BEEN SPLIT
6402302 13343471 Wed Apr 18 06:16:09 EDT 2012 DROP SYNONYM DDL IS NOT CAPTURED/PROPAGATED OR APP
LIED
6651220 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-7445 [TTCFOPR] IS RAISED WHEN PL/SQL USING DBL
INK
6694396 13343471 Wed Apr 18 06:16:09 EDT 2012 V$ARCHIVE_DEST_STATUS STANDBY_LOGFILE_COUNT INCORR
ECT
7026523 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-07445 [KDBLAILB] ERRORS WHILE USING IMPDP
7111619 13343471 Wed Apr 18 06:16:09 EDT 2012 PQ SLAVE GOT IPC SEND TIMEOUT DETECTED
7119382 13343471 Wed Apr 18 06:16:09 EDT 2012 V$DATAGUARD STATS RETURNS MISLEADING AND
INCONSISTENT RESULTS
7361418 13343471 Wed Apr 18 06:16:09 EDT 2012 XF11.2LOGMINER - TRC - KRVTGAUL_GROUPARRAYUPDATELC
RS
7450366 13343471 Wed Apr 18 06:16:09 EDT 2012 DOAUTOBACKUP PROCEDURE IN RECOVER.BSQ IS NOT
ENCAPSULATED BY EXCEPTION HANDLING
7509714 13343471 Wed Apr 18 06:16:09 EDT 2012 CPM 9667 UNIQUE CONSTRAINT
(SYS.I_INDSUBPART_POBJSUBPART$) ERROR REBUILD INDE
XES
7519406 13343471 Wed Apr 18 06:16:09 EDT 2012 'J000' TRACE FILE REGARDING GATHER_STATS_JOB
INTERMITTENTLY SINCE 10.2.0.4
7602341 13343471 Wed Apr 18 06:16:09 EDT 2012 10GR2 INSTANCE CRASHED ORA-00600 [KFFMUNLOCK_3]
WITH 11.1.0.6 ASM
7612454 13343471 Wed Apr 18 06:16:09 EDT 2012 DSS PERF REGRESSIONS IN SERIAL DIRECT READS
8211733 13343471 Wed Apr 18 06:16:09 EDT 2012 SHARED POOL LATCH CONTENTION ON SHRINK
8224558 13343471 Wed Apr 18 06:16:09 EDT 2012 DBBETA EXCESSIVE ARCHIVE LOGGING GENERATED WHEN
REQUIRED LOGFILE DELETED
8277300 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-7445[XTYQBCB] OCCURS DURING EXECUTING SQL
THAT USES 60000 BIND VARIABLES.
8350262 13343471 Wed Apr 18 06:16:09 EDT 2012 CREATE DBCONSOLE CERT WITH 10YEAR VALIDITY
8354642 13343471 Wed Apr 18 06:16:09 EDT 2012 INTERMITTENT ORA-01115/ORA-27091/ORA-27069 WHILE
RUNNING RMAN BACKUPS
8394351 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-12801; ERROR SIGNALED IN PARALLEL QUERY
SERVER P005 RUNNING DM QUERY
8412426 13343471 Wed Apr 18 06:16:09 EDT 2012 WARNING;COULD NOT LOWER THE ASYNCH I/O LIMIT TO
912 FOR SQL DIRECT I/O.
8488233 13343471 Wed Apr 18 06:16:09 EDT 2012 WHEN DDL CHANGES CT FILE SIZE, IT'S POSSIBLE THAT
CTWR FOB IS STALE
8528171 13343471 Wed Apr 18 06:16:09 EDT 2012 HIGH SHARED POOL USAGE DUE TO FREQUENT
ADD/EXCHANGE PARTITION OPERATIONS
8544696 13343471 Wed Apr 18 06:16:09 EDT 2012 TABLE GROWTH - BLOCKS ARE NOT REUSED
8546356 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [KDSGRP1] AFTER REBUILD INDEX ONLINE WHEN
CONCURRENT W/ UPDATES
8636407 13343471 Wed Apr 18 06:16:09 EDT 2012 INSTANCE CRASH DUE TO INTERNAL ERROR ENCOUNTERED
BY PMON
8650138 13343471 Wed Apr 18 06:16:09 EDT 2012 PMON SIGNALLED ORA-7445[KOKLCOM()+504] AND
TERMINATED THE INSTANCES
8660422 13343471 Wed Apr 18 06:16:09 EDT 2012 SINCE APPLYING PATCH FOR 8624887 UNSPECIFIED WAIT
EVENT IS SEEN IN AWR
8664189 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-00600 [KDISS_UNCOMPRESS: BUFFER LENGTH]
8666117 13343471 Wed Apr 18 06:16:09 EDT 2012 LCK0 PROCESS STUCK AT WAITING FOR LATCH ROW CACHE
OBJECTS
8771916 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-00600 [KDSGRP1] WHEN DOING AN UPDATE
8865718 13343471 Wed Apr 18 06:16:09 EDT 2012 RECURSIVE CURSORS CONTAINING 'AS OF SNAPSHOT'
CLAUSE ARE NOT SHARED
8882576 13343471 Wed Apr 18 06:16:09 EDT 2012 GES RESOURCE INCREASES CONTINUOUSLY.
8966823 13343471 Wed Apr 18 06:16:09 EDT 2012 LMON DIES DUE TO ORA-7445 [KJRCHC()+2318] [SIGSEGV
]
8970313 13343471 Wed Apr 18 06:16:09 EDT 2012 STALE FILE CACHE IN RAC ENV AFTER TABLESPACE DROP
AND RECREATE
9020537 13343471 Wed Apr 18 06:16:09 EDT 2012 DBMS_LOB.SUBSTR TRUNCATES LOBS IN AL32UTF8
9024850 13343471 Wed Apr 18 06:16:09 EDT 2012 WRONG RESULTS USING ORA_ROWSCN
9032322 13343471 Wed Apr 18 06:16:09 EDT 2012 FAST SPLIT OF LIST SUBPARTITION WITH COMPRESS KEY
INDEX PRODUCES CORRUPT INDEX
9072105 13343471 Wed Apr 18 06:16:09 EDT 2012 PROBLEM WITH BIND COMPARISON CODE
9109487 13343471 Wed Apr 18 06:16:09 EDT 2012 DBMS_SPACE.ISDATAFILEDROPPABLE_NAME THROWS
NUMERIC OVERFLOW
9145204 13343471 Wed Apr 18 06:16:09 EDT 2012 HWM L2 BMB IS EXCLUDED FROM SEARCH REJECTION
9150282 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600[KKSFBC-REPARSE-INFINITE-LOOP] OCCUR ON
VIEW AFTER DDL ON PARTITION TABLE
9171933 13343471 Wed Apr 18 06:16:09 EDT 2012 FALSE CONTENTION INTRODUCED BY BUG FIX - 5632050
9184754 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-00600 INTERNAL ERROR CODE, ARGUMENTS
[KTCCCENXT], [1], [0], [], [], [], []
9308296 13343471 Wed Apr 18 06:16:09 EDT 2012 ASSM_TABLESPACE_VERIFY REPORT MANY INCONISTENCY ME
SSAGES.
9320130 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-04031 FOR 'TEMPORARY TABL' ON QUERY WITH STAR
TRANSFORMATION - 2
9322219 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-07445 [_MEMMOVE()+128] OCCURRED
9323583 13343471 Wed Apr 18 06:16:09 EDT 2012 EUS CONNECTIONS ORA-00600 [KZLDSEARCH2] [RDBMS TO
LDAP CHARACTERSET CONVERSION F
9337325 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [KQLIDPFGR; DEPOBPO] ON DROP PARTITION
9360157 13343471 Wed Apr 18 06:16:09 EDT 2012 WRONG RESULTS WHEN USING ORA_ROWSCN PSEUDOCOLUMN
USING ANSI JOIN
9390484 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [KDIMSTART;KDIGNBK-LOOP] DURING ALTER
INDEX COALESCE
9399589 13343471 Wed Apr 18 06:16:09 EDT 2012 WITH SUBQUERIES CANNOT BE MATERIALIZED INSIDE A
GLOBAL TRANSACTION
9469117 13343471 Wed Apr 18 06:16:09 EDT 2012 INDEX WITH DELETED KEYS WRONG RESULTS. OERI
[KDSGRP1] / ORA-1499 BY ANALYZE
9499302 13343471 Wed Apr 18 06:16:09 EDT 2012 IMPROVEMENTS TO KGX MUTEXES (USING VOLATILES END
WAIT BEFORE MUTEX GET)
9532911 13343471 Wed Apr 18 06:16:09 EDT 2012 LOB SHOWING INCORRECT DATA ON DATA GUARD STANDBY S
ITE
9548269 13343471 Wed Apr 18 06:16:09 EDT 2012 TRUNCATE INTERIM TABLE IN ABORT_REDEF_TABLE
9586877 13343471 Wed Apr 18 06:16:09 EDT 2012 THE FIX FOR BUG 7526851 ( BUG 8494071) NEEDS
REWORKING TO AVOID ORA-904 ERRORS
9659614 13343471 Wed Apr 18 06:16:09 EDT 2012 HUGE ORA-8103 TRACE FILES GENERATED AFTER PATCH
7519406 APPLIED
9672816 13343471 Wed Apr 18 06:16:09 EDT 2012 DBRM SIGNALED ORA-7445[KSLDCLT_CLN()+297]
9711859 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [KTSPTRN_FIX-EXTMAP] DURING EXTENT ALLOCAT
ION
9713537 13343471 Wed Apr 18 06:16:09 EDT 2012 ENHANCE CAUSE/ACTION FIELDS OF THE INTERNAL ERROR
ORA-00600
9714832 13343471 Wed Apr 18 06:16:09 EDT 2012 ENHANCE CAUSE/ACTION FIELDS OF THE INTERNAL ERROR
ORA-07445
9726739 13343471 Wed Apr 18 06:16:09 EDT 2012 FST RSF; ORA-00997 ON EXECTUING SQL CONTAINING
CONNECT BY AND UNION CLAUSE
9735237 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-7445 [_INTEL_FAST_MEMCMP()+30] DURING STRESS T
ESTING
9767674 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-7445 [ACCESS_VIOLATION] [KKSLMTL+448] AFTER
APPLYING PATCH 34
9770451 13343471 Wed Apr 18 06:16:09 EDT 2012 APPLICATION CRASHES WITH ORA-00600 [20022]
9772888 13343471 Wed Apr 18 06:16:09 EDT 2012 WARNING;COULD NOT LOWER THE ASYNCH I/O LIMIT TO
160 FOR SQL DIRECT I/O. IT IS SE
9824435 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 INTERNAL ERROR CODE, ARGUMENTS [KOKEGPINLO
B1]
9842573 13343471 Wed Apr 18 06:16:09 EDT 2012 MVIEW REFRESH GET ORA-3113 WITH AUDIT
9949948 13343471 Wed Apr 18 06:16:09 EDT 2012 PROCESS SPIN UNDER KSFDRWAT0 IF AIO-MAX-NR TOO LOW
9952230 13343471 Wed Apr 18 06:16:09 EDT 2012 DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
9952270 13343471 Wed Apr 18 06:16:09 EDT 2012 CPUOCT2010 DATABASE 10.2.0.5
9963497 13343471 Wed Apr 18 06:16:09 EDT 2012 DB:10.2.0.5-MOLECULE-001-CPUOCT2010
10010310 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-27300; INVALID_PROCESS_ID FAILED WITH STATUS;
0; ORA-27302; SKGPALIVE1
10017048 13343471 Wed Apr 18 06:16:09 EDT 2012 DML DOES NOT RUN PARALLEL IN DEEPER NESTING IN
DBMS_JOB AND PL/SQL ON 10.2.0.5
10068982 13343471 Wed Apr 18 06:16:09 EDT 2012 PL/SQL PROGRAM REPEATS CONCAT SHOWS SLOW
PERFORMANCE AFTER APPLYING 10.2.0.5
10076669 13343471 Wed Apr 18 06:16:09 EDT 2012 ONE OF THE RAC INSTANCE CRASHED WITH ORA-600
[KJMCHKISEQ !SEQ] AFTER ORA-4031
10091698 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-00600 [17069] WHEN RUNNING CATUPGRD.SQL
10092858 13343471 Wed Apr 18 06:16:09 EDT 2012 WRONG RESULT WHEN MATERIALIZED VIEW WITH OUTER
JOIN IS FAST REFRESHED
10132870 13343471 Wed Apr 18 06:16:09 EDT 2012 INDEX BLOCK CORRUPTION ORA-600 [KCBZPBUF_2],
[6401] ON RECOVER
10139235 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [KOKCUP 01] AND ORA-600 [KOKCUP 05] AFTER
BUG 8554980
10157402 13343471 Wed Apr 18 06:16:09 EDT 2012 LOB SEGMENT HAS NULL DATA AFTER LONG TO LOB
CONVERSION IN PARALLEL MODE
10159846 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-1 ON SYS.WRH$_TEMPSTATXS_PK WHEN COLLECTING
AWR SNAPSHOT
10162036 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [KCRRULI.3] AND ORA-600 [KCRRPSRL.7]
10165083 13343471 Wed Apr 18 06:16:09 EDT 2012 PROCEDURE TRIES TO WRITE TO A WRONG SCHEMA (CHILD
CURSORS MISMATCH) IN 10.2.0.5
10173237 13343471 Wed Apr 18 06:16:09 EDT 2012 CROSS INSTANCE ARCHIVAL FAILING AFTER UPGRADE TO 1
0.2.0.5
10208905 13343471 Wed Apr 18 06:16:09 EDT 2012 WARNING COULD NOT INCREASE THE ASYNCH I/O LIMIT
10214450 13343471 Wed Apr 18 06:16:09 EDT 2012 FIX FOR BUG 5476091 MAY CAUSE BUG 9929820
10248542 13343471 Wed Apr 18 06:16:09 EDT 2012 DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
10249537 13343471 Wed Apr 18 06:16:09 EDT 2012 CPUJAN2011 DATABASE 10.2.0.5
10269717 13343471 Wed Apr 18 06:16:09 EDT 2012 DBMS_SQL.PARSE CAUSES MEMORY LEAK AFTER APPLYING
PSR 10.2.0.5
10306945 13343471 Wed Apr 18 06:16:09 EDT 2012 SINCE UPGRADE TO 10.2.0.5 INSTANCE HANGS SEEN
WAITING FOR LIBRARY CACHE LATCH
10324526 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [KDDUMMY_BLKCHK] [6106] WHEN UPDATE
SUBPARTITION OF TABLE IN TTS
10327179 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-002-CPUJAN2011
10327190 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-003-CPUAPR2011
11066597 13343471 Wed Apr 18 06:16:09 EDT 2012 DISKGROUP WAS DISMOUNTED WHILE STORAGE CABLE WAS
PULLED OUT ON THE OTHER NODE.
11076894 13343471 Wed Apr 18 06:16:09 EDT 2012 ALTER INDEX [NO]PARALLEL REQUIRES UNNECCESSARY X-L
OCK
11693109 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-481 DUE TO COMMUNICATION ISSUE BETWEEN NODE1
AND NODE6
11724962 13343471 Wed Apr 18 06:16:09 EDT 2012 DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
11725006 13343471 Wed Apr 18 06:16:09 EDT 2012 CPUAPR2011 DATABASE 10.2.0.5
11737047 13343471 Wed Apr 18 06:16:09 EDT 2012 FIX FOR 7022700 INCLUDED IN RELEASE 10.2.0.5.0
CAN CAUSE NEW PROBLEM 11071514
11792865 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-004-CPUAPR2011
11814891 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [7999] [9] [1] [<LOB BLOCK RDBA>] DOUBLE
ALLOCATED LOB BLOCK
11893577 13343471 Wed Apr 18 06:16:09 EDT 2012 LMD CRASHED WITH ORA-00600 [KJCCGMB 1]
12419258 13343471 Wed Apr 18 06:16:09 EDT 2012 CPUJUL2011 DATABASE 10.2.0.5
12419392 13343471 Wed Apr 18 06:16:09 EDT 2012 DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
12551700 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-006-CPUJUL2011
12551701 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-007-CPUJUL2011
12551702 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-008-CPUJUL2011
12551703 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-009-CPUJUL2011
12551704 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-010-CPUJUL2011
12551705 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-011-CPUJUL2011
12551706 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-012-CPUJUL2011
12551707 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-013-CPUJUL2011
12551708 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-014-CPUJUL2011
12551710 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-015-CPUJUL2011
12565867 13343471 Wed Apr 18 06:16:09 EDT 2012 XML PARSER FAILING WITH LPX-00287
12827745 13343471 Wed Apr 18 06:16:09 EDT 2012 DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011)
12828105 13343471 Wed Apr 18 06:16:09 EDT 2012 CPUOCT2011 DATABASE 10.2.0.5
12862186 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-016-CPUOCT2011
12862187 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-017-CPUOCT2011
12925532 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-018-CPUOCT2011
13343467 13343471 Wed Apr 18 06:16:09 EDT 2012 CPUJAN2012 DATABASE 10.2.0.5
13343471 13343471 Wed Apr 18 06:16:09 EDT 2012 DATABASE PSU 10.2.0.5.6 (INCLUDES CPUJAN2012)
13349665 13343471 Wed Apr 18 06:16:09 EDT 2012 ORA-600 [KKSLMTL-VALNOTFOUND] WITH PSU 10.2.0.5.5
13359623 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-019-CPUJAN2012
13489660 13343471 Wed Apr 18 06:16:09 EDT 2012 DB-10.2.0.5-MOLECULE-020-CPUJAN2012
------------------------------------------------------------------------------------------------------
5. 对现有的DB (指在apply 这个psu之前已经创建的DB) 升级数据字典，这需要运行 catbundle.sql
[oracle@vrh8 ~]$ cd $ORACLE_HOME/rdbms/admin
切换到 cd $ORACLE_HOME/rdbms/admin 目录
[oracle@vrh8 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Apr 18 06:17:56 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2095896 bytes
Variable Size 318768360 bytes
Database Buffers 889192448 bytes
Redo Buffers 14680064 bytes
Database mounted.
Database opened.
启动实例 ，并运行 @catbundle.sql psu apply
SQL> @catbundle.sql psu apply
................................
Check the following log file for errors:
/s01/oracle/product/10.2.0.5/db_1/cfgtoollogs/catbundle/catbundle_PSU_G10R25_APPLY_2012Apr18_06_18_46.log
SQL> col comments for a60
SQL> select comments from registry$history;
COMMENTS
------------------------------------------------------------
PSU 10.2.0.5.6
确认oracle软件组件registry 已被升级
最后不要忘记 运行 @utlrp.sql脚本， 编译失效的对象
SQL> @utlrp.sql
之后重启 监听和 实例：
lsnrctl start LISTENER
sqlplus / as sysdba
startup ;
但是请注意升级PSU或 CPU 补丁 并不会让 v$version视图中的 版本号 发生变化，apply PSU 10.2.0.5.6 后 仍是10.2.0.5 ， 这是正常现象。
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production |
|
发表于 2012-5-15 21:29:14
|手机版|Archiver|Oracle数据库数据恢复、性能优化
IP卡
狗仔卡
分享
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡