Upgrade Scripts fail after applying RU6 on a Configured AWR Warehouse - Error During Upgrade: ORA-000942: table or view doesn't exist. (Doc ID 2723839.1)

Last updated on DECEMBER 14, 2021

Applies to:

Symptoms

In case the AWR Warehouse is configured on 13.4 Base release,Then apply the RU5 and run the upgrade script everything will looks good. But when applying RU6 then run the upgrade script it fails with error: Error During Upgrade: ORA-000942: Table or View doesn't Exist and all the source databases disappear from the dashboard.

 The Steps to reproduce the issue:

Install 13.4 Base Release and configure the AWR Warehouse

Apply RU 5 on top of the 13.4 release:

Run the upgrade Scripts and it will run successfully:

 


Now Apply RU6 then run the upgrade Script now it will fails with: Error During Upgrade:ORA-000942: table or view doesn't exist:

When checking the AWR Warehouse Homepage all the data and source databases are disappeared:

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.