Sunday, March 1, 2015

De-Install Oracle Ware House Builder in 11g Database.




We have created a new database using DBCA with custom template option which has installed Oracle Ware House Builder 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
OWBSYS
OWBSYS_AUDIT

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

#########################################
# 2) Script to De-Install OWB
#########################################

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

$ORACLE_HOME/owb/UnifiedRepos/clean_owbsys.sql

#### Lets see what is being stored in "clean_owbsys.sql"

[oracle@host01 UnifiedRepos]$ more clean_owbsys.sql
drop user owbsys cascade;
drop user owbsys_audit cascade;
drop role OWB_user;
drop role OWB_DESIGNCENTER_view;
drop role OWB$CLIENT;
-- Bug Fix 6233292:
-- exit
[oracle@host01 UnifiedRepos]$

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

#########################################
# 3) De-Install OWB
#########################################

[oracle@host01 UnifiedRepos]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 27 17:35:45 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/owb/UnifiedRepos/clean_owbsys.sql
User dropped.

User dropped.

Role dropped.

Role dropped.

Role 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: