windows环境下删除Oracle数据库实例

windows删除数据库实例和服务名

第一步；删除数据库

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

Total System Global Area 1.2827E+10 bytes
Fixed Size                  2293216 bytes
Variable Size            2550137376 bytes
Database Buffers         1.0268E+10 bytes
Redo Buffers                7282688 bytes
Database mounted.
SQL> drop database;

Database dropped.

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

第二步：删除服务名

oradim -delete -sid prod

第三步：重建数据库

dbca