How to delete oracle database in linux

How to delete the Oracle database in Linux: 1. Use SQL*PLUS to stop the database; 2. Stop the Listener and HTTP services; 3. Log in to root; 4. Delete the installation directory and files under /usr/bin ; 5. Delete oratab and other files.

The operating environment of this article: linux5.9.8 system, Dell G3 computer, Oracle 11g version.

How to delete oracle database in Linux?

Linux uninstall Oracle 11G:

Uninstall oracle11G data

1. Use SQL*PLUS to stop the database

[oracle@OracleTest oracle]$ sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown [immediate]
SQL> exit

2. Stop Listener

[oracle@OracleTest oracle]$ lsnrctl stop

3. Stop HTTP service

[root@OracleTest /root]# service httpd stop

4. Use su or log in to root again (if you want Reinstallation can retain the oracle user, eliminating the need to enter environment variables)

5. Delete the installation directory

[root@OracleTest /root]# rm -rf /u01/app/oracle/

6. Delete the files under /usr/bin

[root@OracleTest /root]# rm /usr/local/bin/dbhome
[root@OracleTest /root]# rm /usr/local/bin/oraenv
[root@OracleTest /root]# rm /usr/local/bin/coraenv

7. Delete /etc/oratab

[root@OracleTest /root]# rm /etc/oratab

8. Delete /etc/oraInst.loc

[root@OracleTest /root]# rm /etc/oraInst.loc

9. Delete the oracle user (you don’t need to delete it if you want to reinstall it)

[root@OracleTest /root]# userdel –-remove oracle

10. Delete the user group (you don’t need to delete it if you want to reinstall it)

[root@OracleTest /root]# groupdel oinstall
[root@OracleTest /root]# groupdel dba

11. Delete the startup service

[root@OracleTest /root]# chkconfig --del dbora

After restarting your Linux The Oracle database under the system has been completely deleted! ! !

If you want to install again, it is best to do some backup work first.

Includes user login scripts, database automatic startup and shutdown scripts, and Listener automatic startup scripts.

If possible, even the script to create the database is saved.

Related recommendations: oracle database learning tutorial

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