2011-08-05

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: 10.2.0.4 to 11.2.0.2.0 - Release: 10.2 to 11.2
Information in this document applies to any platform.
Checked for Relevance on 06-Sep-2010

Symptoms

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;

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

Changes

Upgrading the DB to 10.2.0.X or 11.1.0.X

Cause

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.

Solution

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