вторник, 15 июля 2014 г.

Upgrade Oracle 10.2.0 to 11.2.0 Tips

While installing you got:
BEGIN wmsys.owm_mig_pkg.moveWMMetaData; END;
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596
ORA-06512: at line 1

ignore this accoding to
ORA-00942 during database upgrade of Oracle Workspace Manager (Doc ID 1399508.1)

public synonym X$KGLLK and invalid view SYS.X_$KGLLK can be dropped in 11G.
So drop the views and any synonyms related to $kslei as they are not used in 11g.
see Invalid X_$ Views & Synonyms After Upgrading to 11g (Doc ID 878623.1)