ORA-01403 "no data found" And ORA-00959 "tablespace 'XDB' does not exist" Installing XML Database (= XDB )

(Doc ID 1139636.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: and later   [Release: 11.1 and later ]
Information in this document applies to any platform.


Manually installing XML Database (=XDB) fails with the following errors:

old 23: where tablespace_name = upper('&res_tbs');
new 23: where tablespace_name = upper('xdb');
old 29: where tablespace_name = upper('&temp_tbs');
new 29: where tablespace_name = upper('temp');
old 47: raise_application_error(-20001, 'Compressed tablespace &res_tbs' ||
new 47: raise_application_error(-20001, 'Compressed tablespace xdb' ||
old 51: '&temp_tbs cannot be used');
new 51: 'temp cannot be used');
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 22

old 1: create user xdb identified by &xdb_pass account lock password expire
new 1: create user xdb identified by xdb account lock password expire
old 2: default tablespace &res_tbs temporary tablespace &temp_tbs
new 2: default tablespace xdb temporary tablespace temp
create user xdb identified by xdb account lock password expire
ERROR at line 1:
ORA-00959: tablespace 'XDB' does not exist

BEGIN dbms_registry.loading('XDB', 'Oracle XML Database', 'DBMS_REGXDB.VALIDATEXDB', 'XDB'); END;

ERROR at line 1:
ORA-39706: schema 'XDB' not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REGISTRY", line 71
ORA-06512: at "SYS.DBMS_REGISTRY", line 417
ORA-06512: at line 1


Manual Installation of  XML Database.


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