Hugo,
Was your Oracle home set to the database Oracle home when you ran
catpatch.sql?
For OLAP, there is a 9.2.0.4.1 patch available on metalink that will
enable your OLAP catalog. However, if you are not planning to use OLAP
there is no need to worry about the status.
Also, note that 9.2.0.5 and 9.2.0.6 (for most platforms) are available...
Mark.
Hugo Bouckaert wrote:
> 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.
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
Oracle LazyDBA home page