Installing a New Oracle XML DB Manually without using DBCA

Follow the below steps to Install New Oracle XML DB Manually

1. If XML DB is installed can be verified through dba_registry: 

SQL> select comp_name "Component" from dba_registry;

Component
--------------------------------------------------------------------------------
Oracle Enterprise Manager
Oracle Database Catalog Views
Oracle Database Packages and Types
JServer JAVA Virtual Machine

It shows that XML DB is not installed.

2. Create a new tablespace for XML DB as below.

create tablespace  xmldb_ts
datafile '/orasw/oracle/data/oradaxmldb_ts.dbf' size 10M autoextend on maxsize unlimited
extent management local uniform size 1M;

3.Install the Oracle XML DB by connecting to database as SYS user and executing the script catqm.sql available at $ORACLE_HOME/rdbms/admin as below


Syntax is :catqm.sql

Eg:

SQL> @?/rdbms/admin/catqm xdbpwd xmldb_ts TEMP

Table created.


Table created.

4.Once script is executed successfully, you can verify the installation as below.

#> sqlplus '/as sysdba'

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Feb 27 04:11:26 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.



Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>select comp_name "Component" from dba_registry;
Component
--------------------------------------------------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types
Oracle Workspace Manager
JServer JAVA Virtual Machine
Oracle XDK
Oracle XML Database

6 rows selected.



Re-installing XML DB

To reinstall Oracle XML DB, run following SQL commands connecting to SYS to drop Oracle XML DB user and tablespace:

SQL> @?/rdbms/admin/catnoqm
SQL> alter tablespace tablespace_name offline;
SQL> drop tablespace tablespace_name including contents;