[DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.

Background:

A customer has an Oracle Database version 12.2.0.1 on Windows server. He asked to upgrade this database to 19c (19.17) on the same server.

Procedure:

• I installed Oracle 19c (19.3) on a new oracle home on the same server.
  (During the installation I selected “Windows Virtual Account” as the Oracle Home owner)
• I applied the 19.17 release update successfully.
• Then I invoked the dbua (Database Upgrade assistant) to upgrade the database, but I received the following error at one of the initial screen (captured above):

[DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.

From the above error, I found that the current 12c home was using a user called “dbuser” as the home owner, and this is different than the one that I used for the new Oracle 19c home.

Final Solution:

Unfortunately, I found no simple solution to fix this error.
– I had to deinstall the Oracle 19c home completely.
– Then I re-installed the Oracle 19c home with the same user as that of 12c (dbuser).
– Then, I patched the 19c home to 19.17. I applied the following two patches:
19.17.0.0.221018 WIN BP Patch 34468114 MS-Windows 05-Nov-2022
19.17.0.0.221018 OJVM Patch 34411846 MS-Windows 05-Nov-2022
– Then I run the dbua to upgrade the database successfully.