Workspace Manager INVALID after applying April/July 2009 CPU (Doc ID 864559.1)

Last updated on SEPTEMBER 28, 2009

Applies to:

Workspace Manager - Version: 10.2.0.4.0 to 10.2.0.4.4
This problem can occur on any platform.

Symptoms

RDBMS Patchset version: 10.2.0.4.0

Workspace Manager Kit: 10.2.0.4.4

=========================

After applying the April or July 2009 CPU patch on your 10.2.0.4.0 RDBMS database, Workspace Manager now shows invalid within DBA_REGISTRY and you have invalid Workspace Manager specific objects:

select comp_name, status, version 
from dba_registry 
where comp_name='Oracle Workspace Manager' 
/

COMP_NAME STATUS VERSION
------------------------------ -------------------------------------------- ------------------------------
Oracle Workspace Manager INVALID 10.2.0.4.4

As for the invalid objects, you may see, but not limited to, the following invalid objects:

WMSYS.LT
WMSYS.UD_TRIGS

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