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@xxxxxxx> 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Leng Burgess <lkaing@xxxxxxxxx>
Sent: Tuesday, January 4, 2022 12:27 AM
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
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>