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.

Stay tuned for more articles on Oracle 19c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.