Sunday, February 20, 2011

ORA-04043: object XDB_DATASTORE_PROC does not exist

Sympton:
This error occurred during upgrade from 11.2.0.1 to 11.2.0.2, according ly MOS note 360907.1, it applies to upgrade from 10.2.0.x, 11.1.0.x and 11.2.0.1 upgrading to 11.2.0.2.

Causes:
XML Database (XDB) installed, but Oracle Text was not installed.

Impact:
It can be ignored if Oracle Text is not in use, otherwise configure Oracle Text and execute script "dbmsxdbt.sql" as sysdba.