Ultra Search Shows Invalid Status on 9.2.0.8 (Doc ID 971894.1)

Last updated on MAY 06, 2013

Applies to:

Oracle Ultra Search - Version 9.2.0.8 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.
***Checked for relevance on 06-May-2013***


Symptoms

The Ultra Search component is invalid in DBA_REGISTRY, no invalid objects exists.

SQL> select status from dba_registry where comp_name = 'Oracle Ultra Search';

  STATUS
--------
 INVALID

SQL> select count(*) from dba_objects where owner = 'WKSYS' and status = 'INVALID';

  COUNT(*)
----------
         0


Trying to re-compile Ultra Search as below throws an error and Ultra Search is still invalid:

SQL> @?/ultrasearch/admin/wkvalid.sql

...

Procedure created.

SQL> set serverout on
SQL> exec sys.validate_wk
Invoking Ultra Search Install/Upgrade validation procedure VALIDATE_WK
=======================================================
= WKSYS schema validation failed: ORA-01031: insufficient
privileges
ORA-06512: at "SYS.DBMS_REGISTRY", line 83
ORA-01403: no data found
=======================================================

PL/SQL procedure successfully completed.

Changes

The database was created using DBCA after the 9.2.0.8 Patch Set has been installed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms