This chapter describes how to completely remove all Oracle databases, instances, and software from an Oracle home directory. It includes information about the following topics:
See Also:
The product-specific documentation for requirements and restrictions, to remove an individual productTo completely remove all Oracle databases, instances, and software from an Oracle home directory, you must:
Identify all instances associated with the Oracle home.
Remove database instances.
Shut down processes.
Remove the Oracle software.
To identify all instances associated with the Oracle home to be removed, enter the following command:
$ more /etc/oratab
The output of this command contains entries similar to the following:
CUST:/u01/app/oracle/product/10.2.0/db_1:N
This entry shows that the CUST Oracle database instance are associated with the /u01/app/oracle/product/10.2.0/db_1
Oracle home directory.
To completely remove Oracle Database software, you must remove any installed databases. To remove an Oracle database:
Note:
Removing an Oracle database deletes all of the data in the database. To keep this data, ensure that you back up the database before deleting it.Log in as the oracle
user:
$ su - oracle
Run the oraenv
or coraenv
script to set the environment for the database to be removed, for example:
For Bourne, Bash, or Korn shell:
$ . /usr/local/bin/oraenv
For C shell:
% source /usr/local/bin/coraenv
At the prompt, specify the SID for the database to be removed.
Start the Database Configuration Assistant:
$ dbca
The Welcome window appears.
Click Next.
The Operations window appears.
Select Delete a Database, then click Next.
Select the database to be deleted, then click Finish.
In the window that appears, confirm that you want to delete the database.
When Database Configuration Assistant removes the database, you are prompted to choose whether you want to perform another operation. Click Yes to return to the Operations screen or click No to exit from Database Configuration Assistant. To remove another database, click Yes and repeat steps 6 through 8.
The following steps describe how to use Oracle Universal 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.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 to be removed:
For Bourne, Bash, or Korn shell:
$ ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 $ export ORACLE_HOME
For C shell:
$ setenv ORACLE_HOME /u01/app/oracle/product/10.2.0/db_1
Remove any databases instances associated with this Oracle home.
Refer to the preceding sections for information about how to complete these tasks.
Stop any processes running in this Oracle home:
Process Name | Command |
---|---|
Oracle Net listener | $ORACLE_HOME/bin/lsnrctl stop |
iSQL*Plus | $ORACLE_HOME/bin/isqlplusctl stop |
Ultra Search | $ORACLE_HOME/bin/searchctl stop |
Start Oracle Universal Installer as follows:
$ $ORACLE_HOME/oui/bin/runInstaller
In the Welcome window, click Deinstall Products.
The Inventory screen appears, listing all of the Oracle homes on the system.
In the Inventory screen, select the Oracle home and the products to be removed, then click Remove.
Note:
If you choose to remove Oracle JVM, then Oracle Universal Installer removes all installed products that depend on Oracle JVM, including Oracle Database 10g.Oracle Universal Installer displays a confirmation window asking you to confirm that you want to deinstall the products and their dependent components.
Click Yes.
Oracle Universal Installer displays a progress indicator as it removes the software.
Click Close on the Inventory screen.
When the products have been deleted, click Cancel to exit from Oracle Universal Installer, and then click Yes.