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: 11.1.0.6 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

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');
declare
*
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
...

Changes

Manual Installation of  XML Database.

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