ORA-04043: object XDB_DATASTORE_PROC does not exist

Catupgrd.sql Gives ORA-4043 Error On XDB_DATASTORE_PROC [ID 360907.1]

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 10.2 to 11.2
Information in this document applies to any platform.
Checked for Relevance on 06-Sep-2010


Running catupgrd.sql to upgrade the DB to 10.2.0.X, 11.1.0.X or 11.2.0.X shows the following error:

alter procedure xdb.XDB_DATASTORE_PROC compile
ERROR at line 1:
ORA-04043: object XDB_DATASTORE_PROC does not exist

The DBA_REGISTRY shows the following:

select comp_name, status, version from dba_registry;

----------------------------------- ----------- ---------------
Oracle interMedia VALID
Oracle XML Database VALID
Oracle Expression Filter VALID
Oracle Rule Manager VALID
Oracle Workspace Manager VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
JServer JAVA Virtual Machine VALID
Oracle Database Java Packages VALID
Oracle Real Application Clusters VALID


Upgrading the DB to 10.2.0.X or 11.1.0.X


The database is OK. 
The error message occurs because the package does not exist.  The package does not exist because Oracle Text was not installed when XML database (XDB) was installed.


Oracle Text is not mandatory for XDB and the error can be ignored. If Text functionality with XDB is required, then you need to Install Oracle Text. After Oracle Text is installed you can create the missing package running dbmsxdbt.sql
1. Install Oracle Text
For 10g: Note 280713.1 Manual installation, deinstallation of Oracle Text 10gR1 and 10gR2
For 11gR1: Note 579601.1 Manual installation, deinstallation and verification of Oracle Text 11gR1
For 11gR2: Note 970473.1 Manual installation, deinstallation and verification of Oracle Text 11gR2
2. Run script dbmsxdbt.sql connected as sys as sysdba
conn sys as sysdba

Niciun comentariu:

Trimiteți un comentariu