5 Uninstalling Oracle Warehouse Builder

This section describes how to uninstall Oracle Warehouse Builder.

This section includes the following topics:

About Uninstalling Oracle Warehouse Builder

You cannot uninstall Oracle Warehouse Builder in Oracle Database 11g Release 2.

To uninstall earlier versions of Oracle Warehouse Builder, you have two general options:

Deleting the Workspace Users

Before you can uninstall a workspace owner, you must first delete the associated workspace users. When you delete a workspace user, you un-register and remove the user from the repository. Deleting the user from Oracle Warehouse Builder repository does not delete or alter the corresponding user account in the Oracle Database.

To delete workspace users:

  1. Start Oracle Warehouse Builder Repository Assistant.

    On Windows, select Start, Programs, Oracle-OWB11.2, Oracle Warehouse Builder, Administration, and then click Repository Assistant.

    Description of del_wksp_users_01.gif follows
    Description of the illustration del_wksp_users_01.gif

    On Linux, in the OWB_HOME/owb/bin/unix directory, run the reposinst.sh script.

  2. On the Welcome screen, click Next.

    Description of del_wksp_users_02.gif follows
    Description of the illustration del_wksp_users_02.gif

  3. On the Database Information page, enter the Host Name, Port Number, and Oracle Service Name. Click Next.

    These details are automatically filled in based on the values entered in the install and configuration stage.

    In this example, the values used are of LOCALHOST, 1521, and orcl, respectively.

    Description of del_wksp_users_03.gif follows
    Description of the illustration del_wksp_users_03.gif

  4. On the Choose Operation screen, select Manage Warehouse Builder workspace users option.

    Click Next.

    Description of del_wksp_users_04.gif follows
    Description of the illustration del_wksp_users_04.gif

  5. On the Workspace Owner/Admin screen, enter the Workspace Owner / Admin User Name (wks_owner1), and Workspace Owner / Admin Password.

    Click Next.

    Description of del_wksp_users_05.gif follows
    Description of the illustration del_wksp_users_05.gif

  6. On the Workspaces screen, select the Workspace Name (WKS_OWNER1.WKS1).

    Click Next.

    Description of del_wksp_users_06.gif follows
    Description of the illustration del_wksp_users_06.gif

  7. On the Options (Workspace Users) screen, select Un-register of Warehouse Builder workspace users.

    Click Next.

    Description of del_wksp_users_07.gif follows
    Description of the illustration del_wksp_users_07.gif

  8. On the Select Workspace Users screen, move the users you want to delete from the Available list to the Selected list. Click Next.

    Description of del_wksp_users_08.gif follows
    Description of the illustration del_wksp_users_08.gif

  9. In the Summary screen, click Finish.

    Description of del_wksp_users_09.gif follows
    Description of the illustration del_wksp_users_09.gif

  10. On the Deinstallation Result screen, click OK.

    Description of del_wksp_users_10.gif follows
    Description of the illustration del_wksp_users_10.gif

Deleting the Workspace

After deleting the workspace users, you can delete the workspace. When you delete a workspace owner, you un-register and remove the owner from the repository. Deleting the owner from the repository does not delete or alter the owner account in the Oracle Database.

To delete the workspace:

  1. Repeat steps 1 through 3 in "Deleting the Workspace Users".

  2. On the Choose Operation screen, select Manage Warehouse Builder workspaces.

    Click Next.

    Description of del_wksp_users_11.gif follows
    Description of the illustration del_wksp_users_11.gif

  3. On the Choose Workspace Operations screen, select Drop and existing Warehouse Builder workspace.

    Click Next.

    Description of del_wksp_users_12.gif follows
    Description of the illustration del_wksp_users_12.gif

  4. On the Workspace Owner/Admin screen, enter the Workspace Owner / Admin User Name (wks_owner1), and Workspace Owner / Admin Password.

    Click Next.

    Description of del_wksp_users_05.gif follows
    Description of the illustration del_wksp_users_05.gif

  5. On the Workspaces screen, select the Workspace Name (WKS_OWNER.WKS1).

    Click Next.

    Description of del_wksp_users_06.gif follows
    Description of the illustration del_wksp_users_06.gif

  6. On the Summary screen, click Finish.

    Description of del_wksp_users_14.gif follows
    Description of the illustration del_wksp_users_14.gif

  7. On the Deinstallation Result screen, click OK.

    Description of del_wksp_users_15.gif follows
    Description of the illustration del_wksp_users_15.gif

