Uninstalling BMC Digital Workplace Catalog

Perform the following tasks to remove the BMC Digital Workplace Catalog application from the primary or secondary server and the database objects from the database server.

To remove the BMC Digital Workplace Catalog application

The remove-digitalworkplace.sh script stops a running server and removes the existing files from the current installation. If the script cannot find an existing installation, the script searches the system for the installation location and then prompts you to confirm its deletion.

1. Navigate to the folder where the installation package was extracted. If you cannot remember where the files were extracted, download the installation package and extract a new copy of the files.

2. Run the remove-digitalworkplace.sh script:

   # ./remove-digitalworkplace.sh

   After the application has been removed, you must remove the database objects.

To remove the database objects

An administrator with DBA permissions must drop the databases or tablespaces and users. For an Oracle database, modify the example commands in this procedure to find and remove the database objects from an Oracle database server. A Microsoft SQL Server administrator should perform similar operations using SQL Server Management Studio.

1. Enter the database management client.

   Example

   $ sqlplus sys as sysdba
   
   SQL*Plus: Release 11.2.0.4.0 Production on Fri May 26 00:33:38 2017
   
   Copyright (c) 1982, 2013, Oracle.  All rights reserved.
   
   Enter password: ********
   
   Connected to:
   Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
   With the Partitioning, OLAP, Data Mining and Real Application Testing options
   SQL> 

2. Find and drop the tablespaces.

   Example

   SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM USER_TABLESPACES;
   TABLESPACE_NAME                STATUS    CONTENTS
   ------------------------------ --------- ---------
   ...
   dwp_db_temp                    ONLINE    TEMPORARY
   dwp_db_app                     ONLINE    PERMANENT
   dwp_db_tenant                  ONLINE    PERMANENT
   
   SQL> DROP TABLESPACE dwp_db_temp INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
   SQL> DROP TABLESPACE dwp_db_app INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
   SQL> DROP TABLESPACE dwp_db_tenant INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; 

3. Find and drop the users.

   Example

   SQL> SELECT USERNAME FROM DBA_USERS;
   USERNAME
   ------------------------------
   ...
   dwp_admin_app
   dwp_admin_tenant
   
   SQL> DROP USER dwp_admin_app CASCADE;
   SQL> DROP USER dwp_admin_tenant CASCADE; 

4. Find and drop the roles.

   Example

   SQL> SELECT ROLE FROM DBA_ROLES;
   ROLE
   ------------------------------
   ...
   dwp_dbadmin_role
   
   SQL> DROP ROLE dwp_dbadmin_role;