5 Uninstalling Oracle Warehouse Builder

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:

• Removing only the client components

  To remove OWB components from a host where there is no repository, follow the instructions in "Uninstalling the Oracle Warehouse Builder Software". If you want to uninstall all Warehouse Builder components including the repository, then you must have SYSDBA privileges to the repository.

• Removing both server and client components from your environment

  To remove all components, you must complete the following tasks, in that sequence. Otherwise, you may have to manually delete some components:

  1. Use the Advanced Setup option in the Repository Assistant to delete all workspace users, as described in "Deleting the Workspace Users".

  2. Use the Advanced Setup option in the Repository Assistant to delete the workspace owner, as described in "Deleting the Workspace".

  3. [Optional] Delete the OWB schema objects, as described in "Deleting the Schema Objects"

  4. Delete the repository, as described in "Deleting a Repository from an Oracle Database"

  5. Start the Universal Installer to uninstall the software components, as described in "Uninstalling the Oracle Warehouse Builder Software".

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 unregister 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 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 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 the illustration del_wksp_users_03.gif
   
   

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

   Click Next.

   
   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 the illustration del_wksp_users_05.gif
   
   

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

   Click Next.

   
   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 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 the illustration del_wksp_users_08.gif
   
   

9. In the Summary screen, click Finish.

   
   Description of the illustration del_wksp_users_09.gif
   
   

10. On the Deinstallation Result screen, click OK.

    
    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 unregister 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 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 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 the illustration del_wksp_users_05.gif
   
   

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

   Click Next.

   
   Description of the illustration del_wksp_users_06.gif
   
   

6. On the Summary screen, click Finish.

   
   Description of the illustration del_wksp_users_14.gif
   
   

7. On the Deinstallation Result screen, click OK.

   
   Description of the illustration del_wksp_users_15.gif
   
   

Deleting the Schema Objects

When you delete a workspace user or the workspace owner, you unregister 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 10g R2, 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 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.