OWMINST.PLB=ORA-6575 ORA-942 / %_WM_TAB_TRIGGERS OBJECTS=INVALID (Doc ID 976295.1)

Last updated on OCTOBER 29, 2013

Applies to:

Workspace Manager - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 29-October-2013***


Symptoms

The Workspace Manager installation script (owminst.plb) returns a number of ORA-6575 errors such as:

wmsys.ltadm.AreThereDiffs(t.owner, t.table_name) diff
*
ERROR at line 7:
ORA-06575: Package or function LTADM is in an invalid state



and a number of ORA-942 errors such as:

from wmsys.wm$all_locks_view t, all_views s
*
ERROR at line 3:
ORA-00942: table or view does not exist


Afterwards, there are four invalid Workspace Manager-related objects:

SQL> SELECT owner, object_name, object_type, status
  2  FROM dba_objects
  3  WHERE status != 'VALID'
  4  ORDER BY 1,2;

OWNER      OBJECT_NAME               OBJECT_TYPE     STATUS
---------- ------------------------- --------------- -----------
PUBLIC     ALL_WM_TAB_TRIGGERS       SYNONYM         INVALID
PUBLIC     USER_WM_TAB_TRIGGERS      SYNONYM         INVALID
WMSYS      ALL_WM_TAB_TRIGGERS       VIEW            INVALID
WMSYS      USER_WM_TAB_TRIGGERS      VIEW            INVALID

4 rows selected.

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