我只找到这样一个,也许看看其中提到的catdefrt.sql这个文件会不会有帮助?
Subject: Replication of Updatable snapshots fails.
RDBMS Version: 8.0.5
Operating System and Version: RS6000 AIX 4.2.1
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Replication Manager
Product Version:
Replication of Updatable snapshots fails.
Hi, the environment is a master site and 2 snapshots sites replicating both updatable and read-only snapshots. Both having working for 2 months until the updatable snapshots replication at both remote sites stopped working one after another about 2 weeks apart. BUt the read-only replication are still working normally. The alert log files in the snapshot site had these errors:
ORA-12012: error on auto execute of job 81
ORA-23388: replication parallel push watermark error
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_IREFRESH", line 450
ORA-06512: at "SYS.DBMS_REFRESH", line 182
ORA-06512: at line 1
Tue Apr 04 18:00:35 2000
Errors in file E:\orant\rdbms80\trace\alpjSNP0.TRC:
ORA-12012: error on auto execute of job 1
ORA-25205: the QUEUE SYSTEM.DEF$_AQERROR does not exist
ORA-06512: at "SYS.DBMS_DEFER_ENQ_UTL", line 104
ORA-06512: at "SYS.DBMS_DEFER_INTERNAL_SYS", line 450
ORA-01085: preceding errors in deferred rpc to "SYS.DBMS_DEFER_INTERNAL_SYS.ERROR_ARG_VARCHAR2"
ORA-02063: preceding 4 lines from ALP1
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1425
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1485
ORA-06512: at line 1
Tried increasing the shared_pool_size as suggested by oracle, but didn't work. Would appreciate if anyone cld help. Thanks.
--------------------------------------------------------------------------------
From: Oracle, Reem Munakash 07-Apr-00 14:03
Subject: Re : Replication of Updatable snapshots fails.
Are all databases running 8.0.5? Something must have changed, was one database recreated using import? Have you executed catdefrt.sql recently?
Reem Munakash
Enterprise Server Analyst
--------------------------------------------------------------------------------
From: Goh Soo Peng 12-Apr-00 03:22
Subject: Re : Re : Replication of Updatable snapshots fails.
The master site is running 8.0.5.2.1 on AIX whereas
the 2 snapshot sites are 805 on WinNT.
We did rebuilt the master database after it crashed and
rebuilt the replications which works for a while (abt 2weeks)
until these problems surfaced.
Since then, I have no choice but to do manual import of data from the updatable tables in the snapshot sites back into the master database for processing purpose.
Is there anyway, the replication can work again??
Thanks.
--------------------------------------------------------------------------------
From: Oracle, Reem Munakash 15-Apr-00 21:34
Subject: Re : Re : Re : Replication of Updatable snapshots fails.
The ORA-25205 commonly caused by the queue tables not being properly migrated. See Note 1037317.6 for instructions on migrating via import/export in a replicated environment.
Reem Munakash
Enterprise Server Analyst
|