This documentation supports the 19.05 version of BMC Digital Workplace Advanced.

To view an earlier version, select the version from the Product Version menu.

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;

Was this page helpful? Yes No Submitting... Thank you

Comments