ORA-01403: no data found on xdbuo112.sql while upgrading from 11g to 12.2 (Doc ID 2290984.1)

Last updated on JULY 27, 2017

Applies to:

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

Symptoms

On : 12.2.0.1 version, XML Database

 ERRORS FOUND: During Upgrade

REASON:
  ERRORS FOUND: During Upgrade
  FILENAME: /opt/ora12c/admin/RS7G3XB/logbook/catupgrd0.log AT LINE NUMBER: 1628124
------------------------------------------------------
Identifier XDB 17-07-23 04:32:01
SCRIPT = [/opt/ora12c/product/12.2.0.1/rdbms/admin/xdbuo112.sql]
ERROR = [ORA-01403: no data found ORA-06512: at line 11
ORA-06512: at line 23
]
STATEMENT = [declare
  already_revoked exception;
  pragma exception_init(already_revoked,-01927);

  procedure revoke_inherit_privileges(user in varchar2) as
  sql_stmt varchar2(4000);
  usr_exists number := 0;
  begin

  sql_stmt := 'select 1 from user$ where name = upper(:1)';
  execute immediate sql_stmt into usr_exists using user;

  if (usr_exists = 1) then
  execute immediate 'revoke inherit privileges on user '||
  dbms_assert.enquote_name(user)||' from public';
  end if;
  exception
  when already_revoked then null;
  end;

begin
  revoke_inherit_privileges('xdb');
  revoke_inherit_privileges('anonymous');
end;]
------------------------------------------------------
------------------------------------------------------
Identifier XDB 17-07-23 04:32:01
SCRIPT = [/opt/ora12c/product/12.2.0.1/rdbms/admin/xdbuo112.sql]
ERROR = [ORA-06512: at line 11 ORA-06512: at line 23
]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier XDB 17-07-23 04:32:01
SCRIPT = [/opt/ora12c/product/12.2.0.1/rdbms/admin/xdbuo112.sql]
ERROR = [ORA-06512: at line 23]
STATEMENT = [as above]
------------------------------------------------------

 LOG FILES: (/opt/ora12c/admin/RS7G3XB/logbook/catupgrd*.log)

Upgrade Summary Report Located in:

 

ERROR
-----------------------
ORA-01403: no data found

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