Re: XML-SQL Utility Oracle 9i r2 on UNIX

From: <rogergorden_at_gmail.com>
Date: 8 Mar 2005 07:33:16 -0800
Message-ID: <1110295996.005063.99070@o13g2000cwo.googlegroups.com>

You need to make sure that the XDB schema is installed. This gives you access to all of the packages that you need.

The script to install this is in: $ORACLE_HOME/rdbms/admin/catqm.sql

Please don't run this script without reading the documentation first.

>From the docs on Metalink:

XDB SCHEMA INSTALL STEPS

---

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:

1. XDB user password
2. XDB user default tablespace
3. 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

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

   SQL> 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,    10.1.0.2 for 10g rel 2 , etc..

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
  1. Non-RAC dispatchers="(PROTOCOL=TCP) (SERVICE=<sid>XDB)"
  2. 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.
  3. 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.

RELATED DOCUMENTS

---

XML Database online Documentation

(Personal Note): Make sure you don't have an application using port 8080 ans XDB listens on this port. If so, make sure you change this.

Roger Gorden
Senior DBA, Viewpoint Corp Received on Tue Mar 08 2005 - 09:33:16 CST