Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Upgrade Concerns
hpuxrac wrote:
> art_at_chicagorsvp.com wrote:
> > Hi All,
> >
> > We are testing the Oracle Upgrade to 9.2.0.7. We are currently on
> > 9.2.0.5. After the upgrade ran, we noticed several issues which raise
> > concerns for us.
> >
> > First, I saw the following scroll by as the upgrade was running and
> > want to know if I should be worried about it:
> >
> > Comment created.
> >
> > from sys.user$ u, xdb.xdb$schema s, xdb.xdb$resource r
> > *
> > ERROR at line 11:
> > ORA-00600: internal error code, arguments: [unable to load XDB
> > library], [],
> > [], [], [], [], [], []
> >
> >
> > Grant succeeded.
> >
> > from xdb.xdb$element xel, xdb.xdb$schema schm
> > *
> > ERROR at line 6:
> > ORA-00600: internal error code, arguments: [unable to load XDB
> > library], [],
> > [], [], [], [], [], []
> >
> >
> >
> >
> > Second, I made sure all the objects in the database were valid.
> > However, after the upgrade we have tons of things invalid. What really
> > makes me worried, is why all the Materialized Views are invalid??
> >
> > PACKAGE BODY SYS.HTF has a status of INVALID
> > PACKAGE BODY SYS.HTP has a status of INVALID
> > PACKAGE BODY SYS.OWA has a status of INVALID
> > PACKAGE BODY SYS.OWA_CACHE has a status of INVALID
> > PACKAGE BODY SYS.OWA_COOKIE has a status of INVALID
> > PACKAGE BODY SYS.OWA_CUSTOM has a status of INVALID
> > PACKAGE SYS.OWA_MATCH has a status of INVALID
> > PACKAGE BODY SYS.OWA_MATCH has a status of INVALID
> > PACKAGE SYS.OWA_SEC has a status of INVALID
> > PACKAGE BODY SYS.OWA_SEC has a status of INVALID
> > PROCEDURE SYS.VALIDATE_OWM has a status of INVALID
> > PACKAGE BODY SYS.WPG_DOCLOAD has a status of INVALID
> > JAVA CLASS ORDSYS./56cc6cd_javax_media_jai_itera has a status of
> > INVALID
> > JAVA CLASS ORDSYS./60044729_javax_media_jai_oper has a status of
> > INVALID
> > JAVA CLASS ORDSYS./64cbff79_com_sun_media_jai_rm has a status of
> > INVALID
> > JAVA CLASS ORDSYS./801c4485_com_sun_media_jai_it has a status of
> > INVALID
> > JAVA CLASS ORDSYS./8a04f0e9_com_sun_media_jai_co has a status of
> > INVALID
> > JAVA CLASS ORDSYS./99cb2821_com_sun_media_jai_ut has a status of
> > INVALID
> > JAVA CLASS ORDSYS./a0107414_com_sun_media_jai_op has a status of
> > INVALID
> > JAVA CLASS ORDSYS./a565b787_javax_media_jai_widg has a status of
> > INVALID
> > JAVA CLASS ORDSYS./a8d43e17_javax_media_jai_Inst has a status of
> > INVALID
> > JAVA CLASS ORDSYS./bbb63e43_com_sun_media_jai_co has a status of
> > INVALID
> > JAVA CLASS ORDSYS./cc381648_com_sun_media_jai_co has a status of
> > INVALID
> > JAVA CLASS ORDSYS./cc6ad57_com_sun_media_jai_cod has a status of
> > INVALID
> > OPERATOR ORDSYS.IMGSCORE has a status of INVALID
> > OPERATOR ORDSYS.IMGSIMILAR has a status of INVALID
> > INDEXTYPE ORDSYS.ORDIMAGEINDEX has a status of INVALID
> > FUNCTION ORDSYS.SIMILARFUNC has a status of INVALID
> > PACKAGE BODY XDB.DBMS_XDB has a status of INVALID
> > PACKAGE BODY XDB.DBMS_XDBZ0 has a status of INVALID
> > XML SCHEMA XDB.XD3/uNtPGLYGTgM8BsuBFgZA== has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.AFQT has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.AFQT_PERCENTILES has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.AIR_FORCE_COMP has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.AIR_FORCE_COMPOSITES has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.ARMY_COMP has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.CHAR_SRVC_CODE has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.CNTRY_MEPCOM_USCIS has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.CNTRY_WORLD has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.CO_US has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.DEATH_SOURCE has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.DRUG_TST_EXCEP_CODE has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.EDUC_DESIG has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.ETHNIC_CATEGORY has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.FORM_AREAS has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.FORM_PARAMETERS has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.ICD_CODE has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.ISC_ENL_CODE has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.LANG_IDENT has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.MARINE_COMP has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.MED_FAIL_CODE has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.MED_HIV_ANTI_SCRN has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.MED_LAB has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.MED_PERM_FAIL_CODE has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.MEPS_SYSTEM_INFO has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.MIRS_FORMS has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.MIRS_PARAMETER has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.PULHES_ICD has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.RACIAL_CATEGORY has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.SEP_RSN_MIL has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.SPECIAL_TST has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.SPECIAL_TST_AUTH has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STANDARD_SCORES has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STANDARD_SCORE_LIMITS has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STATE_OF_US has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STD_DISCREPANCIES has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STP_GRADE_CONSTANTS has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STP_GRADE_SEX_PERCENTILES has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STP_MEAN_DEV_ERR has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STP_PERCENTILES has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STS_ETHNIC_CATEGORY has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STS_INTENTIONS has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STS_RACIAL_CATEGORY has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STS_REPORTS has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.STS_SPEC_INSTRUCTIONS has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.TEST_VERSION has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.TRANS_TO_CODE has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.USCIS_WORK_CTZN_STATUS has a status of
> > INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.VALID_SSAN_RANGES has a status of INVALID
> > MATERIALIZED VIEW MIRS_LOOKUP.ZIP_CODE has a status of INVALID
> >
> >
> > Any comments on this?
>
>
>
Guess we really want to know if we need to worry about it or not. Additionally, I'm still miffed on the Materialized View issue....... Received on Fri Jun 23 2006 - 12:31:27 CDT
![]() |
![]() |