Tuesday 7 February 2012

Registry component DBMS_SQLPA was found invalid after upgrading Oracle database from 10.2.0.1 to 10.2.0.4


After upgrading the ORACLE_HOME to 10.2.0.4 we checked the dba_registry and found the database components  DBMS_SQLPA was found invalid state.

Even after upgrading and running the utlrp.sql the component DBMS_SQLPA was found invalid.             

We searched the support documents and followed the below action plan and resolved the issues.

Connect to sqlplus as  sqlplus '/ as sysdba'

drop table plan_table;                                                               
@?/rdbms/admin/utlxplan
@?/rdbms/admin/prvtspao.plb                                            
@?/rdbms/admin/utlrp.sql                                      
select comp_name, status from dba_registry;        





No comments:

Post a Comment