My Oracle Support Banner

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:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


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:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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