Software Upgrade Issues
Follow up by mail Click here


Subject: Software Upgrade Issues
Author: Lukas Pise, Ireland
Date: Mar 24, 2010, 1681 days ago
Os info: Windows 2000
Oracle info: Oracle 11.1.0.6.0
Error info: Oracle Server ORA-00001: unique constraint (SYS.I_AUDIT_ACTIONS) violated
ORA-22324: altered type has compilation errors
. ORA-22328: object "SYS"."WRI$_ADV_SQLPI" has errors.
. PLS-00590: attempting to create a subtype UNDER a FINAL type
. ORA-22324: altered type has compilation errors
. ORA-22328: object "SYS"."WRI$_ADV_SQLTUNE" has errors.


Oracle Enterprise Manager
. ORA-02291: integrity constraint (SYSMAN.MGMT_SYSTEM_ERROR_LOG_FK) violated -
. parent key not found
. ORA-06512: at "SYSMAN.MGMT_LOG", line 137
. ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 531
. ORA-02291: integrity constraint (SYSMAN.MGMT_SYSTEM_ERROR_LOG_FK) violated -
. parent key not found
. ORA-04063: package body "SYS.PRVT_ADVISOR" has errors
. ORA-06508: PL/SQL: could not find program unit being called:
"SYS.PRVT_ADVISOR"

Oracle Multimedia
. ORA-04063: package body "SYS.PRVT_ADVISOR" has errors
. ORA-06508: PL/SQL: could not find program unit being called:
"SYS.PRVT_ADVISOR"
. ORA-06512: at "SYS.UTL_RECOMP", line 629
. ORA-06512: at "SYS.UTL_RECOMP", line 671
. ORA-06512: at line 1

Gathering Statistics
. ORA-31011: XML parsing failed
. ORA-19202: Error occurred in XML processing
. LPX-00245: extra data after end of document
. Error at line 1
. ORA-06512: at "SYS.DBMS_STATS", line 17964
. ORA-06512: at "SYS.DBMS_STATS", line 18416
. ORA-06512: at "SYS.DBMS_STATS", line 20773
. ORA-06512: at "SYS.DBMS_STATS", line 20816
. ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 1054
. ORA-06512: at line 1
Message: Hello

We are having our production databases working on Windows 2000 Server supporting Oracle version 11.1.0.6.0 & 10.2.0.1.0.

We performed software upgrade from 10.2.0.1.0 to 11.1.0.6.0.After software upgrade , Database is working fine.

But we observed in the Spool file of Post-Upgrade Status Tool script @utlu111s.sql , there are certain errors.

Could some one throw light on this , may be we could avoid these errors



Oracle Server ORA-00001: unique constraint (SYS.I_AUDIT_ACTIONS) violated
ORA-22324: altered type has compilation errors
. ORA-22328: object "SYS"."WRI$_ADV_SQLPI" has errors.
. PLS-00590: attempting to create a subtype UNDER a FINAL type
. ORA-22324: altered type has compilation errors
. ORA-22328: object "SYS"."WRI$_ADV_SQLTUNE" has errors.


Oracle Enterprise Manager
. ORA-02291: integrity constraint (SYSMAN.MGMT_SYSTEM_ERROR_LOG_FK) violated -
. parent key not found
. ORA-06512: at "SYSMAN.MGMT_LOG", line 137
. ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 531
. ORA-02291: integrity constraint (SYSMAN.MGMT_SYSTEM_ERROR_LOG_FK) violated -
. parent key not found
. ORA-04063: package body "SYS.PRVT_ADVISOR" has errors
. ORA-06508: PL/SQL: could not find program unit being called:
"SYS.PRVT_ADVISOR"

Oracle Multimedia
. ORA-04063: package body "SYS.PRVT_ADVISOR" has errors
. ORA-06508: PL/SQL: could not find program unit being called:
"SYS.PRVT_ADVISOR"
. ORA-06512: at "SYS.UTL_RECOMP", line 629
. ORA-06512: at "SYS.UTL_RECOMP", line 671
. ORA-06512: at line 1

