Upgrade failed from 9.2.0.7 to 10.2.0.4
484376Jun 21 2010 — edited Jun 22 2010On windows server 2003, upgradation of oracle server has been failed while upgradation 9.2.0.7 to 10.2.0.4. Below are the errors from the log.
Error ignored: ORA-01956: invalid command when OS_ROLES are being used
Error ignored: ORA-01950: no privileges on tablespace 'SYSAUX'
Error ignored: ORA-00942: table or view does not exist
Error ignored: ORA-01502: index 'CTXSYS.DRC$OBJ_KEY' or partition of such index is in unusable
Error ignored: ORA-01403: no data found ORA-06512: at "CTXSYS.DR$TEMP_CREPREF", line 12 ORA-06512: at line 1
Error ignored: ORA-01502: index 'CTXSYS.DRC$OAT_KEY' or partition of such index is in unusable
Error ignored: ORA-01403: no data found ORA-06512: at "CTXSYS.DR$TEMP_CREPREF", line 12 ORA-06512: at line 1
Error ignored: ORA-01536: space quota exceeded for tablespace 'DRSYS'
Error ignored: ORA-06550: line 5, column 17: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 5, column 5: PL/SQL: SQL Statement ignored
Error ignored: ORA-06575: Package or function DRVPARX is in an invalid state
Error ignored: ORA-06550: line 1, column 11: PLS-00905: object SYS.VALIDATE_CONTEXT is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Error ignored: ORA-29902: error in executing ODCIIndexStart() routine ORA-01502: index 'XDB.XDB$H_INDEX_OID_I' or partition of such index is in
Error ignored: ORA-00604: error occurred at recursive SQL level 1 ORA-01502: index 'XDB.XDB$H_INDEX_OID_I' or partition of such index is in.
Does anyone have idea on this upgradation.
Please provide necessary steps how can we overcome these errors and perform the db upgrade.
Thanks in advance.