If you are are on database release 10.1.x or 10.2.x the XDB Feature are mandatory in order to use any of the member functions O f the XmlType. This is true even if you are are not using the repository, or registered schema aspects of the XDB feature. Before we begin to install it, let's check the steps of how to remove it manually.
1, Shutdown and restart the database
2, Connect as SYSDBA and run catnoqm.sql script. Connect/as SYSDBA
@?/rdbms/admin/catnoqm.sql
Drop trigger Sys.xdb_installation_trigger;
Drop trigger Sys.dropped_xdb_instll_trigger;
drop table Dropped_xdb_instll_tab;
3, Modify parameter values in Init.ora or SPFile. Shared_pool_size =150 MB # Or larger value
Java_pool_size =150 MB # Or larger value
4, Create XDB tablespace as XMLDB repository storage, make sure it has 150MB free spaces.
5, restart the database to make the parameters take effect.
Now we are ready to install a new XDB.
1, Connect as SYSDBA and run catqm.sql script. Set echo on
Spool Xdb_install.log
@?/rdbms/admin/catqm.sql Xdb_user_pass Xdb_tbs Temp_tbs
2, If you are using Oracle 9.2, reconnect as SYSDBA and run catxdbj.sql script. Oracle 10g also has this script, but have no to do. @?/rdbms/admin/catxdbj.sql
3, change the database system parameters in Init.ora or SPFile. A. Non-rac
Dispatchers= "(protocol=tcp) (SERVICE=<SID>XDB)"
B. RAC
Inst1.dispatchers= "(protocol=tcp) (SERVICE=<INSTANCEID1>XDB)"
Inst2.dispatchers= "(protocol=tcp) (SERVICE=<INSTANCEID2>XDB)"
4, make sure there are no invalid objects in XDB schemas, and check xmldb status in Dba_registry. Select COUNT (*) from dba_objects
where owner= ' XDB ' and status= ' INVALID ';
Select Comp_name, status, version
From Dba_registry
where Comp_name= ' Oracle XML Database ';
5, bounce the database to enable the XMLDB protocol.
The original Oracle Metalink notes ID is 243554.1