XMLDB FAQ

Oracle XMLDB FAQ:

How does one install XMLDB into a database?

One can use DBCA to install XMLDB (preferred method), or install it manually via command line. There are the command line steps:

• Create a new XDB tablespace:

SQL> CREATE TABLESPACE "XDB"
  2  LOGGING DATAFILE '/u10/app/oradata/MYDB/xdb01.dbf' SIZE 50M REUSE
  3  AUTOEXTEND ON   NEXT 50M   MAXSIZE 1500M
  4  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

• Run catqm.sql to create the supporting schema. Parameters to catqm.sql: <xdb_pass> <XDB_TS_NAME> <TEMP_TS_NAME>. Example:

SQL> CONNECT / AS SYSDBA
SQL> @?/rdbms/admin/catqm.sql change_on_install XDB TEMP

• Run catxdbj.sql:

SQL> CONNECT / AS SYSDBA
SQL> @?/rdbms/admin/catxdbj.sql

• Add the following dispatcher entry to the init.ora/SPFILE:

dispatchers="(PROTOCOL=TCP) (SERVICE=<sid>XDB)"

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

PS: To allow for unauthenticated access to your Oracle XML DB Repository through HTTP, you also need to unlock the ANONYMOUS user account.