开发的同事要求使用XMLPARSER, 检查发现缺少XDB, 需要安装, metalink一查,又详细的安装说明!
--query if XDB installed
select comp_name, version, status
from dba_registry where comp_name like '%XML%';
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;
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
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)"
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';
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%';
from dba_registry
where comp_name like '%XML%';