Oracle9i高级复制的一个bug

os hp-ux 11.11
oracle 9.2.0.6 RAC
Oracle9i高级复制的一个bug

os hp-ux 11.11
oracle 9.2.0.6 RAC

今天在内网更新一张表(update)的时候报错：
ORA-23474 definition of %s . %s has changed since generation of replicat

查oracle文档，发现需要重新生产复制对象的复制支持。
Error: ORA-23474
Text: definition of %s . %s has changed since generation of replication
support
---------------------------------------------------------------------------
Cause: The current columns in the specified table and their column types do
not match the columns and column types when replication support was
last generated.
Action: Regenerate replication support for the affected table. All flavors
that include the specified table should also be checked for validity.
.
由于内外网隔离，暂时还不能生成，继续查文档，发现oracle的一个bug：
Bug 2844585 Intermittent ORA-23474 on replication objects
This note gives a brief overview of bug 2844585.
Affects:
Product (Component) Oracle Server (RDBMS)
Range of versions believed to be affected Versions < 10G
Versions confirmed as being affected · 9.2.0.3
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in · 9.2.0.4 (Server Patch Set) · 10G Production Base Release
Symptoms:
· Error may occur
· ORA-23474
Related To:
· Replication
Description

Replication objects may fail with ORA-23474 if the objects are
unaltered.

Workaround:
Flush shared pool & during the first access to the
replication object (that is when metadata is loaded into library cache)
make sure there are no Ctrl-C (interrupts) in the user session.

抱着一试的心态用alter system flush shared_pool ;把两个节点的shared pool flush后发现可以更新成功，文档上虽然说这个bug在9204已经修复，结果在9206又给引入了，看来还是bug多多。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/6906/viewspace-21665/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/6906/viewspace-21665/