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多多。