Hi

I am finding that the XML component of my Oracle database (Oracle9i
Release 9.2.0.4.0) is not valid.

If I run the query

SQL> SELECT comp_name, status, substr(version,1,10) as version from
dba_registry

I get:

Oracle XML Database
INVALID 9.2.0.1.0

and

OLAP Catalog
INVALID 9.2.0.1.0

I opened the database in migrate mode and ran catpatch.sql again to see
if perhasp it didn't run well after the last patch update, but the
result was the same. Interestingly though, for some of the sql scripts
it seemed to go off to the wrong home:

From catpatch.sql, the following was returned tothe SQL command line at
the end (there were quite a few more like this).

COMP_TIMESTAMP CATJAVA 02/DEC/04 02:29:55.280000000 PM +08:00
SP2-0310: unable to open file
"C:\oracle\orainf/rdbms/admin/xdbpatch.sql"
TIMESTAMP

It looks like my database (for which the home variable is
C:\oracle\ora92) wants to go off to my
infrastructure database (its home is C:\oracle\orainf) to get certain
patches, but fails to get them. I checked for some, and indeed, they
aren't there.

Has anyone seen this before i.e. that the catpatch.sql script goes off
to the rdbms directory of another database?
Is that perhaps the cause of the problem: that the Oracle XML component
is invalid, as it can't get the sql patch scripts it needs from the
other rdbms location?

Has anyone seen this before and if so, is there a safe solution to this?


Thanks

Hugo


Dr Hugo Bouckaert
Systems and Programming Engineer

Geoinformatics Exploration Australia P/L
57 Havelock St
West Perth, WA 6005
PO Box 1675, West Perth 6872

Ph: 61 08 9420 7400
Fax: 61 08 9226 1299

www.geoinformex.com

------------------------------------------------------------------------

This email and any attachments may be confidential or legally
privileged. If you received this message in error or are not the
intended recipient, you should destroy the e-mail message and any
attachments or copies, and you are prohibited from retaining,
distributing, disclosing or using any information contained herein.
Please inform us of the erroneous delivery by return e-mail. Thank you
for your cooperation.



Oracle LazyDBA home page