My Oracle Support Banner

Oracle 19c Preupgrade Log Warns Oracle Streams must be Removed Though no Streams is Setup (Doc ID 2666384.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 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-, 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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.