Saturday, March 8, 2014

upgrade DB from 10.2.0.4 to 11.2.0.3 + ORA-04067: not executed, package body "SYS.NAME_SECURITY" does not exist

After upgrading the DB from 10.2.0.4 to 11.2.0.3, when I select data from data dictionary view or when I run utlrp.sql, getting following error.

SQL> select count(*) from dba_objects where status<>'VALID';
select count(*) from dba_objects where status<>'VALID'
                     *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBA_OBJECTS
ORA-04067: not executed, package body "SYS.NAME_SECURITY" does not exist
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.NAME_SECURITY"
ORA-06512: at line 2
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.NAME_SECURITY"
ORA-06512: at line 2


SQL> Alter trigger SYS.NAMECHECK_BEFORE_DDL_DB_TRG disable;

Trigger altered.

SQL> select count(*) from dba_objects where status<>'VALID';

  COUNT(*)
----------
       987


No comments:

Post a Comment