Skip Headers
Oracle® Warehouse Builder Installation and Administration Guide
11g Release 2 (11.2) for Windows and Linux

Part Number E17130-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

5 Uninstalling Oracle Warehouse Builder

This section discusses 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 R2.

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 the Warehouse Builder repository does not delete or alter the corresponding user account in the Oracle Database.

To delete workspace users:

  1. Start the Oracle Warehouse Builder Repository Assistant.

    For Windows, select Start, Programs, Oracle-OWB112, 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

    For 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.

    Note that these details are automatically filled in based on the values entered in the install and configuration stage.

    In this example, we are using the values 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 Warehouse Builder-related roles and synonyms permanently from Oracle Database, use Oracle Enterprise Manager. To enable the OWB 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
    SQL*Plus: Release 11.2 - Production on Mon July 27 15:45:32 2009
     
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
    
  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 OWB 11g repository and associated objects from an Oracle Database 10R2, use the SQL script clean_owbsys.sql, in the OWB_HOME/owb/UnifiedRepos directory.

Note that these instructions are for deleting earlier OWB installations. OWB cannot be deleted from Oracle Database 11g R2 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
    SQL*Plus: Release 11.2 - Production on Mon July 27 15:58:47 2009
     
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
    
  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 OWB-related roles from the database:

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

    Note that 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 OWB software, you must use the Oracle Universal Installer.

Note that uninstalling OWB 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 the OWB software:

  1. Start Oracle Universal Installer.

    For 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

    For 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 deinstallation process begins.

  5. Once 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.