16 Oracle Beehive Uninstall Wizard

You may uninstall the following products with the Oracle Beehive Uninstall Wizard:

Oracle Beehive Release 1
Oracle Beehive Provisioning Application
Oracle Coexistence Connector for Microsoft Exchange
Oracle Change Notification Service for Microsoft Exchange
Oracle Beehive for DMZ
Oracle Beehive Integration for Zimbra

The following topics about uninstalling Oracle Beehive are covered:

Starting the Oracle Beehive Install Wizard
Oracle Beehive Uninstall Wizard Sequence of Screens
Uninstalling Multiple Instances
Manually Uninstalling Oracle Beehive
Manually Deleting Oracle Beehive Tablespaces and Datafiles

Starting the Oracle Beehive Install Wizard

Start the Oracle Beehive Uninstall Wizard by running setup.exe -uninstall from the installation media.

Oracle Beehive Uninstall Wizard Sequence of Screens

The following screens appear during the uninstallation of Oracle Beehive:

Select Oracle Home to Uninstall: This screen will not appear if you start Oracle Beehive Uninstall Wizard with Oracle Beehive Config Wizard.
Option to Remove Database Schema: This screen will only appear if you are uninstalling Oracle Beehive Release 1 and it is the last one configured in your database.
Start Uninstallation
End of Uninstallation

Select Oracle Home to Uninstall

This screen lists all the Oracle Beehive products you have installed and their respective Oracle homes.

Select the Oracle Beehive home you want to uninstall.

This screen will not appear if you started the uninstall process by running the Config Wizard. In this case, the Config Wizard will uninstall the current Oracle Beehive home.

Option to Remove Database Schema

You will see this screen if you are uninstalling Oracle Beehive Release 1 and it is the last instance configured in your database.

Choose from one of the following options:

Remove Oracle Beehive Instance Only

This option will only deconfigure the Oracle Beehive instance.

Remove Oracle Beehive and Schema

This option will deconfigure the Oracle Beehive instance and remove the Oracle Beehive schema from the database. If you choose this option, you must provide the following information:

Admin User Name: Specify the administrative user name (that can perform database administration tasks) for the database instance. Typically, this user is the SYS account.
Admin User Password: Enter the password for the Oracle database administrative user account that you specified in the Admin User Name field.

Start Uninstallation

This screen will list actions that the Oracle Beehive Uninstall Wizard must perform to uninstall your chosen Oracle Beehive product.

Note:

If you started the uninstall process with the Config Wizard, the "Delete Oracle Home" action will not be displayed. This action will be performed after you have exited the Config Wizard graphical user interface.

Click Start Uninstall to proceed with the uninstallation of your chosen Oracle Beehive product.

Note:

On Microsoft Windows, if you receive an error message from the Oracle Beehive Uninstall Wizard that it was unable to delete the Oracle home folder, delete it manually, then restart your computer.

End of Uninstallation

This screen indicates that the uninstallation of the chosen Oracle Beehive product is successful.

Uninstalling Multiple Instances

If you wish to uninstall multiple instances of Oracle Beehive (which share the same database), uninstall each instance one at a time; do not run the Uninstall Wizard of each instance at the same time.

If you have multiple instances that share the same database, and you run the Uninstall Wizard of each instance at the same time, each Uninstall Wizard will assume that the instance it is uninstalling is not the last one to be uninstalled. As a result, the Oracle Beehive schema will not be removed from the database.

Manually Uninstalling Oracle Beehive

If you are unable to uninstall Oracle Beehive with the Uninstall Wizard because it was not able to remove the Oracle Beehive schemas from the database, follow these steps:

Stop all Oracle Beehive processes:

<Oracle Beehive home>/beehive/bin/beectl stop --all

Manually stop any Oracle Beehive processes:

Linux and UNIX-Based Operating Systems:
1. Look up remaining Oracle Beehive processes:
```
ps -ef --forest --columns 2000 | grep beehive
```
2. Kill any remaining Oracle Beehive processes.
Deinstall the Oracle Beehive repository with the following command:
```
perl schema_install.pl
  -deinstall
  -oracle_home <database home>
  -connect_string '<database connect string>'
```
The Perl script schema_install.pl is located in <Oracle Beehive home>/beehive/db. Perl can be found in <Oracle Beehive home>/perl.
Uninstall Oracle Beehive with Oracle Universal Installer. Run <Oracle Beehive home>/oui/bin/runInstaller.

Manually Deleting Oracle Beehive Tablespaces and Datafiles

To manually delete Oracle Beehive tablespaces and datafiles, run the following SQL*Plus commands as a user with SYSDBA privileges. Ensure that the environment variable ORACLE_SID is set to the SID of the database that contains the Oracle Beehive tablespaces and datafiles.

Note:

You may need to manually delete Oracle Beehive database users. Run the SQL command DROP USER <user name> CASCADE for the following users:

BEE_DATA
BEE_CDCPUB
BEE_CODE
ORABPEL
ORAWSM
ORAESB

SQL> SET LINE 1000 PAGES 0

This command sets the line size to a large number and suppresses other formatting information so that the next command can output additional SQL*Plus commands without any line breaks.
SQL> SELECT 'DROP TABLESPACE ' || tablespace_name || ' INCLUDING CONTENTS AND DATAFILES;' FROM dba_tablespaces WHERE tablespace_name LIKE 'BEE%';

This command outputs a list of tablespace DROP commands. Review each command before running them.

The following is an example of running these two commands, then running each of the generated tablespace DROP commands:

SQL> SET LINE 1000 PAGES 0
SQL> SELECT 'DROP TABLESPACE ' || tablespace_name || ' INCLUDING CONTENTS AND
  DATAFILES;' FROM dba_tablespaces WHERE tablespace_name LIKE 'BEE%';
DROP TABLESPACE BEE_ARCHIVE INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_AUDIT INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_DATA INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_INDEX INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_INTERFACE INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_LOBS INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_QUEUES INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_SEARCH_DATA INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_SEARCH_INDEX INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_SEARCH_LOBS INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE BEE_SEED INCLUDING CONTENTS AND DATAFILES;
 
11 rows selected.
 
SQL> DROP TABLESPACE BEE_ARCHIVE INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_AUDIT INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_DATA INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_INDEX INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_INTERFACE INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_LOBS INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_QUEUES INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_SEARCH_DATA INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_SEARCH_INDEX INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_SEARCH_LOBS INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.
 
SQL> DROP TABLESPACE BEE_SEED INCLUDING CONTENTS AND DATAFILES;
 
Tablespace dropped.

Manually Deleting Customized Oracle Beehive Customized Tablespaces and Datafiles

If you have customized the Oracle Beehive tablespace layouts, run the following SQL*Plus commands as a user with SYSDBA privileges:

SQL> SET LINE 1000 PAGES 0

This command sets the line size to a large number and suppresses other formatting information so that the next command can output additional SQL*Plus commands without any line breaks.
SQL> SELECT 'DROP TABLESPACE "' || ts_name || '" INCLUDING CONTENTS AND DATAFILES;' AS "Drop tablespace commands" FROM sys.bee_tablespaces;

This command generates a list of tablespace DROP commands. Review each command before running them.
SQL> DROP VIEW sys.bee_tablespaces;

This command drops the view that contains the customized tablespaces.