ORA-01403: no data found on xdbuo112.sql while upgrading from 11g to 12.2
(Doc ID 2290984.1)
Last updated on NOVEMBER 16, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A 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
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 |
| Cause |
| Solution |