oracle（Centos7.6）删除数据库实例

restrict mount方式加载数据库实例

[oracle@gr_vmuat_sjzt_gp05_041119 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 9 09:13:52 2021

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict mount;
ORACLE instance started.

Total System Global Area 1.3362E+10 bytes
Fixed Size                  2217952 bytes
Variable Size            6777997344 bytes
Database Buffers         6576668672 bytes
Redo Buffers                4960256 bytes
Database mounted.
SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> quit

删除实例数据文件和dump文件

[oracle@gr_vmuat_sjzt_gp05_041119 ~]$ find $ORACLE_BASE/ -name $ORACLE_SID
/usr/local/oracle/cfgtoollogs/dbca/etl
/usr/local/oracle/diag/rdbms/etl
/usr/local/oracle/diag/rdbms/etl/etl
/usr/local/oracle/admin/etl
/usr/local/oracle/flash_recovery_area/etl
/usr/local/oracle/oradata/etl
[oracle@gr_vmuat_sjzt_gp05_041119 ~]$ rm -rf /usr/local/oracle/cfgtoollogs/dbca/etl
[oracle@gr_vmuat_sjzt_gp05_041119 ~]$ rm -rf /usr/local/oracle/diag/rdbms/etl
[oracle@gr_vmuat_sjzt_gp05_041119 ~]$ rm -rf /usr/local/oracle/diag/rdbms/etl/etl
[oracle@gr_vmuat_sjzt_gp05_041119 ~]$ rm -rf /usr/local/oracle/admin/etl
[oracle@gr_vmuat_sjzt_gp05_041119 ~]$ rm -rf /usr/local/oracle/flash_recovery_area/etl
[oracle@gr_vmuat_sjzt_gp05_041119 ~]$ rm -rf /usr/local/oracle/oradata/etl

删除/etc/oratab里面实例

#切换到root或使用sudo
[root@gr_vmuat_sjzt_gp05_041119 ~]# vi /etc/oratab

参考文章

linux上如何删除oracle实例

Oracle数据库实例的创建、删除、修改