Re: Removing Advanced Replication in preparation for 11g to 19c upgrade

Happy New Year, listers,

How did you go about removing advanced replication from your 11g databases in preparation for upgrading to 19c?

I�ve been told that the advanced replication is no longer in use in our databases but I�d to know that I won�t hit an issue during an upgrade that will force me to rollback the upgrade. How does DBUA deal with Oracle advanced replication? Does it simply call a script to drop the advanced replication views?

Is there an equivalent of emremove.sql for advanced replication that we can run first before upgrading?

I�ve run the following queries and only dba_repconflict returned  4 rows. The other views returned no rows.

Would the upgrade with DBUA work? Or will I still need to resolve the repconflicsts listed below. Given that there are no rows returned from the other views, how do I purge/remove theses conflicts? Sorry it's been a LONG time since I've really had anything to do with advanced replication.

set echo on

select * from DBA_REPSITES;
select * from DBA_REPGROUP;
select * from DBA_REPOBJECT;
select * from DBA_REPCONFLICT;
select * from DBA_REPCATLOG ;
select * from dba_repcat;
select * from DEFTRAN;
select * from  DEFERROR;
select * from DEFERRCOUNT;

select * from dba_represolution_method;
select * from dba_repcolumn_group;
select * from dba_repgrouped_column;
select * from dba_repparameter_column;
select * from dba_represolution_statistics;
select * from dba_repprop;

SELECT to_char(timestamp, 'DD Mon HH24:MI') timestamp, request, status, message   FROM sys.dba_repcatlog ORDER BY timestamp;