Invalid Objects after Database Upgraded to 10.2.0.1

ERROR at line 1:
ORA-04063: package body "SYSTEM.AD_INVOKER" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYSTEM.AD_INVOKER"
ORA-06512: at line 2

sqlplus -s APPS/***** @/11i/progs/applmgr/devappl/ad/11.5.0/admin/sql/adinvset.pls &systempwd 8 0 FALSE FALSE


The Oracle DB's stored procedures have not been invalidated and recompiled for Oracle 10g.


Solutions
==========


1. Change directory to $Portal_DB_HOME/rdbms/admin
2. Login to sqlplus as sys as sysdba.
3. SQL>shutdown
4. SQL>startup upgrade
5 SQL>@utlirp.sql
6. SQL>shutdown
7. SQL>startup
8. SQL>@utlrp.sql
9. Check for invalid objects.

No comments: