XML db installation steps

XMLDB has been installed in <DB_NAME> on <Server>

EX: If the database name QDAPUB

NOTE:-  needs to restart listener for QDAPUB db

The steps are as below:-

1) Check java is installed or not

stpes for JVM installation:-

select comp_name,version,status from dba_registry;

If the above doesn't list "JServer JAVA Virtual Machine 9.2.0.6.0" or similar, install Oracle Java Virtual Machine:

    shutdown immediate

    startup mount

    alter system set "_system_trig_enabled" = false scope=memory;

    alter database open;

    @?/javavm/install/initjvm.sql

    @?/xdk/admin/initxml.sql

    @?/xdk/admin/xmlja.sql

    @?/rdbms/admin/catjava.sql

    shutdown immediate

    startup

2)  XMLDB  INSTALL STEPS:

--   Create XDB tablespace

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

The Following Step is for Release 9.2.x ONLY skip to step 3 if running 10.1.x or above

2.Reconnect to SYS again and run the following to load the XDB java library.

SQL>@?/rdbms/admin/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

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.