Oracle Ultra Search is INVALID after upgrading from 11.1.0.6 to 11.1.0.7

(Doc ID 1127292.1)

Last updated on MARCH 20, 2012

Applies to:

Oracle Ultra Search - Version: 11.1.0.7 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.
Checked for relevance on 21-Mar-2012

Symptoms

Since upgrading the database from 11.1.0.6 to 11.1.0.7, the Oracle Ultra Search component and the WKSYS.WK$ACLVIEW view are INVALID.

COMP_ID STATUS     VERSION    COMP_NAME
------- ---------- ---------- -----------------------
WK      INVALID    11.1.0.7.0 Oracle Ultra Search

SQL> select OBJECT_NAME, OBJECT_TYPE, STATUS
     from all_objects where OWNER='WKSYS' and status='INVALID';

OBJECT_NAME   OBJECT_TYPE STATUS
------------- ----------- -------
WK$ACLVIEW    VIEW        INVALID

Attempts to recompile the view fails with an ORA-1031:

SQL> select owner, name, type, text from dba_errors where name='WK$ACLVIEW';

OWNER  NAME         TYPE  TEXT
------ ------------ ----- ----------------------------------
WKSYS  WK$ACLVIEW   VIEW  ORA-01031: insufficient privileges


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