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

Hi Mark,

This is what I’m looking for - how do you remove advanced replication? It looks like there are still remnants of it in DBA_REPCONFLICT;

Previously there was catrepr.sql but it’s no longer available.

https://community.oracle.com/tech/apps-infra/discussion/836027/remove-replication-catrepr-sql-gone

Thanks,

Leng.

> On 5 Jan 2022, at 6:18 am, Powell, Mark <mark.powell2_at_dxc.com> wrote:
>
> If Advanced Replication is not in use in your current database why not remove it? You could use the audit feature to monitor usage for a while if you need to verify this.
>
> Mark Powell
> Database Administration
> (313) 592-5148
>
>
> From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Leng Burgess <lkaing_at_gmail.com>
> Sent: Tuesday, January 4, 2022 12:27 AM
> To: ORACLE-L <oracle-l_at_freelists.org>
> Subject: 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 count(*) from defcall;
> select count(*) from deftrandest;
>
> 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;
>
>
>
> sql> select * from DBA_REPCONFLICT;
>
> SNAME ONAME CONFLICT_T REFERENCE_NAME
> ------------------------------ ------------------------------ ---------- ------------------------------
> DICT STATION_ALIAS_TB UPDATE epoch
> DICT STATION_LOG_TB UPDATE epoch
> DICT STATION_REPL_TB UPDATE epoch
> DICT STATION_TB UPDATE epoch
>
> Thanks in advance,
>
> Leng.--
> https://clicktime.symantec.com/3QXntjmT8EUwMqJqAo6GeaF7VN?u=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l <https://clicktime.symantec.com/3QXntjmT8EUwMqJqAo6GeaF7VN?u=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l>

--
http://www.freelists.org/webpage/oracle-l