스터디그룹 > ORACLE,MYSQL DB관련 > XDB 삭제후 다시 설치하기

제목: How to Deinstall and Reinstall XML Database (XDB)
문서 ID: 공지:243554.1 유형: BULLETIN
마지막 갱신 날짜: 20-APR-2006 상태: PUBLISHED

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_HOME\rdbms\admin 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_HOME\rdbms\admin 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 <sid> ,instanceid1,2 etc with your actual values

a. Non-RAC
dispatchers="(PROTOCOL=TCP) (SERVICE=<sid>XDB)"
b. RAC
instanceid1.dispatchers="(PROTOCOL=TCP) (SERVICE=<instanceid1>XDB)"
instanceid2.dispatchers="(PROTOCOL=TCP) (SERVICE=<instanceid2>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