XMLDB FAQ

From Oracle FAQ
Jump to: navigation, search

Oracle XMLDB FAQ:

How does one install XMLDB into a database?[edit]

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.