Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-00600 error when migrating from 9.2.0.6.0 to 10.2.0.5.0

edited May 23, 2012 4:26AM in Database Install/Upgrade/Opatch (MOSC) 7 commentsAnswered
An error occured when trying to

   alter  wmsys.wm$versioned_tables(bl_workspace,bl_version)

ERROR at line 1:
ORA-00600: internal error code, arguments: [kqludp2], [0x70000004A864390], [1],
[], [], [], [], []


create index wmsys.wm$ver_tab_bl_indx on wmsys.wm$versioned_tables(bl_workspace,bl_version)
                                                                                *
ERROR at line 1:

No SYS, SYSTEM objects invalid

================================================================================================

Strange enough, after running (again ) utlrp.sql; and rerun catupgrd.sql, the utlu102s.sql returns both components as VALID ??

While there are still a few WMSYS objects invalid ....

WMSYS      USER_WM_VERSIONED_TABLES                                                                                                                                              5977                VIEW                2006/10/08-15:47:13 2012/05/23-15:01:57 2012-05-23:15:01:57 INVALID N N N
WMSYS      ALL_WM_VERSIONED_TABLES                                                                                                                                               5979                VIEW                2006/10/08-15:47:13 2012/05/23-15:01:57 2012-05-23:15:01:57 INVALID N N N

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center