How do I install and uninstall Oracle XML database (xmldb/xdb)? ____oracle

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.