4 Deinstalling Oracle Warehouse Builder

This chapter contains the following topics for deinstalling Oracle Warehouse Builder components:

• General Steps for Deinstalling Warehouse Builder

• Deleting the Repository Users

• Deleting the Repository Owner

• Deinstalling the Oracle Warehouse Builder Software

• Deleting the Schema Objects

General Steps for Deinstalling Warehouse Builder

The steps you take to deinstall Warehouse Builder depends on if you want to remove only the client components from a computer or remove all server and client components from your environment.

To remove a client installation, follow the instructions in "Deinstalling the Oracle Warehouse Builder Software".

If you want to deinstall all Warehouse Builder components including the repository, you must have SYSDBA privileges to the repository database. Follow the order of steps presented in this chapter to avoid deleting components manually through a utility such as SQL Plus.

If you are deinstalling multiple or all components, follow the order presented in this chapter.

To deinstall all components, complete the following steps:

1. Deleting the Repository Users

   Use the Advanced Setup option in the Repository Assistant to delete one or more users.

2. Deleting the Repository Owner

   Use the Advanced Setup option in the Repository Assistant to delete the repository owner.

3. Deinstalling the Oracle Warehouse Builder Software

   Launch the Oracle Universal Installer to deinstall the software components.

4. Deleting the Schema Objects (optional step)

Deleting the Repository Users

Before you can deinstall a repository owner, you must first delete the associated repository users. When you delete a repository user, you unregister and remove the user from the repository. Deleting the user from the Warehouse Builder repository does not delete or alter the user account in the Oracle Database.

To delete repository users:

1. Launch the Oracle Warehouse Builder Repository Assistant.

   For Windows, select Start, Programs, OWB_ORACLE_HOME, Warehouse Builder, Administration, and then click Repository Assistant.

   For UNIX, locate OWB_ORACLE_HOME/owb/bin/unix and execute reposinst.sh.

2. On the Install Type page, select Advanced Setup, and click Next.

3. In the Connection Information page, provide the following information to connect to the repository:

   • SYSDBA User Name

   • SYSDBA Password

   • Host Name

   • Port Number (The default Port Number is 1521)

   • Oracle Service Name

4. On the Choose Operation page, select Manage Warehouse Builder repository users option and click Next.

5. In the Manage Repository Users page, select the option Delete the registration of one or more Warehouse Builder repository users.

6. In the Repository Owner Information page, select the repository owner from which you want to delete the associated user. Then type the password for that repository owner and click Next. The Select Repository Users page is displayed.

7. Select the repository users to be deleted, then click the left to right shuttle button to move the user to the Selected: box.

8. On the Summary page, review your selections and click Finish.

The Deinstallation Successful page appears after the repository user is deleted.

Deleting the Repository Owner

After deleting the repository users, you can delete the repository owner. When you delete a repository owner, you unregister and remove the owner from the repository. Deleting the owner from the Warehouse Builder repository does not delete or alter the owner account in the Oracle Database.

To delete the repository owner:

1. Launch the Repository Assistant and navigate to the Choose Operation page.

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

2. In the Choose Operation page, select Manage a Warehouse Builder repository owner option.

3. Click Next.

4. In the Manage Repository Owner page, select Delete an existing Warehouse Builder repository owner option.

5. Click Next. The Repository Owner Information page is displayed.

6. Enter the Repository Owner Password.

7. On the Summary page, review your selections and click Finish.

The Deinstallation Successful page appears once the repository owner is deleted.

Deinstalling the Oracle Warehouse Builder Software

To deinstall the Oracle Warehouse Builder:

1. Launch the Oracle Universal Installer.

   For Windows, select Start, Programs, OWB_ORACLE_HOME, Oracle Installation Products, and then click Universal Installer.

   For UNIX, locate OWB_ORACLE_HOME/oui/bin and execute runInstaller.sh.

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

3. In the Inventory page, on the Contents tab, in the You have the following Oracle products installed box, select the Oracle Warehouse Builder home.

4. Click Remove.

5. In the Confirmation page, click Yes to deinstall the Oracle Warehouse Builder. The deinstallation process begins.

6. After the deinstallation completes, click Close in the Inventory page.

7. In the Oracle Universal Installer: Welcome page, click Cancel to close the Oracle Universal Installer page.

Deleting the Schema Objects

When you delete a repository user or the repository owner, you unregister and remove the owner from the repository. Deleting the user or owner from the Warehouse Builder repository does not delete or alter the owner account in the Oracle Database.

Use the Oracle Enterprise Manager to drop the repository users, repository owners, and the Warehouse Builder related roles and synonyms permanently from the Oracle Database.