oracle10安装65%报错,安装了Oracle10g 10.2.0.3 感受众多BUG

安装了Oracle10g 10.2.0.3 感受众多BUG

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-

By eygle on 2007-05-29 16:27 |

Comments (13) |

Oracle12c/11g | 1447 |

13 Comments

不知道Bugs里面有没有救世主呢？

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,疯狂的说

很多bug都是在很特定的环境下才会出现的，所以即使oracle每个version都修复那么那么多的bug，实际上大家碰到的有多少？100个？我相信没有这么多吧。所以，buglist不看也罢，呵呵。

10.2.0.3好很多，而且很多特性和Oracle11g是兼容的。

10.2.0.3好多了，算是一个比较稳定的版本。