Unable to reinstall invalid Workspace Manager after upgrade

(Doc ID 2297818.1)

Last updated on AUGUST 16, 2017

Applies to:

Workspace Manager - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

After upgrade from 11.2.0.4 to 12.1.0.2, Oracle Workspace Manager was INVALID.

In an attempt to fix the component, several things were tried:

-- Tried to deinstall OWM. It failed because a lot of tables were versioned.
-- Developers tried to drop the schema as there were too many tables to de-version. This also failed.
-- Another attempt to deinstall OWM also failed.
-- An install was tried again hoping this could recreate missing objects and help to deinstall correctly. This also failed.

The goal now would be:

(1) To remove the versioning. We don't need to restore data.
(2) To reinstall OWM 12.1.0

How do we accomplish this?
 

Solution

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