Space banner

 

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

To view the latest 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
    ------------------------------ --------- ---------
    ...
    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;

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

Comments