Disclaimer

Thursday, 22 July 2021

Oracle 19c Preupgrade Log Warns Oracle Streams

 To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to 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.

It is observed that even though there are no Streams Processes or Rules.

sqlplus /nolog
connect / as sysdba

delete from sys.apply$_source_obj ;

delete from sys.apply$_source_schema;

commit;

Then run again the preupgrade script.


No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...