Nyitottam egy TAR-t "ORA-04043: object XDB_DATASTORE_PROC does not exist" című hibára ...

Az első TAR-om.

Kiváncsi vagyok mit mondanak ...

És már meg is oldották !

10-MAR-06 10:40:03 GMT

The customer : XYZ : has uploaded the following file via
MetaLink:RDA.AB_DB.zip

10-MAR-06 11:28:32 GMT

.
Hi Zoltán,

Thank you for using MetaLink. We are currently reviewing/researching the situation and will update the SR / call you as soon as we have relevant i
nformation. Thank you for your patience.

Best Regards,
Uwe
Oracle Support Services

STATUS
=======

@WIP -- Work In Progress

10-MAR-06 13:39:47 GMT

.
ISSUE CLARIFICATION
====================
Error when running script $ORACLE_HOME/rdbms/admin/catupgrd.sql:
...
alter procedure xdb.XDB_DATASTORE_PROC compile
*
ERROR at line 1:
ORA-04043: object XDB_DATASTORE_PROC does not exist
...

.
ISSUE VERIFICATION
===================
Verified the issue by patch log file

10-MAR-06 13:42:24 GMT

.
DATA COLLECTED
===============
RDA OUTPUT
------------
Database Registry:
--------------------------
Component ID Component Name Status Version
CATALOG Oracle Database Catalog Views VALID 10.2.0.2.0
CATJAVA Oracle Database Java Packages VALID 10.2.0.2.0
CATPROC Oracle Database Packages and Types VALID 10.2.0.2.0
EM Oracle Enterprise Manager VALID 10.2.0.2.0
EXF Oracle Expression Filter VALID 10.2.0.2.0
JAVAVM JServer JAVA Virtual Machine VALID 10.2.0.2.0
OWM Oracle Workspace Manager VALID 10.2.0.1.0
RUL Oracle Rule Manager VALID 10.2.0.2.0
XDB Oracle XML Database VALID 10.2.0.2.0
XML Oracle XDK VALID 10.2.0.2.0

10-MAR-06 13:46:12 GMT

.
CAUSE DETERMINATION
====================
Database option Oracle Text not installed

CAUSE JUSTIFICATION
====================
Procedure XDB_DATASTORE_PROC is part of Full-Text Search Over XML
Oracle Text is reqired for this functionality

.
POTENTIAL SOLUTION(S)
======================
Install Oracle Text, then create DBMS_XDBT package and additional objects
- or -
ignore the error

POTENTIAL SOLUTION JUSTIFICATION(S)
====================================
Oracle text is required for Full-Text Search

10-MAR-06 13:52:02 GMT

.
SOLUTION / ACTION PLAN
=======================
To implement the solution, please execute the following steps:

1. Install Oracle Text in following way:
- Install Oracle Text as described in Metalink
Note 280713.1 "Manual installation, deinstallation of Oracle Text 10gR1and 10gR2"
- Run script $ORACLE_HOME/rdbms/admin/dbmsxdt.sql
- Rerun script $ORACLE_HOME/rdbms/admin/catupgrd.sql

- OR -

2. Ignore this error

For more information about Full-Text SDearch over XML files please refer to Oracle documentation
Oracle® XML DB Developer's Guide 10g Release 2 (10.2)
Chapter 10: "Full-Text Search Over XML"

10-MAR-06 13:52:27 GMT

Gyorsak voltak.