ORA-00942 during upgrade from 10g to 126.96.36.199
While upgrading 10.2.0.5 database to 188.8.131.52 + 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 184.108.40.206 using manual or DBUA”. This bug affects only Oracle 220.127.116.11 for Windows and only if Patch bundle is installed before the upgrade. That was exactly my scenario, I installed 18.104.22.168 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: