Database Administration (MOSC)

MOSC Banner

Upgrade from 9208 10204 resulting in "Oracle Database Packages and Types INVALID "

edited Oct 6, 2009 4:53PM in Database Administration (MOSC) 8 commentsAnswered
 Upgrade from 9208 10204 resulting in "Oracle Database Packages and Types  INVALID  "

Already tried below options.  No Luck so far

==============OPTION - 1==========================

Rexecuted upgrade for the second time.

==============OPTION - 2==========================

SQL>sqlplus / as sysdba
SQL>drop table plan_table;
SQL>@?/rdbms/admin/utlxplan
SQL>@?/rdbms/admin/prvtspao.plb
SQL>@?/rdbms/admin/utlrp.sql

==============OPTION - 3==========================

SQL> shutdown immediate
SQL> startup upgrade
SQL> spool cat_repair.txt
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/utlrp.sql
SQL> spool off

SQL> shutdown immediate;
SQL> startup;

========================================

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center