How to delete an instance of oracle

To safely delete an Oracle instance, follow these steps: Back up all data. Stop the instance. Disconnect all connections. Uninstall Oracle software. Delete the instance directory. Remove instance from the registry (Windows only).

How to delete an instance in Oracle

Deleting an Oracle instance that is no longer needed is a not complicated process, but it involves multiple steps. This article will guide you through the entire process to ensure that instances are deleted safely and effectively.

Step 1: Backup Data

Be sure to back up all important data before deleting an instance. This can be achieved by using RMAN (Recovery Manager) or using the Oracle Data Pump Export utility.

Step 2: Stop the instance

Next, you need to stop the instance. You can use the following command:

 <code>$ORACLE_HOME/bin/sqlplus /nolog SQL> CONNECT SYS AS SYSDBA SQL> SHUTDOWN IMMEDIATE;</code>

Step 3: Disconnect all connections

Before continuing, make sure all users are disconnected from the instance. You can use the following command:

 <code>$ORACLE_HOME/bin/sqlplus /nolog SQL> CONNECT SYS AS SYSDBA SQL> SELECT username, status FROM v$session WHERE status = 'ACTIVE';</code>

After confirming that there is no active session, continue to the next step.

Step 4: Uninstall the software

Now you can uninstall the Oracle software. This can be done by running the following command:

 <code>$ORACLE_HOME/oui/bin/oui -delete -silent</code>

Step 5: Delete the instance directory

Finally, delete the Oracle instance directory. It is usually located in /u01/app/oracle/product/12.2.0/dbhome_1 .

Step 6: Delete the instance from the registry (Windows only)

If you delete an instance on a Windows system, you also need to delete it from the registry. You can use the following command:

 <code>regedit HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraDB12g_home1</code>

Right-click "KEY_OraDB12g_home1" and select "Delete".

By following these steps, you can safely and effectively delete Oracle instances. Remember that it is crucial to back up data before deleting an instance and be careful throughout the process.

The above is the detailed content of How to delete an instance of oracle. For more information, please follow other related articles on the PHP Chinese website!