Re: Oracle Upgrade Concerns

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?
>
> Thanks in advance!

If you have log file with the ORA-00600 open a TAR and send it to those wonderful support folks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org