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

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...