Package Body WKSYS.WK_CRW is INVALID after Manual Installation of Ultra Search (Doc ID 311294.1)

Last updated on JANUARY 17, 2014

Applies to:

Oracle Ultra Search - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 16-Jul-2012***


Symptoms

After manual installation of Oracle Ultra Search by running wk0install.sql, WKSYS.WK_CRW PACKAGE BODY remains invalid.

Spool file of execution of wk0install.sql shows error ORA-942 :

...
SQL> grant select on SYS.DBA_LOCK to WKSYS;
grant select on SYS.DBA_LOCK to WKSYS
ERROR at line 1:
ORA-00942: table or view does not exist
...

If you try to compile package body WK_CRW, you get error ORA-980 :

SQL> alter package WK_CRW compile body;

Warning: Package Body created with compilation errors.

SQL> show errors

Errors for PACKAGE BODY WK_CRW:

LINE/COL ERROR
------------- -----------------------------------------------------------------
3357/13 PL/SQL: SQL Statement ignored
3357/49 PL/SQL: ORA-00980: synonym translation is no longer valid
4277/5 PL/SQL: SQL Statement ignored
4277/41 PL/SQL: ORA-00980: synonym translation is no longer valid
...

To find out which synonym is invalid, you can run following query :

SQL> select referenced_owner, referenced_name, referenced_type
from dba_dependencies where name = 'WK_CRW'
and owner = 'WKSYS'
and referenced_type = 'SYNONYM';

And try to query all the synonyms.

Query on synonym DBA_LOCK cannot be queried

SP2-0749: Cannot resolve circular path of synonym "DBA_LOCK"

On checking dba_objects, you find only a public synonym DBA_LOCK which points to view SYS.DBA_LOCK. But there is no view DBA_LOCK in SYS schema.

Changes

Attempting to install Oracle Ultra Search Server Components using steps mentioned in

<Note 283292.1> "How to Manually Install and Uninstall Ultra Search 10gR1 Server Components"
or
<Note 337992.1> "How to Manually Install and Uninstall Ultra Search 10gR2 Server Components"

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