Good morning all,
We no longer need CDC in our databases. So how does one gracefully remove CDC
from 11g in preparation for a 19c database upgrade?
We've reviewed the following documents:
How To Disable And Drop Change Data Capture (CDC) Objects? ( Doc ID 734214.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=734214.1>
)
How To Disable And Drop Change Data Capture (CDC) Objects in 11g ( Doc ID
1320951.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=1320951.1>
)
12c Streams And Change Data Capture (CDC) Support ( Doc ID 1644090.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=1644090.1>
)
How to remove CDC objects from 12.2 ( Doc ID 2465071.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=2465071.1>
)
Steps to Deinstall and Resintall CDC in 11.2 ( Doc ID 1955416.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=1955416.1>
)
But we are still not clear what we need to do. We’re looking for something like
this for OLAP:
How to remove the Oracle OLAP Option from a 12c Database ( Doc ID 1940098.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=1940098.1>
)
Oracle support replied with:
"Please follow the document : Oracle 19c Preupgrade Log Warns Oracle Streams
must be Removed Though no Streams is Setup ( Doc ID 2666384.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=2666384.1>
)
For detailed steps, refer to the section "Removing an Oracle Streams
Configuration" in the Oracle Streams Concepts and Administration Guide specific
for the Oracle release from which you are removing. “
Which is rather surprising as I had forgotten all about streams and CDC.
I’m now thinking we do the following:
1) drop streams per 1940098.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=1940098.1>
2) drop the users CDCSUB, CDCPUB, CDCADMIN cascade
3) run the upgrade to 19c - note 2465071.1
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-26345390741&id=2465071.1>
implies that CDC will be removed during the upgrade…
Is that it? How did you guys deal with CDC during an 11g upgrade to 12c or 19c?
Thanks in advance,
Leng.