XDB SCHEMA INSTALL STEPS

       开发的同事要求使用XMLPARSER, 检查发现缺少XDB, 需要安装, metalink一查，又详细的安装说明！

 

--query if XDB installed

select comp_name, version, status
from dba_registry where comp_name like '%XML%';

 

 

--select * from dba_tablespaces and create xdb tablespace
CREATE TABLESPACE XDB DATAFILE
  '+DATA' SIZE 64M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

 

-- Connect as sysdba and run the catqm.sql script. Maintain a spool of the script running:

SQL> set echo on
SQL> spool xdb_install.log
SQL>@?/rdbms/admin/catqm.sql XDB XDB TEMP

 

instanceid1.dispatchers="(PROTOCOL=TCP) (SERVICE=XDB)"
instanceid2.dispatchers="(PROTOCOL=TCP) (SERVICE=XDB)"

 

--Check for any invalid XDB owned objects:

SQL> select count(*) from dba_objects
where owner='XDB' and status='INVALID';

 

--recompile the XDB schema object

SQL> EXEC UTL_RECOMP.recomp_serial('XDB');

 

-- confirm the xdb is installed

select comp_name, version, status
from dba_registry
where comp_name like '%XML%';