Vladimir M. Zakharychev wrote:
> 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
It turned out that the user wksys account was locked&expired ;)
By the way, I have an access to metalink but not directly. My company
has an agreement with our software producer. Unfortunately I needed
help immediately ;)
Thanks Vladimir
Received on Mon Jul 03 2006 - 05:39:27 CDT
