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
   ------------------------------ --------- ---------
   ...
   DWPCTemp                    ONLINE    TEMPORARY
   DWPCatalog                  ONLINE    PERMANENT
   DWPCTenant                  ONLINE    PERMANENT
   
   SQL> DROP TABLESPACE DWPCTemp INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
   SQL> DROP TABLESPACE DWPCatalog INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
   SQL> DROP TABLESPACE DWPCTenant INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; 

3. Find and drop the users.

   Example

   SQL> SELECT USERNAME FROM DBA_USERS;
   USERNAME
   ------------------------------
   ...
   DWPCAdmin
   DWPCTenantAdmin
   
   SQL> DROP USER DWPCAdmin CASCADE;
   SQL> DROP USER DWPCTenantAdmin CASCADE; 

4. Find and drop the roles.

   Example

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