Problems with generating replication support for tables
407048Jun 12 2006 — edited Jul 29 2006(A pretty frustating day so far having spent about 2 hours so far troubleshooting this problem with no luck...hence posting it here for some help)
Oracle 9.2.0.6 running on sun solaris.
We have an advanced replication setup. I have about 200 tables in a schema called VISTA that I am replicating. The replication group name is VISTA.
Currently replication group VISTA is in a suspended(quiesced) status.
For example, I have a table called REPLICATION_VERIFY in the VISTA schemas of both primary and secondary databases that are being replicated.
Having logged into OEM, Advanced Replication->Multimaster Replication->Master Groups->VISTA, I can see all the objects listed. About 30 of the objects are having a status of ERROR(instead of VALID) and generation status column shows as 'Need Generation'.
Now when I select one of those tables that has ERROR, and click the button 'Generate Replication Support', it fails and gives me the following pop-up error in OEM :
Statement ---
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
sname=>"VISTA",
oname=>"REPLICATION_VERIFY",
type=>"TABLE",
min_communication=>TRUE,
generate_80_compatible=>FALSE);
END;
Stack Trace :-------------------
ORA-23308: object VISTA.REPLICATION_VERIFY does not exist or is invalid.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_MAS" , line 2906
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2
Just doesn't let me get thru. REPLICATION_VERIFY in VISTA schema does exist. Also due to this error, it wouldn't let me resume the replication. Attempts to do so will give me an error asking me to fix the generation of replication support and the group remains in QUIESCED status. Please help....