This chapter describes how to completely remove all Oracle Databases, their instances, and related software from an Oracle home directory. It includes information about the following topics:
Note:
If you want to remove an Oracle Real Application Clusters (Oracle RAC) installation, then see Oracle Real Application Clusters Installation and Configuration Guide for more information.If you want to remove an individual product, then check the product-specific documentation for requirements and restrictions.
To identify all instances associated with the Oracle home that you want to remove, log in to the Oracle Database account and enter the following command:
$ SHOW LOGICAL SYS$LOGIN
Example output:
DISK$ORACLE1:[ORACLE11G]
The instance names are in the ORATAB file in the subdirectory for the current node:
$ TYPE DISK$ORACLE1:[ORACLE11G.nodename]ORATAB.
The output of this command contains entries similar to the following:
$ORACLE_SID:ORACLE_HOME:Y/N
Where:
SID is the system identifier of the Database.
ORACLE_HOME is the home directory of the Database.
For Example:
SID:/VMSDISK/ORACLE_HOME:N
To completely remove Oracle Database software, you must remove any installed databases. To remove an Oracle Database:
Log in to the Oracle Database account.
Enter the following command to change the directory to the default database location:
$ set default oracle_home_directory
Run the ORAUSER command procedure, specifying the SID for the database that you want to remove:
$ @ORAUSER sid
Use the $ SET DISPLAY command to direct X-Windows to your PC or workstation.
Start Database Configuration Assistant by using the following command:
$ DBCA
The Welcome screen is displayed.
Click Next.
The Operations screen is displayed.
Select Delete a Database, then click Next.
Select the database that you want to delete, and then click Finish.
In the screen that is displayed, confirm that you want to delete the database.
When Database Configuration Assistant removes the database, you are prompted to select whether you want to perform another operation. Click Yes to return to the Operations screen or click No to exit from Database Configuration Assistant. If you want to remove another database, click Yes and repeat Steps 6 through 8.
The following steps describe how to use the Installer to remove Oracle software from an Oracle home:
Note:
Always use Oracle Universal Installer to remove Oracle software. Do not delete any Oracle home directories without first using Oracle Universal Installer to remove the software.Remove any database instances that are associated with this Oracle home, and delete or reconfigure the Oracle Cluster Synchronization Services daemon.
Stop any processes running in this Oracle home:
If necessary, log in to the Oracle Database account.
Run the ORAUSER.COM file to redefine the Oracle home.
$ @ORAUSER
Use the $ SET DISPLAY command to direct X-Windows to your PC or workstation.
Start Oracle Universal Installer as follows:
$ @dvd_device:[DATABASE]RUNINSTALLER
If the product was installed from the [CLIENT] or [COMPANION] directory of the Installation Media, then use that directory instead of [DATABASE].
In the Welcome screen, click Deinstall Products.
The Inventory screen is displayed, listing all of the Oracle homes on the system.
In the Inventory screen, select the Oracle home and the products that you want to remove, then click Remove.
When Oracle Universal Installer displays a confirmation screen asking you to confirm that you want to uninstall the products and their dependent components, click Yes.
The Installer displays a progress indicator as it removes the software.
When the products have been deleted, click Cancel to exit from Oracle Universal Installer, then click Yes.
Note:
Always use Oracle Universal Installer to remove Oracle software. Do not delete any Oracle home directories without first using Oracle Universal Installer to remove the software.