ORA-00942 during upgrade from 10g to 184.108.40.206
While upgrading 10.2.0.5 database to 220.127.116.11 + Patch 8 on Windows 2008 R2 I got an error message
ORA-00942: table or view does not exist while DBUA was executing “Upgrading Oracle Server” step.
I ignored the error and proceed with an upgrade. A quick grep of the log revealed this:
[excerpt from ORACLE\cfgtoollogs\dbua\ACMEDB\upgrade1\Oracle_Server.log]
.... Rem Rem Set capture file id equal to replay file id. This is the correct behavior Rem for non-consolidated replays. Since this is an upgrade, this rule holds. Rem update sys.WRR$_REPLAY_DIVERGENCE set cap_file_id = file_id; update sys.WRR$_REPLAY_DIVERGENCE set cap_file_id = file_id * ERROR at line 1: ORA-00942: table or view does not exist ... ...
It’s a known bug according to MOS Note 1465852.1 “ORA-00942 reports during upgrade to 18.104.22.168 using manual or DBUA”. This bug affects only Oracle 22.214.171.124 for Windows and only if Patch bundle is installed before the upgrade. That was exactly my scenario, I installed 126.96.36.199 and then Patch 8.
According to MOS note we can ignore the error if remaining installation steps finish without errors and if components are valid afterwards:
select comp_name,status,version from dba_registry;
After upgrade we must run scripts that’ll rebuild DB Replay repository objects; just to be sure that we remove any depricated data from repository tables: