ORA-00942 during upgrade from 10g to

While upgrading database to + 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 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.
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 using manual or DBUA”. This bug affects only Oracle for Windows and only if Patch bundle is installed before the upgrade. That was exactly my scenario, I installed 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:


Posted on 23.08.2012, in Oracle and tagged . Bookmark the permalink. Comments Off on ORA-00942 during upgrade from 10g to

Comments are closed.