Sunday, March 1, 2015

De-Install Oracle WorkSpace Manager in 11g Database.




We have created a new database using DBCA with custom template option which has installed Oracle WorkSpace Manager in the database.

We don't use it and need to De-Install it. Below simple step can be used to De-Install it.


**************************************** Step By Step Procedure ******************************************************

#########################################
# 1) Check the users present in database..
#########################################

SQL> select username from dba_users where username like '%SYS%';
USERNAME
------------------------------
SYSTEM
SYS
APPQOSSYS
WMSYS

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

#########################################
# 2) Check for Version Tables
#########################################

Before De-Install Oracle WorkSpace manager we should make sure there is no version enabled tables on the database.

SQL> select * from all_wm_versioned_tables;
no rows selected
SQL>

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

#########################################
# 3) Script to De-Install WorkSpace Manager
#########################################

Below script is used to De-Install WorkSpace Manager from the 11g database.

$ORACLE_HOME/rdbms/admin/owmuinst.plb

#### Above Script Drops WMSYS user and its objects from the database which De-Install the Oracle WorkSpace Manager

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

#########################################
# 4) De-Install Oracle WorkSpace Manager
#########################################

[oracle@host01 admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 27 17:41:01 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> @/u01/app/oracle/product/11.2.0.3/rdbms/admin/owmuinst.plb
Procedure created.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Procedure dropped.
SQL>

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

#########################################
# 4) Check the users present in database..
#########################################

SQL> select username from dba_users where username like '%SYS%';
USERNAME
------------------------------
SYSTEM
SYS
APPQOSSYS

=====================================================================================================================
 Comments Are Always welcome
=====================================================================================================================

No comments: