My Oracle Support Banner

DATABASE UPGRADE TO 19C REPORTS ERROR "ORA-01403: NOT DATA FOUND" (Doc ID 2579106.1)

Last updated on AUGUST 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 When upgrading database to 19c fails, it reports following error in catupgrd0.log (ORA-01403: no data found)

==Error from catupgrd0.log===

=================================================================
20:34:11 SQL> Rem BEGIN bug 28757685: repair tabpart$
20:34:11 SQL> Rem
=========================================================================
20:34:11 SQL> /* bug 28757685: tabpart$.hiboundval and tabpart$.hiboundlen
are incorrect
20:34:11 SQL> * when tables are autolist partitioned and partitioning
columns are CHAR.
20:34:11 SQL> */
20:34:11 SQL> DECLARE
20:34:11 2 bhiboundval RAW(32767);
20:34:11 3 newhiboundval VARCHAR2(32767);
20:34:11 4 pos BINARY_INTEGER;
20:34:11 5 len BINARY_INTEGER;
20:34:11 6 multicol BOOLEAN;
20:34:11 7 numvals BINARY_INTEGER;
20:34:11 8 posnum BINARY_INTEGER;
20:34:11 9 typenum BINARY_INTEGER;
20:34:11 10 charsetform BINARY_INTEGER;
20:34:11 11 BEGIN
20:34:11 12 FOR alp IN (SELECT tp.obj#, tp.bo#,
..
..
20:34:11 129 WHEN OTHERS THEN
20:34:11 130 DBMS_SYSTEM.ksdwrt(DBMS_SYSTEM.trace_file,
20:34:11 131 'error when repairing tabpart$');
20:34:11 132 RAISE;
20:34:11 133 END;
20:34:11 134 /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 132
ORA-06512: at line 75
ORA-06512: at line 75

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

 

Changes

 Database Upgrade to 19c

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


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