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