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!