Deleting the Schema Objects

When you delete a workspace user or the workspace owner, you un-register and remove that owner from the repository. This operation, however, does not delete that user or owner, or alter the account in the Oracle Database.

To permanently delete the workspace users, workspace owners, and the Oracle Warehouse Builder-related roles and synonyms permanently from Oracle Database, use Oracle Enterprise Manager. To enable Oracle Warehouse Builder user to run Enterprise manager, you must grant the appropriate permissions.

To grant access to Enterprise Manager:

  1. At the command prompt, start SQL*Plus.

    C:\> sqlplus
    
  2. When prompted for user name, log in as a user with administrative privileges.

    Enter user-name: sys/as sysdba
    Enter password: password
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2 - Production
    With the Partitioning, OLAP and Data Mining options
    
  3. Use the GRANT command:

    SQL> GRANT SELECT any dictionary to "&OWB repository user";
    

Deleting a Repository from an Oracle Database

To delete an Oracle Warehouse Builder 11g repository and associated objects from an Oracle Database 10g Release 2, use the SQL script clean_owbsys.sql, in the OWB_HOME/owb/UnifiedRepos directory.

These instructions are for deleting earlier Oracle Warehouse Builder installations. Oracle Warehouse Builder cannot be deleted from Oracle Database 11g Release 2 as the schemas remain; however, running the clean_owbsys.sql script removes all the objects inside the schema.

To delete the repository:

  1. At the command prompt, start SQL*Plus:

    C:\> sqlplus
    
  2. When prompted for user name, log in as a user with administrative privileges.

    Enter user-name: sys/as sysdba
    Enter password: password
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2 - Production
    With the Partitioning, OLAP and Data Mining options
    
  3. Run the clean_owbsys.sql script to drop the OWBSYS user and Oracle Warehouse Builder-related roles from the database:

    SQL> @OWB112/owb/UnifiedRepos/clean_owbsys.sql C:/OWB112
    

    If you previously used the Repository Assistant to create a workspace, or a workspace owner and database user, these they still exist in the database after running the clean_owbsys.sql script.

Uninstalling the Oracle Warehouse Builder Software

To uninstall Oracle Warehouse Builder software, you must use the Oracle Universal Installer.

Uninstalling Oracle Warehouse Builder deletes the files in OWB_HOME, namely the scripts necessary for cleaning up the schema and the repository. Therefore, this should be the last process you perform, after steps described in "Deleting the Schema Objects" and "Deleting a Repository from an Oracle Database".

To uninstall Oracle Warehouse Builder software:

  1. Start Oracle Universal Installer.

    On Windows, select Start, Programs, then select OWB_HOME, Oracle Installation Products, and then click Universal Installer.

    Description of uninstall_01.gif follows
    Description of the illustration uninstall_01.gif

    On Linux, run the script runInstaller.sh in the OWB_HOME/oui/bin directory.

  2. On the Oracle Universal Installer: Welcome page, click Deinstall Products.

  3. On the Inventory page, under the Contents tab, in the box titled "You have the following Oracle products installed," select the OWB home.

    Click Remove.

  4. On the Confirmation page, click Yes.

    The uninstallation process begins.

  5. After the process is complete, on the Inventory page, click Close.

  6. On the Oracle Universal Installer: Welcome page, click Cancel.

    This closes the Oracle Universal Installer.