Pre-upgrade script utlu112i.sql errors with ORA-06550 and ORA-00942 (Doc ID 1473478.1)

Last updated on MAY 02, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Pre-upgrade script utlu112i.sql errors out with following message while upgrading db from 10.2.0.4 to 11.2.0.1.

SQL> @utlu112i.sql
  sysaux_exists     BOOLEAN := FALSE; -- TRUE when sysaux tablespace exists
                                         *
ERROR at line 267:
ORA-06550: line 3529, column 30:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 3528, column 14:
PL/SQL: SQL Statement ignored
ORA-06550: line 3550, column 30:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 3548, column 14:
PL/SQL: SQL Statement ignored
ORA-06550: line 3615, column 28:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 3613, column 12:
PL/SQL: SQL Statement ignored
ORA-06550: line 4586, column 34:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 4585, column 24:
PL/SQL: SQL Statement ignored
ORA-06550: line 4588, column 22:
PLS-00364: loop index variable 'F' use is invalid
ORA-06550: line 4588, column 19:
PL/SQL: Statement ignored


Trace files contains

*** ACTION NAME:() 2012-06-29 10:59:44.394
*** MODULE NAME:(sqlplus@epicclrty06 (TNS V1-V3)) 2012-06-29 10:59:44.394
*** SERVICE NAME:(SYS$USERS) 2012-06-29 10:59:44.394
*** SESSION ID:(188.541) 2012-06-29 10:59:44.394
*** 2012-06-29 10:59:44.394
ksedmp: internal or fatal error
ORA-00942: table or view does not exist
Current SQL statement for this session:
SELECT SUM(bytes) FROM sys.dba_data_files files WHERE files.tablespace_name = :1
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
700000070bf1328      3932  anonymous block

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms