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 AUGUST 30, 2021
Applies to:Enterprise Manager for Oracle Database - Version 220.127.116.11.0 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