Re: Ptachset 9.2.0.7 problem

tomunio wrote:
> Hello
> I've installed Patchset 9.2.0.7.0 on my Oracle database ver. 9.2.0.6.0
> - Linux platform.
> All the scripts were done without any problem.
> Unfortunately the following query (select * from dba_registry) shows
> that Ultra Search component is INVALID (WK Oracle Ultra Search
> 9.2.0.7.0 INVALID 28-CZE-2006 12:33:07 SYS WKSYS VALIDATE_WK)
> I tried SQL> exec sys.validate_wk but the status is still INVALID
> Supposedly there is a script called wkvalid.sql, which helps to solve
> this problem but I cannot find it neither on
> http://www.oracle.com/technology//products/ultrasearch/index.html nor
> anywhere else
> ps. I haven't got an access to metalink :(
> Thx in advance

wkvalid.sql is the source of validate_wk procedure. It's default location is at $ORACLE_HOME/ultrasearch/admin/ and all it does is checks if any objects in WKSYS schema are invalid and attempts to validate (compile) them if there are any. If there are still invalid objects in the schema after this validation attempt, WK is marked invalid in the registry.

When you ran validate_wk, what was the output? Did you set serveroutput on in sqlplus before running the procedure? If not - do it and re-run the procedure, then see which objects are invalid and try to figure out why and fix them.

By the way, do you use UltraSearch anyway? If you don't then just ignore this component status.

Hth,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Sat Jul 01 2006 - 11:35:47 CDT