4
Deinstalling Warehouse Builder Components

This chapter contains instructions for deinstalling Warehouse Builder components. If you are deinstalling multiple or all components, make sure to follow the order presented in this chapter.

This chapter presents the deinstallation steps in the order that you must follow them:

• Step 1. Deinstall Design and Runtime Audit Browsers from Oracle9iAS

• Step 2. Deinstall Warehouse Builder Target Schema Objects

• Step 3. Deinstall Warehouse Builder Runtime Repository Objects

• Step 4. Deinstall Warehouse Builder Design Repository Objects

• Step 5. Deinstall Warehouse Builder or Remaining Oracle Software

4.1 Step 1. Deinstall Design and Runtime Audit Browsers from Oracle9iAS

You only need to follow these instructions if you integrated the Warehouse Builder Design Browser or the Warehouse Builder Runtime Audit Browser with Oracle9iAS. If you never ran the Warehouse Builder Browser Assistant to install these browsers, then you can skip this portion of the chapter.

If you did not follow the instructions in Section 2.8, "Step 7. (Optional) Integrate the Warehouse Builder Browsers into Oracle9iAS" to install these browsers into Oracle9iAS, then you are only running the Design and Runtime Audit Browser clients. The browser clients install and deinstall automatically when you run the Oracle Universal Installer Design Time installation.

To deinstall Warehouse Builder Browser objects from Oracle9iAS:

1. Launch the Warehouse Builder Browser Assistant.

   For Windows: Select Start, Programs, OWB_HOME, Warehouse Builder, and then select OWB Browser Assistant.

   For UNIX: Start a shell and navigate to:
   OWB_ORACLE_HOME/owb/bin/unix. For example, type:
   cd /private/home/OWB92/owb/bin/unix
Then run browserasst.sh.

2. In the Warehouse Builder Browser Assistant Welcome page, click Next.

3. In the Choose Operation page, select Deinstall Warehouse Builder Browser Objects.

   Follow the wizard to deinstall the Warehouse Builder Browser objects from your database.

4.2 Step 2. Deinstall Warehouse Builder Target Schema Objects

If you plan to drop a Target Schema user, you must first deinstall the Target Schema repository from that user. You can then drop the user in SQL*Plus.

Warning: Deinstalling a Target Schema means deinstalling your warehouse objects and the objects that run your warehouse jobs. Oracle recommends that you use Oracle Enterprise Manager rather than Oracle9i Warehouse Builder Runtime Assistant to deinstall your Target Schema objects.

To deinstall Warehouse Builder Target Schema objects:

1. Start the Warehouse Builder Runtime Assistant.

   For Windows: Select Start, Programs, OWB_HOME, Warehouse Builder, and then select OWB Runtime Assistant.

   For UNIX: Start a shell and navigate to:
   OWB_ORACLE_HOME/owb/bin/unix. For example, type:
   cd /private/home/OWB92/owb/bin/unix
Then run runtimeinst.sh.

2. In the OWB Runtime Assistant: Welcome page, click Next.

3. In the Choose Operation page, select Drop Existing Runtime Objects.

Follow the wizard to deinstall the Warehouse Builder Runtime Repository objects from your database.

Note: The Warehouse Builder Runtime Assistant does not drop user-defined objects from the runtime schema.

4.3 Step 3. Deinstall Warehouse Builder Runtime Repository Objects

To deinstall a Runtime Repository user, first run the Warehouse Builder Runtime Assistant to drop the existing Runtime Repository itself, as described in this section. You can then drop the user in SQL*Plus.

To deinstall Warehouse Builder Runtime Objects:

1. Start the Warehouse Builder Runtime Assistant.

   For Windows: Select Start, Programs, OWB_HOME, Warehouse Builder, and then select OWB Runtime Assistant.

   For UNIX: Start a shell and navigate to:
   OWB_ORACLE_HOME/owb/bin/unix. For example, type:
   cd /private/home/OWB92/owb/bin/unix
Then run runtimeinst.sh.

2. In the OWB Runtime Assistant: Welcome page, click Next.

3. In the Choose Operation page, select Drop Existing Runtime Objects.

Follow the wizard to deinstall the Warehouse Builder Runtime Repository objects from your database.

Note: The Warehouse Builder Runtime Assistant does not drop user-defined objects from the runtime schema.

4.4 Step 4. Deinstall Warehouse Builder Design Repository Objects

To deinstall a Warehouse Builder Design Repository:

1. Start the Warehouse Builder Repository Assistant.

   For Windows: Select Start, Programs, OWB_HOME, Warehouse Builder, and then select OWB Repository Assistant.

   For UNIX: Start a shell and navigate to:
   OWB_ORACLE_HOME/owb/bin/unix. For example, type:
   cd /private/home/OWB92/owb/bin/unix
Then run reposinst.sh.

2. In the OWB Repository Assistant: Welcome page, click Next.

3. In the Choose Operation page, select Drop Existing Repository Objects.

   Follow the wizard to deinstall the Warehouse Builder Repository objects from your database.

4.5 Step 5. Deinstall Warehouse Builder or Remaining Oracle Software

You must restart the Oracle Universal Installer to deinstall any remaining Warehouse Builder components. If you are deinstalling repositories, make sure to do so before you deinstall the Warehouse Builder Client software.

If you installed Oracle9i Warehouse Builder Server Side Install on this machine, make sure you complete the following before deinstalling Oracle software:

• Deinstall all the Runtime Repositories created from this machine.

• Stop the Name and Address (NAS) Server as follows:

  For Windows: Run ORACLE_HOME\owb\bin\win32\NAStop.bat.

  For UNIX: Run ORACLE_HOME/owb/bin/unix/NAStop.sh.

Always use the Oracle Universal Installer to remove Warehouse Builder from your computer. If you attempt to remove Warehouse Builder by deleting the directories manually, you can impair the operations of the Oracle Universal Installer.

To deinstall existing Oracle software:

1. Launch Oracle Universal Installer.

   Refer to the installation requirements, CD mounting instructions, and directions on running Oracle Universal Installer for different platforms, discussed in Section 1.9, "About Oracle Universal Installer".

   The Oracle Universal Installer (OUI) Welcome page displays. The Welcome screen provides information about the Oracle Universal Installer. The following function buttons appear on the Welcome screen and all installation screens that follow it.

   Exit: Quit the installation process and exit the installer.

   Help: Access detailed information about the functionality of each screen.

   Installed Products: View currently installed products. You can also use this list to review and select products you may want to deinstall.

   Previous: Return to the previous screen.

   Next: Move to the next screen.

   The Welcome screen has the following two additional buttons:

   Deinstall Products: Deinstall individual products or all products.

   About Oracle Universal Installer: View the version number of the installer in use.

2. On the OUI Welcome page, click Installed Products to obtain an inventory of all Oracle products installed on your system.

   The Inventory page displays a list of all Oracle products on your system.

3. Select the existing Oracle products that you want to remove, along with their components.

4. Click Remove.

If you have deinstalled Warehouse Builder, and it has left behind the path OWB_HOME\owb\j2ee\owbb, delete the owbb directory.