My Oracle Support Banner

Post Upgrade Scripts - utlu112s.sql & catuppst.sql report many Errors after Upgrading Database to 11.2.0.X (Doc ID 1543850.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
The Upgrade Script - catupgrd.sql does not show any Errors and also Oracle Server(CATALOG & CATPROC) Component would report as VALID & would show the newer Version.

Symptoms

1) After running catupgrd.sql to upgrade an Oracle Database 10.2.0.X to 11.2.0.3 when running the Post Upgrade Scripts - utlu112s.sql & catuppst.sql,the Scripts give Errors.

SQL> @?/rdbms/admin/utlu112s.sql
.
Oracle Database 11.2 Post-Upgrade Status Tool           03-22-2013 06:07:50
.
Component                               Current      Version     Elapsed Time
Name                                    Status       Number      HH:MM:SS
.
DECLARE
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS
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
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REGISTRY_SYS"
ORA-06512: at "SYS.DBMS_REGISTRY", line 1810
ORA-06512: at line 66

 
Also,catuppst.sql would report the below Error -

SQL> @?/rdbms/admin/catuppst.sql
SELECT dbms_registry_sys.time_stamp('postup_bgn') as timestamp from dual
                                                                    *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS
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



PL/SQL procedure successfully completed.


This script will migrate the Baseline data on a pre-11g database
to the 11g database.

begin
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_SWRF_INTERNAL
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
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_SWRF_INTERNAL"
ORA-06512: at line 2



717 rows created.


Commit complete.

CREATE GLOBAL TEMPORARY TABLE addm$dbv (
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of SYS.NAME_SECURITY
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


insert into addm$dbv
            *
ERROR at line 1:
ORA-00942: table or view does not exist


update addm$dbv a
       *
ERROR at line 1:
ORA-00942: table or view does not exist


update addm$dbv a
       *
ERROR at line 1:
ORA-00942: table or view does not exist


        from addm$dbv v, dba_advisor_tasks a
             *
ERROR at line 4:
ORA-00942: table or view does not exist


drop table addm$dbv
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of SYS.NAME_SECURITY
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



Commit complete.


0 rows updated.


Commit complete.


0 rows updated.


Commit complete.


0 rows updated.


Commit complete.


0 rows created.


Commit complete.


0 rows created.


Commit complete.

DECLARE
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS
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
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REGISTRY_SYS"
ORA-06512: at "SYS.DBMS_REGISTRY", line 318
ORA-06512: at "SYS.DBMS_REGISTRY", line 1337
ORA-06512: at "SYS.DBMS_REGISTRY", line 1246
ORA-06512: at line 4






SP2-1506: START, @ or @@ command has no arguments
SELECT dbms_registry_sys.time_stamp('postup_end') as timestamp from dual
                                                                    *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS
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



PL/SQL procedure successfully completed.

BEGIN
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SYS
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
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REGISTRY_SYS"
ORA-06512: at "SYS.DBMS_REGISTRY", line 318
ORA-06512: at "SYS.DBMS_REGISTRY", line 1337
ORA-06512: at "SYS.DBMS_REGISTRY", line 1281
ORA-06512: at line 2


          IF CatbundleCreateDir(:catbundleLogDir) = 0 THEN
             *
ERROR at line 71:
ORA-06550: line 71, column 14:
PLS-00201: identifier 'CATBUNDLECREATEDIR' must be declared
ORA-06550: line 71, column 11:
PL/SQL: Statement ignored




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


      FROM dba_registry
           *
ERROR at line 67:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_REGISTRY_SERVER
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
ORA-06550: line 67, column 12:
PL/SQL: ORA-04045: errors during recompilation/revalidation of SYS.DBA_REGISTRY
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
ORA-06550: line 66, column 7:
PL/SQL: SQL Statement ignored


SQL>
SQL> SET SERVEROUTPUT OFF
ERROR:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_OUTPUT
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
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_OUTPUT"
ORA-06512: at line 1


SQL> SET VERIFY ON
SQL> exit

 

2) If you are performing any Oracle database upgrades, and you are currently capturing Oracle DDL operations with GoldenGate,then You may encounter below Error Messages -

OCI error (4045-ORA-04045: errors during recompilation/revalidation of PUBLIC.ALL_TAB_COLUMNS
ORA-04064: not executed, invalidated
ORA-04064: not executed, invalidated package body "GGS_DDL.DDLREPLICATION"
ORA-06508: PL/SQL: could not find program unit being called: "GGS_DDL.DDLREPLICATION"
ORA-06512: at line 837 ORA-04064: not executed, invalidated package body "GGS_DDL.DDLREPLICATION"
ORA-06508: PL/SQL: could not find program unit being called: "GGS_DDL.DDLREPLICATION"
ORA-06508: PL/SQL: could not find program unit being called: "GGS_DDL.DDLREPLICATION"
ORA-06512: at line 837
ORA-04045: errors during recompilation/revalidation of GGS_DDL.DDLREPLICATION
ORA-04064: not executed, invalidated
ORA-04064: not executed, invalidated package body "GGS_DDL.DDLREPLICATION"
ORA-06508: PL/SQL: could not find program unit being called: "GGS_DDL.DDLREPLICATION"
ORA-06512: at line 837 ORA-04064: not executed, invalidated package body "GGS_DDL.DDLREPLICATION"
ORA-06508: PL/SQL: could not find program unit being called: "GGS_DDL.DDLREPLI) initializing query to obtain NUMBER precision (table: 'xxxx.yy', column: 'Cc'), try to fix this issue in order to avoid possible fatal error.

 

3) Oracle XML Database (XDB) is INVALID since upgrading from 10.2.0.4 to 11.2.0.4.  There are NO XDB-related objects that are INVALID, yet running dbms_regxdb.validatexdb fails to validate XDB:

SQL> execute dbms_regxdb.validatexdb;

PL/SQL procedure successfully completed.

SQL> SELECT substrb(Comp_ID,1,10)Comp_ID,
 2  substrb(Status,1,8)Status,
 3  substrb(Version,1,12)Version,
 4  substrb(Comp_Name,1,35)Comp_Name
F  5  ROM DBA_Registry
WHERE comp_id = 'XD  6  B';

COMP_ID    STATUS   VERSION      COMP_NAME
---------- -------- ------------ -----------------------------------
XDB       INVALID  11.2.0.4.0   Oracle XML Database

Changes

Using the below SQL Query would list all the Triggers in the Database -

SQL> set linesize 77
SQL>  column triggering_event format a30
SQL>  column trigger_name format a20
SQL>
SQL>  select trigger_name,triggering_event,trigger_type,status from dba_triggers;

 

 


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.