René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Oracle XML DB installation | ||
If XML DB is installed can be verified through dba_registry:
SQL> select comp_name "Component" from dba_registry; Component ------------------------------------------------------ Oracle Database Catalog Views Oracle Database Packages and Types
As can be seen, XML DB is not installed.
XML DB can be installed with the database configuration assistant (dbca) or by calling the
catqm.sql script.
catqm stands for catalog script for sQl xMl management.
In the following, I demonstrate how to use the script.
This script creates
When the script is called, it must be given (in the following order):
It seems that it is advisable to have a tablespace for XML DB (see re-installing XML DB below).
create tablespace xmldb_ts datafile 'd:\oracle\databases\ora10\xmldb_ts.dbf' size 10M autoextend on maxsize unlimited extent management local uniform size 1M;
Also, the pool size must be configured sufficiently large:
SQL> alter system set shared_pool_size = 80M scope=spfile;
If the shared pool size was altered, the database has to be bounced.
The script must be run as sys.
SQL> set feedback off SQL> @?/rdbms/admin/catqm xml_password xmldb_ts temp
Now, the installation should be reflected in dba_registry:
select comp_name "Component" from dba_registry; Component ------------------------------------------ Oracle Database Catalog Views Oracle Database Packages and Types Oracle XML Database re-installing XML DBSQL> @?/rdbms/admin/catnoqm SQL> alter tablespace XMLDB_TS offline; SQL> drop tablespace XMLDB_TS including contents;
Then the same procedure as installing the XML DB.
|