Gathering Statistics
. ORA-31011: XML parsing failed
. ORA-19202: Error occurred in XML processing
. LPX-00245: extra data after end of document
. Error at line 1
. ORA-06512: at "SYS.DBMS_STATS", line 17964
. ORA-06512: at "SYS.DBMS_STATS", line 18416
. ORA-06512: at "SYS.DBMS_STATS", line 20773
. ORA-06512: at "SYS.DBMS_STATS", line 20816
. ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 1054
. ORA-06512: at line 1



Regards
Lukas
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Software Upgrade Issues
Author: Tim Boles, United States
Date: Mar 24, 2010, 1681 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Can you post the results of executing:

select comp_id, version, status from DBA_registry;


Regards
Tim
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Software Upgrade Issues
Author: Philip Wisse, Netherlands
Date: Mar 24, 2010, 1681 days ago
Message: Hi Lukas,

You're having INVALID objects:
select * from dba_objects where status = 'INVALID';


select * from dba_constraints where status <> 'ENABLED';



In the rdbms/admin folder are scripts for these objects. If you're lucky the invalid objects will compile. If you're not it may corrupt your database even further so keep a backup ready.

Invalid TYPES are allways difficult because of hierarchy, packages and views should be easy.

Referential integrity: delete records or truncate table . . .

Good luck! Philip.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Software Upgrade Issues
Author: Lukas Pise, Ireland
Date: Mar 25, 2010, 1681 days ago
Message: Hello Tim

SQL> select comp_id, version, status from DBA_registry;

COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
EM 11.1.0.6.0 VALID

AMD 11.1.0.6.0 VALID

SDO 11.1.0.6.0 INVALID

ORDIM 11.1.0.6.0 INVALID


XDB 11.1.0.6.0 VALID

CONTEXT 11.1.0.6.0 VALID

ODM 11.1.0.6.0 VALID

EXF 11.1.0.6.0 INVALID

RUL 11.1.0.6.0 INVALID

OWM 11.1.0.6.0 INVALID

CATALOG 11.1.0.6.0 INVALID

CATPROC 11.1.0.6.0 INVALID


JAVAVM 11.1.0.6.0 VALID

XML 11.1.0.6.0 VALID

CATJAVA 11.1.0.6.0 VALID

APS 11.1.0.6.0 VALID

XOQ 11.1.0.6.0 VALID


Regards
Lukas
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Software Upgrade Issues
Author: Lukas Pise, Ireland
Date: Mar 25, 2010, 1681 days ago
Message: Hello Philip

After compiling invalid objects , we encountered errors ...

SQL> @d:\oracle\rdbms\admin\utlrp.sql

DECLARE
*
ERROR at line 1:
ORA-04063: package body "SYS.PRVT_ADVISOR" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.PRVT_ADVISOR"
ORA-06512: at "SYS.UTL_RECOMP", line 629
ORA-06512: at line 4



ERRORS DURING RECOMPILATION
---------------------------
0


PL/SQL procedure successfully completed.

ORDIM INVALID OBJECTS: VALIDATE_ORDIM_WITH_DETAILS - 6 - 7
ORDIM INVALID OBJECTS: ORDUTIL - 5 - 11

PL/SQL procedure successfully completed.


Could you throw some light on this


Regards
Lukas
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Software Upgrade Issues
Author: Tim Boles, United States
Date: Mar 25, 2010, 1680 days ago
Message: Your upgrade did have problems....there are components that need to be validated. You should start with the CATALOG and CATPROC then work on the others. You can get more information from Metalink 437794.1]

NOTE:300056.1 - Debug and Validate Invalid Objects
NOTE:554520.1 - How to Diagnose Invalid or Missing Data Dictionary (SYS) Objects
NOTE:565600.1 - ERROR IN CATUPGRD: ORA-00904 IN DBMS_SQLPA

Regards
Tim Boles
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here