Technote

PURPOSE
-------

This article provides the steps to manually deinstall and install the XML Database feature into a database.  

SCOPE & APPLICATION
-------------------

This article is for DBA's that need to remove, install and/or reinstall the XDB schema into an existing Oracle database.  

NOTE:  If the XML DB features are currently being utilized, and you have experienced a corrupted XML DB repository or installation, it may be more efficient to perform point in time recovery to a point prior to the problem.
       
How to Deinstall and Reinstall XML Database (XDB)
-------------------------------------------------

XDB SCHEMA REMOVAL STEPS
*************************

WARNING: The steps to remove the XML Database feature (XDB schema) will completely remove the XDB repository including any user
defined information contained within it.  Therefore, if there are any registered schemas or XML Database items created, you will be required to recreate all of your user defined structures, data and re-register all schemas previously registered.

1.  Shutdown and restart the database.

2.  Connect as sysdba and run the catnoqm.sql script.  Maintain a spool of the script running:

    UNIX: $ORACLE_HOME/rdbms/admin subdirectory
    WINDOWS: $ORACLE_HOMErdbmsadmin subdirectory

    For Example:

    SQL> set echo on
    SQL> spool xdb_removal.log
    SQL> @?/rdbms/admin/catnoqm.sql

3.  Modify the init.ora file or spfile to include the following minimums to prepare the DB for reinstalling the XDB schema:

    shared_pool_size =150 MB
    java_pool_size =150 MB

4.  Turn on AUTO EXTEND on the XDB tablespace. 
    If you do not want to do this , make sure you target a tablespace with at least 
       .100 MB of free space for non-UTF8 DB
       .150 MB of free space for an AL32UTF8 DB

5.   Shutdown the database immediate, and startup the database normal

     NOTE:  Failure to restart the database at this step can cause XDB catqm.sql 
     installation to fail with an internal error similar to the following:
     ORA-7445 [qmr_hdl_copy()+48]


XDB SCHEMA INSTALL STEPS
*************************

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

   UNIX: $ORACLE_HOME/rdbms/admin subdirectory
   WINDOWS: $ORACLE_HOMErdbmsadmin subdirectory

   The catqm.sql script requires the following parameters be passed to it when run:  
    A.  XDB user password
    B.  XDB user default tablespace
    C.  XDB user temporary tablespace
   Therefore the syntax to run catqm.sql will be:  
   SQL> catqm.sql A B C

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

2.  Reconnect to SYS again and run the following to load the XDB java library.

   SQL>  catxdbj.sql

   NOTE:  In order to load the XDB java libraries in catxdbj.sql, you must 
   first have a valid Java Virtual Machine installation in the DB (JVM) 
   and a valid XDK.  
   Also, make sure that the database is started with Oracle9i Release 2 
   (9.2.0) compatibility or higher for database version 9.2,
   10.1.0.2 for 10g rel 2 , etc..


3.  If the following line is not already apart of the database system parameters (init.ora/spfile).
    ***** NOTE:
     PLEASE REPLACE  ,instanceid1,2 etc with your actual values 

    a. Non-RAC
          dispatchers="(PROTOCOL=TCP) (SERVICE=XDB)" 
    b. RAC
          instanceid1.dispatchers="(PROTOCOL=TCP) (SERVICE=XDB)" 
          instanceid2.dispatchers="(PROTOCOL=TCP) (SERVICE=XDB)" 
          etc ...
    c.If you are not using the default Listener ensure you have set LOCAL_LISTENER in the (init.ora/spfile)
      as prescribed for RAC/NON-RAC instances or the end points will not register.
   

4. Check for any invalid XDB owned objects:

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

        COUNT(*)
        ----------
         0
5.  Check DBA_REGISTRY for XDB status:
    SQL>  select comp_name, status, version from DBA_REGISTRY where comp_name='Oracle XML Database'
          The results should indicate the correct version and patch in a valid status.

6.  Restart database and listener to enable Oracle XML DB protocol access.

RELATED DOCUMENTS
-----------------

XML Database online Documentation