Last updated on MAY 06, 2013
Applies to:Oracle Ultra Search - Version 18.104.22.168 to 22.214.171.124 [Release 9.2]
Information in this document applies to any platform.
***Checked for relevance on 06-May-2013***
The Ultra Search component is invalid in DBA_REGISTRY, no invalid objects exists.
SQL> select count(*) from dba_objects where owner = 'WKSYS' and status = 'INVALID';
Trying to re-compile Ultra Search as below throws an error and Ultra Search is still invalid:
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
ORA-06512: at "SYS.DBMS_REGISTRY", line 83
ORA-01403: no data found
PL/SQL procedure successfully completed.
The database was created using DBCA after the 126.96.36.199 Patch Set has been installed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms