Oracle 19c Preupgrade Log Warns Oracle Streams must be Removed Though no Streams is Setup
(Doc ID 2666384.1)
Last updated on JUNE 01, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Upgrading to 19c.
The log created by the Oracle 19c preupgrade.jar script warns that Oracle Streams must be removed from the database.
This is the full warning:
Remove Streams setup. 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.
For versions pre-18.104.22.168, the procedure dbms_streams_adm.remove_streams_configuration must not be used as may lead to unwanted results. Instead, use the other procedures (dbms_capture_adm.drop_capture, dbms_apply_adm.drop_apply,
dbms_streams_adm.remove_queue, etc). For 22.214.171.124 and higher, procedure dbms_streams_adm.remove_streams_configuration can be safely used.
Oracle Streams feature is configured in the database.
Starting with Oracle Database 19, Oracle Streams is desupported. It is strongly advised to remove any streams configuration manually.
However, there is no Streams setup in this database.
How to manually remove Streams before the upgrade ?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document