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

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。