« DBA警示录:Move数据表与索引重建 | Blog首页 | 个人网站之CPU超高负载 »
安装了Oracle10g 10.2.0.3 感受众多BUG
作者：eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接：https://www.eygle.com/archives/2007/05/install_oracle10g_10203.html
今天，终于还是在笔记本上装上了Oracle，打过Patch之后的版本是10.2.0.3链接：https://www.eygle.com/archives/2007/05/install_oracle10g_10203.html
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
看一下Bug修正列表，在关心的几个环节浏览了一下。
首先是ASSM的一堆Bug：
| Fixed in Release | Bug Number | Description |
|---|---|---|
| 10.2.0.3 | 3279497 | Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table |
| 10.2.0.3 | 3610777 | Excessive CPU from INDEX insert into ASSM index segment |
| 10.2.0.3 | 4055634 | TRUNCATE table has to much overhead when operating on empty segments |
| 10.2.0.3 | 4188324 | Wasted space possible in ASSM segments |
| 10.2.0.3 | 4475314 | DELETE then INSERT without commit on ASSM segment can be slow |
| 10.2.0.3 | 4660718 | Allow choice between space / performance for ASSM segments |
| 10.2.0.3 | 4694312 | Index inserts to ASSM segments can be slow |
| 10.2.0.3 | 4887955 | Unnecessary extent allocated in locally managed ASSM tablespace in RAC |
| 10.2.0.3 | 5034679 | Hang / errors making ASSM tablespace read only with concurrent DML |
| 10.2.0.3 | 5349632 | Poor performance for ASSM insert after large DELETE |
| 10.2.0.2 | 4288876 | Excessive redo / undo generation from insert/update with ASSM indexes |
| 10.2.0.2 | 4486753 | DMLS contention with ASSM segments |
| 10.2.0.2 | 4517470 | Table corruption with RAC when ASSM managed and truncate used |
不看不知道，一看吓一跳吧，ASSM的Bug还真不少，而且还都是比较恐怖的Bug。
再看看10g的一大亮点ASM的BUG：
| Fixed in Release | Bug Number | Description |
|---|---|---|
| 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 |
建议大家看看Bug列表，还是有好处的，这就可以知道在自己的产品环境上可以去避免哪些问题。
这些Bug遇到的不多，不错CRS的Bug却是遇到了不少，BUG列表里关于CRS的BUG太多，不列了。
-The End-
历史上的今天...
>> 2019-05-29文章:
>> 2016-05-29文章:
>> 2008-05-29文章:
>> 2006-05-29文章:
By eygle on 2007-05-29 16:27 | Comments (13) | Oracle12c/11g | 1447 |
不知道Bugs里面有没有救世主呢？
bug list 不能看，看了就不敢用了！^|^
bug的描述这么含糊？
好多can be slow?
这样的问题开发也能接受？slow的依据？
受不了了
请问怎么从metalink上看到某个数据库版本的bug list呢？
你搜索List of Bugs Fixed就能找到大部分Bug列表了。
还有很多bug没有列在里面的也解决了,metalink上特地问了Oracle才确定.
升级的patch本身也有bug,升好以后sqlnet.ora被覆盖了，还好有备份。
好歹人家一直在改进的了
而且,以前的版本也是一大堆bug list
还是不看了
看了真的不敢用了
我记得9201的patch都有接近1个g,疯狂的说
是有改进了，Oracle的进步还是很大的。
很多bug都是在很特定的环境下才会出现的，所以即使oracle每个version都修复那么那么多的bug，实际上大家碰到的有多少？100个？我相信没有这么多吧。所以，buglist不看也罢，呵呵。
我们的新系统都是上的10203
10.2.0.3好很多，而且很多特性和Oracle11g是兼容的。
10.2.0.3好多了，算是一个比较稳定的版本。