ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle9i高级复制的一个bug

Oracle9i高级复制的一个bug

原创 Linux操作系统 作者:husthxd 时间:2004-12-10 00:00:00 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
ITPUB数据库版块资深版主,对Oracle、PostgreSQL有深入研究。现就职于广州云图数据技术有限公司,系统架构师。

注册时间:2007-12-28

  • 博文量
    1391
  • 访问量
    3839051