February 27, 2008
Patchset 10.2.0.4中关于ASM的Buglist
作者:eygle
出处:http://blog.eygle.com
今天下载了10g Release 2 (10.2.0.4) Patch Set 3，这个Patch将近1G，是个大块头。Oracle从10g开始，减小了安装包的大小，但是Patchset却是越来越大。
这个patch set的Buglist也有1.5M左右，我上传到网站上供大家参考。
最近在关注一些ASM方面的内容，所以将这个patch中和ASM相关的Bug列举出来，大家可以对照一下，甚至逐一研究一下这个Bug，看这些Bug有否可能在自己的环境中出现。
简单统计一下，ASM相关Bug中:
10.2.0.4中修正36个，以下是ASM的Bug列表，供参考:
10.2.0.3中修正29个，
10.2.0.2中修正14个
| Fixed in Release | Bug Number | Description |
|---|---|---|
| 10.2.0.4 | 5526987 * | ASM instance hang / OERI [2103] on DB instance. This bug is alerted in Note:468572.1 |
| 10.2.0.4 | 5081798 + | Additional diagnostics for OERI[2103] when ASM involved |
| 10.2.0.4 | 6051728 P* | HPUX Itanium: Cannot use ASM (ORA-15059). This bug is alerted in Note:434500.1 |
| 10.2.0.4 | 4110313 | ASM disk resize fails for OS devices grown after ASM instance startup |
| 10.2.0.4 | 4319031 | Wrong header_status in V$ASM_DISK when disk is offline |
| 10.2.0.4 | 4380450 | Unbalanced space usage if diskgroup has only two disks, both of different size |
| 10.2.0.4 | 4431215 | "backup archivelog all delete input" from RMAN removes ASM directory |
| 10.2.0.4 | 4489948 | ASM hangs during a parallel mount and shutdown in RAC |
| 10.2.0.4 | 4767278 | OERI[kcrrupirfs.20] archiving redo to standby with ASM |
| 10.2.0.4 | 5230765 | LGWR spins while waiting for 'log file parallel write' using ASM |
| 10.2.0.4 | 5471453 | OERI[kfkfilrqarr01] using ASM |
| 10.2.0.4 | 5472917 | DBVERIFY may error if ASM disk disconnected |
| 10.2.0.4 | 5483613 | OERI [kfgscAcquireLcl_6] in ASM |
| 10.2.0.4 | 5502365 | OERI [kfcDel20] in ASM |
| 10.2.0.4 | 5504989 | PMON dump [kfgGlobalClose] / instance crash |
| 10.2.0.4 | 5554692 | Error ORA-15196 reporting ASM block header invalid ora-15196 after ORA-600[kfcgetbuffer10] |
| 10.2.0.4 | 5555908 | OERI[kghstack_underflow_internal_2] in kfrcsoDelete |
| 10.2.0.4 | 5556674 | V$ASM* dynamic views leak cursors (ORA-01000) |
| 10.2.0.4 | 5575584 | Failure of an entire failure group is detected one disk at a time |
| 10.2.0.4 | 5576584 | Poor ASM parallel read performance |
| 10.2.0.4 | 5682184 | OERI[kfdAuDealloc2] from resize/drop more than 16TB ASM file |
| 10.2.0.4 | 5743325 | ASM instance fails with OERI[kfaDropCOP04] |
| 10.2.0.4 | 5757711 | ORA-15080 during file creation / resize on ASM with HARD |
| 10.2.0.4 | 5757752 | OERI:kghstack_alloc / OERI:kfcbCkpt04 / ASM crash |
| 10.2.0.4 | 5761185 | ORA-15041 diskgroup space exhausted after adding disks to a diskgroup |
| 10.2.0.4 | 5891737 | Dump (kcblsod) / OERI:723 / Memory leak in ASM/RAC |
| 10.2.0.4 | 5893614 | Full table scan very slow on ASM |
| 10.2.0.4 | 5899033 | SMON dump (kfrCheckCtx) diskgroup instance recovery |
| 10.2.0.4 | 5909894 | ASM datafile lost after rename (ORA-1157) |
| 10.2.0.4 | 5922733 | ASM dump in kfkdumprq with event=15199 level=1050631 |
| 10.2.0.4 | 5939241 | Inconsistent diskgroup configuration after rejected DISK OFFLINE |
| 10.2.0.4 | 6013983 | ASM signals OERI [kfdasecondaries01] / [kffrelocate87] during rebalance |
| 10.2.0.4 | 6069360 | DBW can spin in kfcRunnableWaiter holding a latch in ASM |
| 10.2.0.4 | 6139547 | Shadow process leak on ASM instance when diskspace exhausted (ORA-20) |
| 10.2.0.4 | 6334552 | Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize |
| 10.2.0.4 | 6453944 | ORA-15196 with ASM disks larger than 2TB using ASMLIB |
| 10.2.0.3 | 3811904 | Rebalance can fail if there is one full disk |
| 10.2.0.3 | 3885499 | ASM hang possible |
| 10.2.0.3 | 4229751 | CONVERT TABLESPACE fails to create file with DB_FILE_NAME_CONVERT on ASM |
| 10.2.0.3 | 4450268 | ASM disk mounts are serialized |
| 10.2.0.3 | 4466433 | Restoring current controlfile on ASM creates a file with "backup" string |
| 10.2.0.3 | 4561867 | ASMB may exit prematurely causing OERI in client |
| 10.2.0.3 | 4671721 | OERI [kfcInitDlocn02] possible in ASM instance |
| 10.2.0.3 | 4691191 | Failure during file grow may leak ASM disk space |
| 10.2.0.3 | 4709210 | ASM LMS OERI[504] on [kfcl le freelist] latch |
| 10.2.0.3 | 4709214 | ASM may crash with OERI[kfclGetLock40] |
| 10.2.0.3 | 4752481 | Skewed ASM disk allocation when single file resized many times |
| 10.2.0.3 | 4865736 | ASM resource should not have dependency on VIP |
| 10.2.0.3 | 4872617 | Dump (kfclDumpLe) in ASM |
| 10.2.0.3 | 4883032 | ASM fails with ORA-15096 during crash or instance recovery |
| 10.2.0.3 | 4886660 | ASMB can fail with OERI:kffmAllocate_1 |
| 10.2.0.3 | 4907496 | Processes hang after adding disk back to ASM diskgroup using force option |
| 10.2.0.3 | 4943406 | LMON needs to message SMON to start recovery in ASM instance |
| 10.2.0.3 | 4960705 | ASM waits longer than necessary during reconfiguration |
| 10.2.0.3 | 4966352 | OERI[unsorted_pins_4] possible on ASM |
| 10.2.0.3 | 4967266 | DB recovery blocked by ASM recovery |
| 10.2.0.3 | 5012099 | ASM rebalance problems |
| 10.2.0.3 | 5024639 | ASM hangs if private interface down on a surviving node |
| 10.2.0.3 | 5039964 | ASM disks show as provisioned although kfed shows valid disk header |
| 10.2.0.3 | 5089630 | Dump (kfncInitSlavePool) / ORA-15012 from Log Miner / Streams against LOGs on ASM |
| 10.2.0.3 | 5090822 | OERI[17092] / ORA-10382 when ASM IO completes concurrently with DISKGROUP dismount |
| 10.2.0.3 | 5134663 | OERI[2103] with ASM |
| 10.2.0.3 | 5226903 | OERI:[kfcDeadlockAvoid01] when running "check all repair" |
| 10.2.0.3 | 5360719 | ASM and database instances hang when disk array gets disconnected |
| 10.2.0.3 | 5515492 | Data corruption when ASM failgroup removed |
| 10.2.0.2 | 4747535 * | A diskgroup cannot be mounted on both nodes at the same time. This bug is alerted in Note:353065.1 |
| 10.2.0.2 | 4237629 | OERI[kfdjoin5] on ASM instance with multiple diskgroups |
| 10.2.0.2 | 4362919 | CRS ASM failure recovery does not recover database instances |
| 10.2.0.2 | 4413010 | OERI[kffdmove01] selecting from V$ASM_ALIAS in ASM instance |
| 10.2.0.2 | 4455512 | ASM instance startup can be slow in RAC environments |
| 10.2.0.2 | 4478323 | OERI[kfcDeadlockAvoid01] on SQL against V$ASM_ALIAS |
| 10.2.0.2 | 4490933 | RMAN backup fails when backupsize > free on ASM but reclaimable space available |
| 10.2.0.2 | 4503419 | Cannot drop disk normal with less than 3 failgroups |
| 10.2.0.2 | 4550821 | OERI[kfklufsscannext] in ASM during disk discovery |
| 10.2.0.2 | 4666938 | OERI[kjbdowncvt:__l] can occur in ASM |
| 10.2.0.2 | 4671216 | ASM operations on a file are blocked while it is resized |
| 10.2.0.2 | 4693247 | Dump (kfcgetbuffer) while resizing a tablespace using ASM storage |
| 10.2.0.2 | 4700681 | ASM disk shrinkage can corrupt ASM metadata |
| 10.2.0.2 | 4772979 | OERI[kfdskAlloc0] in RDBMS instance when adding back a dropped disk |
Posted by eygle at 9:24 PM | Comments (1)
Oracle关于Patchset 10.2.0.4的提醒邮件
作者:eygle
出处:http://blog.eygle.com
昨天收到了Oracle发来的一封关于Patchset 10.2.0.4的提示邮件，邮件内容如下：
Dear Oracle Customer,You are receiving this email because our records indicated you downloaded Oracle Database Patchset 10.2.0.4 (Patch 6810189) on the Linux x86 platform:
There was a minor error in the zip file name mentioned in the README.
Section "7.4 Download and Extract the Installation Software" in the README incorrectly mentioned p6810189_10204_LINUX.zip as the file to be downloaded and unzipped. This has now been modified to reflect the correct file name, p6810189_10204_Linux-x86.zip. Apart from this minor change to the README, there is no other change to the patch set content.Please accept our apologies for any inconvenience you may have experienced, and we thank you for your patience and cooperation in securing your Oracle server products.
Regards,
Oracle Global Product Support
我的第一感觉是，Oracle对于客户的跟踪目前做的是相当及时，我访问了这个Patch，Oracle就已经跟踪在案。
邮件的内容是说，补丁中的README文档中存在一个小的瑕疵，原本Patch的名称为p6810189_10204_Linux-x86.zip，文档中误写为p6810189_10204_LINUX.zip，现在作了修正。
比较了一下下载Patch中的README.html文件和patch_note.htm文件，发现只是README.html文件中存在错误，而patch_not.htm文件中的描述是正确的:
G:\Oracle\Linux>diff README.html patch_note.htm
5c5
< <!-- Run date = February 25, 2008 11:28:55 -->
---
> <!-- Run date = February 22, 2008 16:35:29 -->
893c893
< <p>Download the <code>p6810189_10204_Linux-x86.zip</code> patch set installation archive to a dire
ctory that is not the Oracle home directory or under the Oracle home directory.</p>
---
> <p>Download the <code>p6810189_10204_LINUX.zip</code> patch set installation archive to a director
y that is not the Oracle home directory or under the Oracle home directory.</p>
898c898
< $ unzip p6810189_10204_Linux-x86.zip
---
> $ unzip p6810189_10204_LINUX.zip
看来Oracle的文档管理也是极其混乱的。这样自相矛盾的错误也会出现。
这是一个小问题，我们可以顺便了解一下Oracle补丁集的命名规则，那就是：
p<patch number>_<release number>_<os>.zip
根据这个规则，我们可以很容易获得Metalink ftp站点上的文件名称：
oracle 9208patch:
ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.ziporacle 10.2.0.4
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
结合你的Metalink帐号，我们就可以使用flashget从Metalink上快速Download补丁了。
-The End-
Posted by eygle at 12:32 PM | Comments (3)