Как удалить инстанс oracle
How to uninstall / completely remove Oracle 11g (client)?
deinstall.bat doesn't work.
unbelievable that this question was closed by mods, the post below was extremely helpful. Wish they would widen the community scope to include "anything helpful to developers".
@fuzzyanalysis: This question wasn't closed by Moderators. There are no diamonds next to those names. They're just users.
This question as 13 upvotes, 3 favorites, 1 reopen vote, and 69,870 views - yet is only 1 vote from being deleted, despite being a valuable resource. If this is considered off-topic for SO, what other site would better be considered on-topic? Would a moderator be able to move this to the correct site - or maybe even protect it, instead of having this knowledge essentially lost forever?
4 Answers 4
Assuming a Windows installation, do please refer to this:
- Uninstall all Oracle components using the Oracle Universal Installer (OUI).
- Run regedit.exe and delete the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key. This contains registry entires for all Oracle products.
- Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Ora* It should be pretty obvious which ones relate to Oracle.
- Reboot your machine.
- Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.
- Delete the "C:\Program Files\Oracle" directory.
- Empty the contents of your "C:\temp" directory.
- Empty your recycle bin.
- Be careful when following anything listed here (above or below), as doing so may remove or damage any other Oracle-installed products.
- For 64-bit Windows (x64), you need also to delete the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE key from the registry.
- Clean-up by removing any related shortcuts that were installed to the Start Menu.
- Clean-up environment variables:
- Consider removing %ORACLE_HOME% .
- Remove any paths no longer needed from %PATH% .
This set of instructions happens to match an almost identical process that I had reverse-engineered myself over the years after a few messed-up Oracle installs, and has almost always met the need.
Note that even if the OUI is no longer available or doesn't work, simply following the remaining steps should still be sufficient.
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:
If you want to remove an Oracle Real Application Clusters installation, refer to Oracle Real Application Clusters Installation and Configuration Guide for more information
If you want to remove an individual product, refer to the product-specific documentation for requirements and restrictions
6.1 Overview
To 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 and Automatic Storage Management instances.
Shut down processes.
Reconfigure the Oracle Cluster Synchronization Services Daemon, if necessary.
Remove the Oracle software.
6.2 Identifying All Instances
To identify all instances associated with the Oracle home that you want to remove, enter the following command:
The output of this command contains entries similar to the following:
These entries show that the +ASM Automatic Storage Manager instance and the CUST Oracle database instance are associated with the / u01/app/oracle/product/10.2.0/db_1 Oracle home directory.
6.3 Removing an Oracle Database
To completely remove Oracle Database software, you must remove any installed databases. To remove an Oracle database:
Removing an Oracle database deletes all of the data in the database. If you want to keep this data, make sure that you back up the database before deleting it.
Log in as the oracle user:
Run the oraenv or coraenv script to set the environment for the database that you want to remove, for example:
Bourne, Bash, or Korn shell:
At the prompt, specify the SID for the database that you want to remove.
Start the Database Configuration Assistant:
The Welcome window appears.
The Operations window appears.
Select Delete a Database , then click Next .
Select the database that you want to delete, 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. If you want to remove another database, click Yes and repeat steps 6 through 8.
6.4 Removing an Automatic Storage Management Instance
To completely remove Oracle database software, you must also remove any Automatic Storage Management instances running in the Oracle home. To remove an Automatic Storage Management instance:
If necessary, log in as the oracle user:
Run the oraenv or coraenv script to set the environment for the Automatic Storage Management instance that you want to remove, for example:
Bourne, Bash, or Korn shell:
At the prompt, specify the SID for the Automatic Storage Management instance that you want to remove.
Connect to the Automatic Storage Management instance as the SYS user:
Enter the following command to determine whether any Oracle database instance is using the Automatic Storage Management instance:
This command lists all of the database instances that are using this Automatic Storage Management instance.
This command only lists database instances that are running. It is possible that other instances are associated with the Automatic Storage Management instance, but they are not currently running.
If you removed a database from this Oracle home but the output from the command shows that this Automatic Storage Management instance is supporting a database instance in another Oracle home, do not remove the Automatic Storage Management instance or the Oracle home.
If there are no database instances associated with this Automatic Storage Management instance, drop the disk groups associated with this instance as follows:
Dropping the Automatic Storage Management disk group makes the disk device available for use with another Automatic Storage Management instance if required. However, all data in the disk group is lost. Make sure that no other database instance requires any data from this disk group before you drop it.
Identify the disk groups associated with the Automatic Storage Management instance:
For each disk group that you want to delete, enter a command similar to the following:
Enter the following command to shut down the Automatic Storage Management instance:
Remove the entry for the Automatic Storage Management instance from the /etc/oratab file.
6.5 Reconfiguring Oracle Cluster Synchronization Services
Oracle Cluster Synchronization Services (CSS) is a daemon process that is configured by the root.sh script when you configure an Automatic Storage Management instance. It is configured to start every time the system boots. This daemon process is required to enable synchronization between Oracle Automatic Storage Management and database instances. It must be running if an Oracle database is using Automatic Storage Management for database file storage.
On cluster systems with Oracle Real Application Clusters (RAC) installations, the CSS daemon is configured during the Oracle Clusterware installation. If the system is running Oracle CRS, refer to Oracle Real Application Clusters Installation and Configuration Guide for Linux for information about removing RAC or Oracle Clusterware.
Before you remove an Oracle Database 10 g Oracle home, you must determine whether the CSS daemon is running from that Oracle home and whether any other Oracle Database 10 g Oracle homes exist on the system:
If the Oracle Database 10 g Oracle home that you want to remove is the only Oracle Database 10 g installation on the system, you can delete the CSS daemon configuration.
If the CSS daemon is running from the Oracle Database 10 g Oracle home that you want to remove and other Oracle Database 10 g installations exist on the system, you must reconfigure the CSS daemon to run from another Oracle Database 10 g Oracle home.
The following sections describe how to complete these tasks:
6.5.1 Identifying Oracle Database 10 g Oracle Homes
To identify all of the Oracle Database 10 g Oracle home directories, enter the following command:
From the output, identify any Oracle home directories where Oracle Database 10 g is installed. Oracle homes that contain Oracle Database 10 g typically have paths similar to the following. However, they might use different paths.
If there is only one Oracle home directory that contains Oracle Database 10 g , refer to the "Deleting the Oracle CSS Daemon Configuration" section for information about deleting the Oracle CSS daemon configuration.
If you identify more than one Oracle Database 10 g Oracle home directory, refer to the following section for information about reconfiguring the Oracle CSS daemon.
6.5.2 Reconfiguring the Oracle CSS Daemon
To reconfigure the Oracle CSS daemon so that it runs from an Oracle home that you are not removing, follow these steps:
In all Oracle home directories on the system, stop all Oracle Automatic Storage Management instances and any Oracle Database instances that use Automatic Storage Management for database file storage.
Switch user to root .
Enter the following command to identify the Oracle home directory being used to run the CSS daemon:
The output from this command is similar to the following:
The ocrconfig_loc parameter specifies the location of the Oracle Cluster Registry (OCR) used by the CSS daemon. The path up to the cdata directory is the Oracle home directory where the CSS daemon is running ( /u01/app/oracle/product/10.2.0/db_1 in this example).
If the value of the local_only parameter is FALSE, Oracle Clusterware is installed on this system.
Oracle Real Application Clusters Installation and Configuration Guide for Linux for information about removing Oracle Real Applications Clusters or Oracle Clusterware
If this Oracle home directory is not the Oracle home that you want to remove, go to the "Removing Oracle Software" section.
Change directory to the Oracle home directory for an Oracle Database 10 g installation that you are not removing.
Set the ORACLE_HOME environment variable to specify the path to this Oracle home directory:
Bourne, Bash, or Korn shell:
Enter the following command to reconfigure the CSS daemon to run from this Oracle home:
This command stops the Oracle CSS daemon, reconfigures it in the new Oracle home, and then restarts it. When the system boots, the CSS daemon starts automatically from the new Oracle home.
To remove the original Oracle home directory, refer to the "Removing Oracle Software" section.
6.5.3 Deleting the Oracle CSS Daemon Configuration
To delete the Oracle CSS daemon configuration, follow these steps:
Delete the CSS daemon configuration only if you are certain that no other Oracle Database 10 g installation requires it.
Remove any databases or Automatic Storage Management instances associated with this Oracle home. Refer to the preceding sections for information about how to complete these tasks.
Switch user to root .
Change directory to the Oracle home directory that you are removing.
Set the ORACLE_HOME environment variable to specify the path to this Oracle home directory:
Bourne, Bash, or Korn shell:
Enter the following command to delete the CSS daemon configuration from this Oracle home:
The script stops the Oracle CSS daemon, then deletes its configuration. When the system boots, the CSS daemon no longer starts.
6.6 Removing Oracle Software
The following steps describe how to use Oracle Universal Installer to remove Oracle software from an Oracle home:
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:
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:
Remove any databases or Automatic Storage Management instances associated with this Oracle home and delete or reconfigure the Oracle CSS daemon.
Refer to the preceding sections for information about how to complete these tasks.
Stop any processes running in this Oracle home:
Process Name Command Database Control $ORACLE_HOME/bin/emctl stop dbconsole Oracle Net listener $ORACLE_HOME/bin/lsnrctl stop i SQL*Plus $ORACLE_HOME/bin/isqlplusctl stop Ultra Search $ORACLE_HOME/bin/searchctl stop
Start Oracle Universal Installer as follows:
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 that you want to remove, then click Remove .
If you choose to remove Oracle JVM, Oracle Universal Installer removes all installed products that depend on Oracle JVM, including Oracle Database 10 g .
Oracle Universal Installer displays a confirmation window asking you to confirm that you want to deinstall the products and their dependent components.
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 .
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:
If you want to remove an Oracle Real Application Clusters installation, refer to Oracle Real Application Clusters Installation and Configuration Guide for more information
If you want to remove an individual product, refer to the product-specific documentation for requirements and restrictions
6.1 Overview
To 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 and Automatic Storage Management instances.
Shut down processes.
Reconfigure the Oracle Cluster Synchronization Services Daemon, if necessary.
Remove the Oracle software.
6.2 Identifying All Instances
To identify all instances associated with the Oracle home that you want to remove, enter the following command:
The output of this command contains entries similar to the following:
These entries show that the +ASM Automatic Storage Manager instance and the CUST Oracle database instance are associated with the / u01/app/oracle/product/10.2.0/db_1 Oracle home directory.
6.3 Removing an Oracle Database
To completely remove Oracle Database software, you must remove any installed databases. To remove an Oracle database:
Removing an Oracle database deletes all of the data in the database. If you want to keep this data, make sure that you back up the database before deleting it.
Log in as the oracle user:
Run the oraenv or coraenv script to set the environment for the database that you want to remove, for example:
Bourne, Bash, or Korn shell:
At the prompt, specify the SID for the database that you want to remove.
Start the Database Configuration Assistant:
The Welcome window appears.
The Operations window appears.
Select Delete a Database , then click Next .
Select the database that you want to delete, 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. If you want to remove another database, click Yes and repeat steps 6 through 8.
6.4 Removing an Automatic Storage Management Instance
To completely remove Oracle database software, you must also remove any Automatic Storage Management instances running in the Oracle home. To remove an Automatic Storage Management instance:
If necessary, log in as the oracle user:
Run the oraenv or coraenv script to set the environment for the Automatic Storage Management instance that you want to remove, for example:
Bourne, Bash, or Korn shell:
At the prompt, specify the SID for the Automatic Storage Management instance that you want to remove.
Connect to the Automatic Storage Management instance as the SYS user:
Enter the following command to determine whether any Oracle database instance is using the Automatic Storage Management instance:
This command lists all of the database instances that are using this Automatic Storage Management instance.
This command only lists database instances that are running. It is possible that other instances are associated with the Automatic Storage Management instance, but they are not currently running.
If you removed a database from this Oracle home but the output from the command shows that this Automatic Storage Management instance is supporting a database instance in another Oracle home, do not remove the Automatic Storage Management instance or the Oracle home.
If there are no database instances associated with this Automatic Storage Management instance, drop the disk groups associated with this instance as follows:
Dropping the Automatic Storage Management disk group makes the disk device available for use with another Automatic Storage Management instance if required. However, all data in the disk group is lost. Make sure that no other database instance requires any data from this disk group before you drop it.
Identify the disk groups associated with the Automatic Storage Management instance:
For each disk group that you want to delete, enter a command similar to the following:
Enter the following command to shut down the Automatic Storage Management instance:
Remove the entry for the Automatic Storage Management instance from the /etc/oratab file.
6.5 Reconfiguring Oracle Cluster Synchronization Services
Oracle Cluster Synchronization Services (CSS) is a daemon process that is configured by the root.sh script when you configure an Automatic Storage Management instance. It is configured to start every time the system boots. This daemon process is required to enable synchronization between Oracle Automatic Storage Management and database instances. It must be running if an Oracle database is using Automatic Storage Management for database file storage.
On cluster systems with Oracle Real Application Clusters (RAC) installations, the CSS daemon is configured during the Oracle Clusterware installation. If the system is running Oracle CRS, refer to Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for AIX Based Systems for information about removing RAC or Oracle Clusterware.
Before you remove an Oracle Database 10 g Oracle home, you must determine whether the CSS daemon is running from that Oracle home and whether any other Oracle Database 10 g Oracle homes exist on the system:
If the Oracle Database 10 g Oracle home that you want to remove is the only Oracle Database 10 g installation on the system, you can delete the CSS daemon configuration.
If the CSS daemon is running from the Oracle Database 10 g Oracle home that you want to remove and other Oracle Database 10 g installations exist on the system, you must reconfigure the CSS daemon to run from another Oracle Database 10 g Oracle home.
The following sections describe how to complete these tasks:
6.5.1 Identifying Oracle Database 10 g Oracle Homes
To identify all of the Oracle Database 10 g Oracle home directories, enter the following command:
From the output, identify any Oracle home directories where Oracle Database 10 g is installed. Oracle homes that contain Oracle Database 10 g typically have paths similar to the following. However, they might use different paths.
If there is only one Oracle home directory that contains Oracle Database 10 g , refer to the "Deleting the Oracle CSS Daemon Configuration" section for information about deleting the Oracle CSS daemon configuration.
If you identify more than one Oracle Database 10 g Oracle home directory, refer to the following section for information about reconfiguring the Oracle CSS daemon.
6.5.2 Reconfiguring the Oracle CSS Daemon
To reconfigure the Oracle CSS daemon so that it runs from an Oracle home that you are not removing, follow these steps:
In all Oracle home directories on the system, stop all Oracle Automatic Storage Management instances and any Oracle Database instances that use Automatic Storage Management for database file storage.
Switch user to root .
Enter the following command to identify the Oracle home directory being used to run the CSS daemon:
The output from this command is similar to the following:
The ocrconfig_loc parameter specifies the location of the Oracle Cluster Registry (OCR) used by the CSS daemon. The path up to the cdata directory is the Oracle home directory where the CSS daemon is running ( /u01/app/oracle/product/10.2.0/db_1 in this example).
If the value of the local_only parameter is FALSE, Oracle Clusterware is installed on this system.
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for AIX Based Systems for information about removing Oracle Real Applications Clusters or Oracle Clusterware
If this Oracle home directory is not the Oracle home that you want to remove, go to the "Removing Oracle Software" section.
Change directory to the Oracle home directory for an Oracle Database 10 g installation that you are not removing.
Set the ORACLE_HOME environment variable to specify the path to this Oracle home directory:
Bourne, Bash, or Korn shell:
Enter the following command to reconfigure the CSS daemon to run from this Oracle home:
This command stops the Oracle CSS daemon, reconfigures it in the new Oracle home, and then restarts it. When the system boots, the CSS daemon starts automatically from the new Oracle home.
To remove the original Oracle home directory, refer to the "Removing Oracle Software" section.
6.5.3 Deleting the Oracle CSS Daemon Configuration
To delete the Oracle CSS daemon configuration, follow these steps:
Delete the CSS daemon configuration only if you are certain that no other Oracle Database 10 g installation requires it.
Remove any databases or Automatic Storage Management instances associated with this Oracle home. Refer to the preceding sections for information about how to complete these tasks.
Switch user to root .
Change directory to the Oracle home directory that you are removing.
Set the ORACLE_HOME environment variable to specify the path to this Oracle home directory:
Bourne, Bash, or Korn shell:
Enter the following command to delete the CSS daemon configuration from this Oracle home:
The script stops the Oracle CSS daemon, then deletes its configuration. When the system boots, the CSS daemon no longer starts.
6.6 Removing Oracle Software
The following steps describe how to use Oracle Universal Installer to remove Oracle software from an Oracle home:
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:
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:
Remove any databases or Automatic Storage Management instances associated with this Oracle home and delete or reconfigure the Oracle CSS daemon.
Refer to the preceding sections for information about how to complete these tasks.
Stop any processes running in this Oracle home:
Process Name Command Database Control $ORACLE_HOME/bin/emctl stop dbconsole Oracle Net listener $ORACLE_HOME/bin/lsnrctl stop i SQL*Plus $ORACLE_HOME/bin/isqlplusctl stop Ultra Search $ORACLE_HOME/bin/searchctl stop
The Inventory screen appears, 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 .
If you choose to remove Oracle JVM, Oracle Universal Installer removes all installed products that depend on Oracle JVM, including Oracle Database 10 g .
Oracle Universal Installer displays a confirmation window asking you to confirm that you want to deinstall the products and their dependent components.
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 .
Как полностью удалить клиент Oracle 11g с моего компьютера? Я использую Windows 7, 64-битную версию.
Я пытался бежать deinstall.bat , но это не работает.
Сначала используйте Пуск -> Выполнить -> Services.msc, найдите все службы Ora * и остановите их.
- Удалите все компоненты Oracle с помощью универсального установщика Oracle (OUI).
- Удалите HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE (и HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE на 64-битном) ключ, который содержит записи реестра для всех продуктов Oracle, с помощью regedit.
- Удалите все ссылки на Oracle услуги / компоненты в следующем разделе реестра: HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/ . Ищет ключевые записи, начинающиеся с «Ora», которые, очевидно, связаны с Oracle.
- Перезагрузите рабочую станцию.
- Удалите каталог ORACLE_BASE. (т.е. C: \ Oracle)
- Удалить каталог C:\Program Files\Oracle .
- Очистите временный каталог.
- Опорожните корзину.
- Удалите все записи оракула в переменной PATH в разделе «Компьютер»> «Свойства»> «Дополнительные параметры системы» => «Переменная среды» => «PATH».
- Там же удалите запись ORACLE_HOME
У меня есть совет: нажмите Ctrl + R, нажмите:, SystemPropertiesAdvanced чтобы открыть диалог, подготовка к редактированию переменных среды. Помните , удалить несколько: ORACLE_UID . Ищите все ключевые слова Oracle в реестре.
Шаги: сначала остановите все службы Oracle.
- START -> RUN -> Services.msc
- Найдите все услуги Ora * и нажмите СТОП
- Пуск -> RUN -> Regedit
- Найдите в реестре папку HKEY_LOCAL_MACHINE
- Открыть папку с программным обеспечением
- Удалите папку Oracle в разделе «Программное обеспечение».
- Откройте системную папку в HKEY_LOCAL_MACHINE
- Откройте папку CurrentControlSet в системной папке
- Открытые услуги
- Удалите все ключи, связанные с Oracle. Каждый ключ начинается с «ORA ..»
- Закрыть регедит
- Удалить папку ORACLE_HOME
- Удалить папку Oracle в Program Files
- перезагружать
«Установщик обнаружил уже существующий экземпляр XE в этой системе. Установка не может быть продолжена»
Конечно, я убрал все по разным источникам, включая этот, но он продолжал жаловаться. Он также не отображается в списке установленных программ.
Я вспомнил очень старую утилиту, которая была поставлена однажды с Office 2000, я думаю. Она называется «Утилита очистки установщика Windows» (оригинальная загрузка называется msicuu2.exe ). Загрузите его из надежного источника, запустите его с правами администратора, и вы, вероятно, найдете в списке потерянную запись для Oracle.
Нажмите [Удалить], подтвердите предупреждение и продолжите настройку. Это сработало для меня.
I was experimenting with vm instances in the cloud, trying to make a Minecraft server like in this guide, but I ended up making two instances that I want/need to get rid of. I tried terminating them, but I can't get rid of them. I have a free account and I already got one instance to work, but I want to know how to delete the two terminated ones so I can use the free space for other things because as-is, I can not make any more without paying for them.
So if you want to terminate an instance, just log into the OCI console, using the three line stack menu on the top left navigate to the Compute section. From there be sure you are in the right compartment and region. Click on the name of the instance you want to terminate.
On the new page that loads, click the "More Actions" button on the top middle of the page and select terminate. . This will wipe the instance from the face of the earth, there is no coming back from a terminated instance if you choose to delete the boot volume along with it.
The instance will still hang out in the console list for a bit, but once its terminated the text on the instance will be grayed out.
If I recall correctly. After termination it gets deleted after a while.
A terminated instance is deleted. It's gone and irretrievable not just off. You aren't being billed for it, and it's not counting against your limits. All you are seeing is a record of an instance you used to have just in case you need data about it, and even that record will eventually be cleaned up. Since you mention free space it's possible you didn't delete your boot volume. When you launched the instance you very likely also created a boot volume for it. When you terminated the instance you may not have chosen to delete that volume. I think by default you don't. That's because it holds your data, and you could launched a new instance with that volume attached and access your data again. I think you can see your boot volume from that terminated instance record you were trying to delete. You can also go to a list of boot volumes and see what you have there.
Читайте также: