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

Last updated on JULY 20, 2024

Applies to:

Symptoms

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-12.1.0.2, 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 12.1.0.2 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 ?

Cause

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