6 Removing Oracle Software

This chapter describes how to remove Oracle software from the system. It includes information about the following tasks:

Removing Oracle Software Files
Removing Oracle HTML DB Database Objects

Removing Oracle Software Files

The following steps describe how to use the Installer to remove Oracle software from an Oracle home:

Note:

Always use the Oracle Universal Installer to remove Oracle software. Do not delete any Oracle home directories without first using the Installer to remove the software.

If necessary, log in as the oracle user:
```
$ su - oracle
```
Set the ORACLE_HOME environment variable to specify the path of the Oracle home directory that you want to remove:
- Bourne, Bash, or Korn shell:
```
$ ORACLE_HOME=oracle_home_path 
$ export ORACLE_HOME
```
- C shell:
```
$ setenv ORACLE_HOME oracle_home_path
```
Start the Installer as follows:
```
$ $ORACLE_HOME/oui/bin/runInstaller
```
In the Welcome screen, click Deinstall Products.

The Inventory screen appears, listing all of the Oracle homes on the system and the products installed in each Oracle home.
In the Inventory screen, select the Oracle home or the products that you want to remove.
Click Remove.

The Installer displays a confirmation screen asking you to confirm that you want to deinstall the products and their dependant components.
Click Yes.

The Installer displays a progress indicator as it removes the software.

Removing Oracle HTML DB Database Objects

When you install Oracle HTML DB, a configuration assistant creates database objects in the database that you specify during the installation. To completely remove Oracle HTML DB, you must remove the database objects from that database after you remove the software. To remove the Oracle HTML DB database objects from a database, follow these steps:

Using SQL*Plus, connect to the database as the SYS or SYSTEM user:
```
$ sqlplus "SYS/SYS_password AS SYSDBA"
```

Enter the following commands to remove the database objects:

SQL> ALTER SESSION SET CURRENT_SCHEMA = flows_010500;
SQL> EXEC wwv_flow_upgrade.drop_public_synonyms;
SQL> ALTER SESSION SET CURRENT_SCHEMA = SYSTEM;
SQL> DROP USER flows_010500 CASCADE;
SQL> DROP USER flows_files CASCADE;
SQL> DROP USER htmldb_public_user CASCADE;