How to Install/deinstall Oracle Workspace Manager (document ID 263428.1)

In this Document

Goal

Solution

References

Applies To:

Workspace manager-version 9.0.1.0 to 12.1.0.1 [Release 9.0.1 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 30-may-2014.

GOAL

This article are for DBAs and explains how to Install/deinstall Oracle Workspace Manager.

Solution

The scripts to Install/deinstall Workspace Manager is as follows:

Deinstall

note:de-installing Oracle Workspace Manager would remove any existing workspaces and the associated metadata.

1. Disable versioning on all version-enabled tables in the database before de-installing Oracle Workspace Manager. To verify if you have any currently version-enabled tables in your database:

From Sql*plus connected to the database as a DBA user, enter:

SELECT * from All_wm_versioned_tables;

Once you had confirmed you had no versioned tables, or the count read 0, then you can proceed with the deinstall.

2. To uninstall Workspace Manager, run the following script, as SYS:

$ORACLE _HOME/RDBMS/ADMIN/OWMUINST.PLB

INSTALL


If you wish to reinstall Workspace Manager @ A later time, you can run, as SYS:

$ORACLE _HOME/RDBMS/ADMIN/OWMINST.PLB

The Install/upgrade/de-install process is also discussed in the Readme included in the kit. The Readme is supplied with Workspace Manager patch kits.

These scripts can be run at any time without have to bounce the database, as long as OWM are not being used.

REFERENCES

Note:727765.1-how to determine if Workspace Manager is Being used?
Note:358825.1-oracle Workspace Manager Does not Remove Completely

How to Install/deinstall Oracle Workspace Manager (document ID 263428.1)