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

How to recovery PDB when PDB database is dropped in Oracle

  How to recovery PDB when PDB database is dropped :) [oracle@rac01 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 21.0.0.0.0 - Product...