Please be aware that all PDBs will be upgraded.
-
Start all Oracle Services and Database.
-
Open a Command Prompt window and do the following:
-
Sqlplus /nolog
-
Connect sys/<password>@CDB as sysdba
-
Alter pluggable database all open
-
quit
-
-
cd %ORACLE_HOME%/OPatch
-
datapatch -verbose
-
A successful result looks like:
-
Change compatibility setting as follows:
-
Sqlplus /nolog
-
Connect sys/<password>@CDB as sysdba
-
create pfile from spfile
-
open C:\oracle\19c_Sta\db\database\initcdb.ora
-
edit *.compatible='19.7.0' to *.compatible='19.10.0'
-
shutdown immediate
-
create spfile from pfile;
-
startup
This will take a while.
-