How to Install/Deinstall Oracle Workspace Manager (文档 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 is for DBAs and explains how to install/deinstall Oracle Workspace Manager.

SOLUTION

The scripts to install/deinstall Workspace Manager are as follows:

DEINSTALL

 

Note: De-installing Oracle Workspace Manager will 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 have confirmed you have 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 at 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 having to bounce the database, as long as OWM is 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 (文档 ID 263428.1)

上一篇:Mysql对用户操作加审计功能——初级版


下一篇:oracle数据库查询当前数据占用量大小